Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005933
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2008-11-12 12:342008-12-01 11:31
ReporternetworkbView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10356
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS Version240 SMBDatabase versionAnt version
Product Version2.40SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005933: error to create a new element in account schema general ledger

DescriptionIn Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema || General Ledger, application don't work when you try create a new record, in new schema account.
Application return error
"This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"
Steps To ReproduceFinancial Management || Accounting || Setup || Accounting Schema || Accounting Schema -> create a new registry -> OK

Financial Management || Accounting || Setup || Account Tree || Element -> create a new element and new element value

Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema || General Ledger -> select Income Summary and save, then error.
Proposed SolutionThe problem is because the tab "general ledger" have the same column like parent column and key column.

To solve this problem, you have create a new key column in C_ACCTSCHEMA_GL table
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0005944 closededuardo_Argal error to create a new element in account schema general ledger 
has duplicate defect 00026642.40 closediperdomo QA-MAS General ledger Tab error inserting 

-  Notes
(0010201)
rafaroda (viewer)
2008-11-12 17:39

 Please provide the required information about the version of Openbravo ERP, database, Operating system, etc... http://wiki.openbravo.com/wiki/Bug_Reporting_Guidelines [^]
(0010236)
rafaroda (viewer)
2008-11-13 09:13

 Error in Tomcat log when saving:

09:10:48 [http-8385-Processor23] ERROR org.openbravo.erpWindows.AccountingSchema.GeneralLedgerData - SQL error in query: INSERT INTO C_AcctSchema_GL (AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, IsActive, UseSuspenseBalancing, SuspenseBalancing_Acct, UseSuspenseError, SuspenseError_Acct, UseCurrencyBalancing, CurrencyBalancing_Acct, RetainedEarning_Acct, IncomeSummary_Acct, CFS_Order_Acct, IntercompanyDueTo_Acct, IntercompanyDueFrom_Acct, PPVOffset_Acct, created, createdby, updated, updatedBy) VALUES (TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), (?), (?), TO_NUMBER(?), (?), TO_NUMBER(?), (?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), now(), to_number(?), now(), to_number(?))Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "c_acctschema_gl" violates foreign key constraint "cacctschema_cacctschemagl"
  Detail: Key (c_acctschema_id)=(0) is not present in table "c_acctschema".
(0010474)
svnbot (viewer)
2008-11-20 20:40

 Repository: openbravo
Revision: 10356
Author: eduardoargal
Date: 2008-11-20 20:38:12 +0100 (Thu, 20 Nov 2008)

Fixes bug 0005933: error to create a new element in account schema general ledger (3 Hrs)

---
U trunk/src/org/openbravo/erpCommon/ad_forms/InitialClientSetup_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_forms/InitialOrgSetup_data.xsql
U trunk/src/org/openbravo/erpCommon/ad_process/ImportAccount_data.xsql
U trunk/src-db/database/model/tables/C_ACCTSCHEMA_GL.xml
U trunk/src-db/database/sampledata/C_ACCTSCHEMA_GL.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
U trunk/src-db/database/sourcedata/AD_ELEMENT.xml
U trunk/src-db/database/sourcedata/AD_FIELD.xml
U trunk/src-db/database/sourcedata/AD_TABLE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10356&sc=1 [^]
(0010836)
krishna (viewer)
2008-12-01 11:31

 Tested in Windows/postgres and linux/oracle

- Issue History
Date Modified Username Field Change
2008-11-12 12:34 networkb New Issue
2008-11-12 12:34 networkb Assigned To => rafaroda
2008-11-12 12:34 networkb sf_bug_id 0 => 2268975
2008-11-12 12:34 networkb OBNetwork customer => Yes
2008-11-12 12:34 networkb Regression testing => No
2008-11-12 17:39 rafaroda Note Added: 0010201
2008-11-12 17:39 rafaroda Status new => feedback
2008-11-13 08:57 networkb OS 5 => 30
2008-11-13 08:57 networkb version => 2.40
2008-11-13 09:13 rafaroda Note Added: 0010236
2008-11-13 09:28 networkb Proposed Solution updated
2008-11-13 09:28 networkb Steps to Reproduce Updated
2008-11-13 09:28 networkb Issue Monitored: networkb
2008-11-13 09:37 rafaroda Status feedback => scheduled
2008-11-13 09:37 rafaroda Assigned To rafaroda => eduardo_Argal
2008-11-13 09:37 rafaroda fix_in_branch => trunk
2008-11-13 10:25 networkb OS Version => 240 SMB
2008-11-13 10:25 networkb fix_in_branch trunk =>
2008-11-20 20:40 svnbot Checkin
2008-11-20 20:40 svnbot Note Added: 0010474
2008-11-20 20:40 svnbot Status scheduled => resolved
2008-11-20 20:40 svnbot Resolution open => fixed
2008-11-20 20:40 svnbot svn_revision => 10356
2008-12-01 11:31 krishna Status resolved => closed
2008-12-01 11:31 krishna Note Added: 0010836
2009-01-09 19:17 rafaroda Relationship added has duplicate 0002664

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker