Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009472 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | have not tried | 2009-06-15 12:17 | 2009-09-08 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | urgent | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| Projection | none | ETA | none | Target Version | 2.40MP9 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP8 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009472: Error importing Chart of Account | |||||||
| Description | I 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 Reproduce | Go 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  accountTest.csv [^] (379 bytes) 2009-08-31 11:11 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0017295) jpabloae (viewer) 2009-06-15 12:25 |
Reported in the wrong project, moving and reassigning to triage. |
|
(0017689) psarobe (viewer) 2009-06-30 19:49 |
Please tell us the product version |
|
(0019269) rafaroda (viewer) 2009-08-28 15:06 |
Reminder sent to: networkb Please provide Openbravo ERP version and the accounting file. Thanks. |
|
(0019332) rafaroda (viewer) 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 (viewer) 2009-08-31 12:52 |
This issue also reproduces in pi. |
|
(0019452) plujan (viewer) 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. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-15 12:17 | networkb | New Issue | |
| 2009-06-15 12:17 | networkb | Assigned To | => jpabloae |
| 2009-06-15 12:17 | networkb | OBNetwork customer | => No |
| 2009-06-15 12:24 | jpabloae | Project | Openbravo Deployment Options => Openbravo ERP |
| 2009-06-15 12:24 | jpabloae | Assigned To | jpabloae => rafaroda |
| 2009-06-15 12:25 | jpabloae | Note Added: 0017295 | |
| 2009-06-15 12:25 | jpabloae | Category | Basic Network => 01. General setup |
| 2009-06-30 19:49 | psarobe | Note Added: 0017689 | |
| 2009-06-30 19:49 | psarobe | Status | new => feedback |
| 2009-08-28 15:05 | rafaroda | OBNetwork customer | No => Yes |
| 2009-08-28 15:05 | rafaroda | Priority | normal => immediate |
| 2009-08-28 15:06 | rafaroda | Note Added: 0019269 | |
| 2009-08-31 10:41 | networkb | version | => 2.40MP8 |
| 2009-08-31 11:11 | networkb | File Added: accountTest.csv | |
| 2009-08-31 12:04 | rafaroda | Status | feedback => new |
| 2009-08-31 12:49 | rafaroda | Note Added: 0019332 | |
| 2009-08-31 12:52 | rafaroda | Assigned To | rafaroda => eduardo_Argal |
| 2009-08-31 12:52 | rafaroda | Priority | immediate => high |
| 2009-08-31 12:52 | rafaroda | Status | new => scheduled |
| 2009-08-31 12:52 | rafaroda | Note Added: 0019333 | |
| 2009-08-31 12:52 | rafaroda | fix_in_branch | => pi |
| 2009-09-01 09:32 | rafaroda | Target Version | => 2.40MP9 |
| 2009-09-01 09:32 | rafaroda | fix_in_branch | pi => |
| 2009-09-03 15:47 | plujan | Note Added: 0019452 | |
| 2009-09-03 15:47 | plujan | Priority | high => urgent |
| 2009-09-03 15:47 | plujan | Severity | minor => major |
| 2009-09-07 12:42 | psarobe | Status | scheduled => feedback |
| 2009-09-07 12:42 | psarobe | Status | feedback => scheduled |
| 2009-09-07 12:42 | psarobe | fix_in_branch | => pi |
| 2009-09-07 12:43 | eduardo_Argal | Status | scheduled => closed |
| 2009-09-07 12:43 | eduardo_Argal | Resolution | open => unable to reproduce |
| 2009-09-08 00:00 | anonymous | sf_bug_id | 0 => 2853886 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |