Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0002996 | Openbravo ERP | 01. General setup | public | 2008-06-09 09:01 | 2008-11-06 10:01 |
| Reporter | user71 | ||||
| Assigned To | dalsasua | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | 2.40 | Fixed in Version | 2.40 | ||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0002996: Initial Client Set up failed with a specific COA | ||||
| Description | Version: Openbravo Network MP5 Customer: Productos Montblanc Making an Initial Client Set Up using "AccountsESOpenbravo_PGCgral2007V3.csv" i get the error attached. If "AccountsESOpenbravo_PGCpyme2007v8.csv" is used, it works. The Openbravo log: org.openbravo.erpCommon.ad_forms.InitialClientSetupData - SQL error in query: INSERT INTO C_ElementValue (C_ELEMENTVALUE_ID,C_ELEMENT_ID, AD_CLIENT_ID,AD_ORG_ID,ISACTIVE,CREATED,CREATEDBY,UPDATED,UPDATEDBY, VALUE,NAME,DESCRIPTION,ACCOUNTTYPE,ACCOUNTSIGN,ISDOCCONTROLLED,ISSUMMARY,VALIDFROM,VALIDTO, POSTACTUAL,POSTBUDGET,POSTENCUMBRANCE,POSTSTATISTICAL,ISBANKACCOUNT,C_BANKACCOUNT_ID,ISFOREIGNCURRENCY,C_CURRENCY_ID, ELEMENTLEVEL) VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),'Y',now(),0,now(),0,?,?,?,?,?,?,?,NULL,NULL,'Y','Y','Y','Y', 'N',NULL, 'N',NULL,COALESCE(SUBSTR(?,0,1),'S'))Exception:java.sql.SQLException: ORA-00001: unique constraint (TAD.C_ELEMENTVALUE_VALUE) violated But i have run the "ad_update_sequence" and try again, but it fails. | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-06-13 18:30 | psarobe | Status | new => scheduled | ||
| 2008-06-13 19:59 | cromero | Target Version | => 2.40 | ||
| 2008-06-25 12:00 | svnbot | Checkin | |||
| 2008-06-25 12:00 | svnbot | Note Added: 0008009 | |||
| 2008-06-25 12:00 | svnbot | Status | scheduled => resolved | ||
| 2008-06-25 12:00 | svnbot | Resolution | open => fixed | ||
| 2008-06-25 12:00 | svnbot | svn_revision | => 100 | ||
| 2008-11-06 10:01 | psarobe | Regression testing | => No | ||
| 2008-11-06 10:01 | psarobe | Status | resolved => closed | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||