Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0005955Openbravo ERPY. DBSourceManagerpublic2008-11-13 15:262009-04-22 00:00
marvintm 
marvintm 
immediatecriticalalways
closedfixed 
5
 
 
Core
No
0005955: Triggers and foreign keys are not disabled before inserting data into the database
When doing a create.database task in r2.50, triggers and foreign keys should be disabled before inserting data into the database. However, they are not.
Just do a ant create.database. Strange errors such as this one:


BUILD FAILED
/home/openbravo/workspaces/modularity/openbravo/build.xml:342: The following error occurred while executing this line:
/home/openbravo/workspaces/modularity/openbravo/src-db/database/build-create.xml:69: org.apache.ddlutils.DdlUtilsException: org.apache.ddlutils.io.DataSinkException: org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ORA-01403: No se ha encontrado ningún dato
ORA-06512: en "TAD_TRUNK.AD_IMPFORMAT_MOD_TRG", línea 38
ORA-04088: error durante la ejecución del disparador 'TAD_TRUNK.AD_IMPFORMAT_MOD_TRG'



will appear
Triggers and foreign keys have to be disabled before inserting data.
dbsm_migrate
Issue History
2008-11-13 15:26marvintmNew Issue
2008-11-13 15:26svnbotCheckin
2008-11-13 15:26svnbotNote Added: 0010250
2008-11-13 15:26svnbotStatusnew => resolved
2008-11-13 15:26svnbotResolutionopen => fixed
2008-11-13 15:26svnbotsvn_revision => 175
2008-11-13 15:27svnbotCheckin
2008-11-13 15:27svnbotNote Added: 0010251
2008-11-13 15:27svnbotsvn_revision175 => 9995
2008-11-28 12:54jpabloaeAssigned To => marvintm
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-04-21 11:07psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777912

Notes
(0010250)
svnbot   
2008-11-13 15:26   
Repository: dbsourcemanager
Revision: 175
Author: marvintm
Date: 2008-11-13 15:26:57 +0100 (Thu, 13 Nov 2008)

Fixed issue 5955. Triggers and foreign keys were not disabled before inserting data into the database.

---
U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=175&sc=1 [^]
(0010251)
svnbot   
2008-11-13 15:27   
Repository: openbravo
Revision: 9995
Author: marvintm
Date: 2008-11-13 15:27:33 +0100 (Thu, 13 Nov 2008)

Fixed issue 5955. Triggers and foreign keys were not disabled before inserting data into the database.

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

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