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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002996
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2008-06-09 09:012008-11-06 10:01
Reporteruser71View Statuspublic 
Assigned Todalsasua 
PrioritynormalResolutionfixedFixed in Version2.40
StatusclosedFix in branchFixed in SCM revision100
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002996: Initial Client Set up failed with a specific COA

DescriptionVersion: 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.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0006585)
user71
2005-06-01 00:00
edited on: 2008-06-12 09:43

This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1988644 [^]
(0008009)
svnbot (viewer)
2008-06-25 12:00

Repository: localization
Revision: 100
Author: davidalsasua
Date: 2008-06-25 12:00:46 +0200 (Wed, 25 Jun 2008)

Fixes bug 0002996: Initial Client Set up failed with a specific COA

---
A accounting/AccountsESOpenbravo_PGCgral2007V6.csv
A accounting/AccountsESOpenbravo_PGCpyme2007v10.csv
---

https://dev.openbravo.com/websvn/localization/?rev=100&sc=1 [^]

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker