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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0005955
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagercriticalalways2008-11-13 15:262009-04-22 00:00
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9995
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005955: Triggers and foreign keys are not disabled before inserting data into the database

DescriptionWhen 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.
Steps To ReproduceJust 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
Proposed SolutionTriggers and foreign keys have to be disabled before inserting data.
Tagsdbsm_migrate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0010250)
svnbot (reporter)
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 (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-11-13 15:26 marvintm New Issue
2008-11-13 15:26 svnbot Checkin
2008-11-13 15:26 svnbot Note Added: 0010250
2008-11-13 15:26 svnbot Status new => resolved
2008-11-13 15:26 svnbot Resolution open => fixed
2008-11-13 15:26 svnbot svn_revision => 175
2008-11-13 15:27 svnbot Checkin
2008-11-13 15:27 svnbot Note Added: 0010251
2008-11-13 15:27 svnbot svn_revision 175 => 9995
2008-11-28 12:54 jpabloae Assigned To => marvintm
2008-12-18 12:38 jpabloae Sticky Issue No => Yes
2008-12-18 12:39 jpabloae Sticky Issue Yes => No
2008-12-18 12:39 jpabloae Tag Attached: dbsm_migrate
2008-12-18 12:41 jpabloae Project @4@ => Openbravo ERP
2008-12-18 12:41 jpabloae Category => Y. DBSourceManager
2009-04-21 11:07 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777912


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker