Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006614Openbravo ERPA. Platformpublic2008-12-17 14:332009-04-21 11:09
jpabloae 
iperdomo 
highmajorhave not tried
closedfixed 
30Gentoo - 2.6.26
pi 
 
Core
No
0006614: create.database error in constraint
There is an error when creating the database using Oracle:

create.database.structure:
[createdatabase] Database connection: jdbc:oracle:thin:@localhost:1521:ob14. User: TAD_TRUNK
[createdatabase] Executing default prescript
[createdatabase] Executed 7 SQL command(s) with 0 error(s)
[createdatabase] Executing creation script
[createdatabase] for the complete database
[createdatabase] SQL Command failed with: ORA-02264: name already used by an existing constraint
[createdatabase]
[createdatabase] -- END
[createdatabase] ALTER TABLE AD_FIELD
[createdatabase] ADD CONSTRAINT ADMODULE_ADFIELD FOREIGN KEY (AD_MODULE_ID) REFERENCES AD_MODULE (AD_MODULE_ID)
[createdatabase] Executed 4703 SQL command(s) with 1 error(s)
[createdatabase] Executing default postscript
[createdatabase] Executed 13 SQL command(s) with 0 error(s)
1. check out trunk, r11291.
2. configure it using the setup-tools.
3. ant install.source
No tags attached.
Issue History
2008-12-17 14:33jpabloaeNew Issue
2008-12-17 14:33jpabloaeAssigned To => rafaroda
2008-12-17 14:33jpabloaesf_bug_id0 => 2440110
2008-12-17 14:33jpabloaeRegression testing => No
2008-12-18 17:08rafarodaStatusnew => scheduled
2008-12-18 17:08rafarodaAssigned Torafaroda => gorka_gil
2008-12-18 17:08rafarodafix_in_branch => trunk
2008-12-19 12:35gorka_gilAssigned Togorka_gil => marvintm
2008-12-31 13:55iciordiaAssigned Tomarvintm => iciordia
2008-12-31 14:16iciordiaStatusscheduled => closed
2008-12-31 14:16iciordiaNote Added: 0011795
2008-12-31 14:16iciordiaResolutionopen => out of date
2009-01-02 11:34jpabloaeStatusclosed => new
2009-01-02 11:34jpabloaeResolutionout of date => open
2009-01-02 11:34jpabloaeNote Added: 0011842
2009-01-02 11:55iciordiaNote Added: 0011845
2009-01-02 11:55iciordiaAssigned Toiciordia => jpabloae
2009-01-02 11:55iciordiaAssigned Tojpabloae => iperdomo
2009-01-02 11:57iperdomoStatusnew => scheduled
2009-01-02 11:59svnbotCheckin
2009-01-02 11:59svnbotNote Added: 0011846
2009-01-02 11:59svnbotStatusscheduled => resolved
2009-01-02 11:59svnbotResolutionopen => fixed
2009-01-02 11:59svnbotsvn_revision => 11631
2009-04-21 11:09psarobeStatusresolved => closed

Notes
(0011795)
iciordia   
2008-12-31 14:16   
Testing in revision 11625 the bug is not present any more
(0011842)
jpabloae   
2009-01-02 11:34   
This is still reproducible in trunk r11630. Please make sure you're not falling into issue 0006766
(0011845)
iciordia   
2009-01-02 11:55   
Juan Pablo,

you are right, I had experiencing issue 6766, sorry for inconvenience.

The root cause of the problem is that table AD_EXCEPTIONS is declaring a constraint named ADMODULE_ADFIELD. It can be solved by renaming it to ADMODULE_ADEXCEPTIONS.

Ismael
(0011846)
svnbot   
2009-01-02 11:59   
Repository: openbravo
Revision: 11631
Author: iperdomo
Date: 2009-01-02 11:59:42 +0100 (Fri, 02 Jan 2009)

Fixes issue 6614: Renamed constraint from ADMODULE_ADFIELD to ADMODULE_ADEXCEPTIONS

---
U trunk/src-db/database/model/tables/AD_EXCEPTIONS.xml
---

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