Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009472Openbravo ERP01. General setuppublic2009-06-15 12:172009-09-08 00:00
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version2.40MP8 
Target Version2.40MP9Fixed in Version 
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
Summary0009472: Error importing Chart of Account
DescriptionI receive and error message when importing the accounting file of a new client.
The error is the following : "javax.servlet.ServeltException:@CODE=0@ERROR:null value column "p_expense_acct" violates not null constraint.
I have found that this is because the blank spaces you leave, after writing a column, in the default_account column. I think the same problem will occur in all the columns of the importing chart of account file.
Steps To ReproduceGo to:

General Setup||Client||Initial Client Setup||Initial Client Setup -> create the client and import the accounting file. The file has to contain blank spaces after a word.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00104372.40MP9 closed eduardo_Argal Error importing Chart of Account 
depends on backport 00105022.40MP9 closed eduardo_Argal Error importing Chart of Account 
Attached Filescsv accountTest.csv (379) 2009-08-31 11:11
https://issues.openbravo.com/file_download.php?file_id=1688&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-06-15 12:17networkbNew Issue
2009-06-15 12:17networkbAssigned To => jpabloae
2009-06-15 12:17networkbOBNetwork customer => No
2009-06-15 12:24jpabloaeProjectOpenbravo Deployment Options => Openbravo ERP
2009-06-15 12:24jpabloaeAssigned Tojpabloae => rafaroda
2009-06-15 12:25jpabloaeNote Added: 0017295
2009-06-15 12:25jpabloaeCategoryBasic Network => 01. General setup
2009-06-30 19:49psarobeNote Added: 0017689
2009-06-30 19:49psarobeStatusnew => feedback
2009-08-28 15:05rafarodaOBNetwork customerNo => Yes
2009-08-28 15:05rafarodaPrioritynormal => immediate
2009-08-28 15:06rafarodaNote Added: 0019269
2009-08-31 10:41networkbversion => 2.40MP8
2009-08-31 11:11networkbFile Added: accountTest.csv
2009-08-31 12:04rafarodaStatusfeedback => new
2009-08-31 12:49rafarodaNote Added: 0019332
2009-08-31 12:52rafarodaAssigned Torafaroda => eduardo_Argal
2009-08-31 12:52rafarodaPriorityimmediate => high
2009-08-31 12:52rafarodaStatusnew => scheduled
2009-08-31 12:52rafarodaNote Added: 0019333
2009-08-31 12:52rafarodafix_in_branch => pi
2009-09-01 09:32rafarodaTarget Version => 2.40MP9
2009-09-01 09:32rafarodafix_in_branchpi =>
2009-09-03 15:47plujanNote Added: 0019452
2009-09-03 15:47plujanPriorityhigh => urgent
2009-09-03 15:47plujanSeverityminor => major
2009-09-07 12:42psarobeStatusscheduled => feedback
2009-09-07 12:42psarobeStatusfeedback => scheduled
2009-09-07 12:42psarobefix_in_branch => pi
2009-09-07 12:43eduardo_ArgalStatusscheduled => closed
2009-09-07 12:43eduardo_ArgalResolutionopen => unable to reproduce
2009-09-08 00:00anonymoussf_bug_id0 => 2853886

Notes
(0017295)
jpabloae   
2009-06-15 12:25   
Reported in the wrong project, moving and reassigning to triage.
(0017689)
psarobe   
2009-06-30 19:49   
Please tell us the product version
(0019269)
rafaroda   
2009-08-28 15:06   
Reminder sent to: networkb

Please provide Openbravo ERP version and the accounting file.

Thanks.
(0019332)
rafaroda   
2009-08-31 12:49   
Error log:

20:49:38 [http-8585-Processor22] ERROR org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO C_ACCTSCHEMA_GL (C_AcctSchema_Gl_ID, AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_ACCTSCHEMA_ID, USESUSPENSEBALANCING,SUSPENSEBALANCING_ACCT,USESUSPENSEERROR,SUSPENSEERROR_ACCT,USECURRENCYBALANCING, CURRENCYBALANCING_ACCT,RETAINEDEARNING_ACCT,INCOMESUMMARY_ACCT,INTERCOMPANYDUETO_ACCT,INTERCOMPANYDUEFROM_ACCT, PPVOFFSET_ACCT) VALUES (TO_NUMBER(?),TO_NUMBER(?),0,'Y',now(),0,now(),0,TO_NUMBER(?), 'Y',TO_NUMBER(?),'Y',TO_NUMBER(?),'Y', TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?), TO_NUMBER(?))Exception:org.postgresql.util.PSQLException: ERROR: el valor null para la columna «incomesummary_acct» viola la restricción not null
20:49:38 [http-8585-Processor22] WARN org.openbravo.erpCommon.ad_forms.InitialClientSetup - javax.servlet.ServletException: @CODE=0@ERROR: el valor null para la columna «incomesummary_acct» viola la restricción not null
(0019333)
rafaroda   
2009-08-31 12:52   
This issue also reproduces in pi.
(0019452)
plujan   
2009-09-03 15:47   
Raised both priority and severity. It can be also reproduced in 2.3x branch and prevents Smoke Tests to run properly.