Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009237Openbravo ERPA. Platformpublic2009-05-29 11:432009-06-04 00:00
Reporterplujan 
Assigned Tomarvintm 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0009237: Update database fails on last PI revision
DescriptionAfter updating to last PI revision, I ran an update.database and the result was:
Enabling Foreign Keys and Triggers
[alterdatabasedataall] SQL command failed with ORA-02298: cannot validate (TAD_250.ADMODULE_ADDSTABLE) - parent keys not found
[alterdatabasedataall]
[alterdatabasedataall] ALTER TABLE AD_DATASET_TABLE ENABLE CONSTRAINT ADMODULE_ADDSTABLE
Error while enabling foreign key
[alterdatabasedataall] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key
[alterdatabasedataall] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:173)
[alterdatabasedataall] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:276)
[alterdatabasedataall] at org.openbravo.dal.core.DalInitializingTask.execute(DalInitializingTask.java:116)
[alterdatabasedataall] at org.openbravo.ddlutils.task.BaseDalInitializingTask.execute(BaseDalInitializingTask.java:79)
[alterdatabasedataall] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.execute(AlterDatabaseDataAll.java:92)
[alterdatabasedataall] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[alterdatabasedataall] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[alterdatabasedataall] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[alterdatabasedataall] at java.lang.reflect.Method.invoke(Method.java:597)
[alterdatabasedataall] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[alterdatabasedataall] at org.apache.tools.ant.Task.perform(Task.java:348)
[alterdatabasedataall] at org.apache.tools.ant.Target.execute(Target.java:357)
[alterdatabasedataall] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[alterdatabasedataall] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[alterdatabasedataall] at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
[alterdatabasedataall] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[alterdatabasedataall] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416)
[alterdatabasedataall] at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
[alterdatabasedataall] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[alterdatabasedataall] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[alterdatabasedataall] at java.lang.reflect.Method.invoke(Method.java:597)
[alterdatabasedataall] at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
[alterdatabasedataall] at org.apache.tools.ant.Task.perform(Task.java:348)
[alterdatabasedataall] at org.apache.tools.ant.Target.execute(Target.java:357)
[alterdatabasedataall] at org.apache.tools.ant.Target.performTasks(Target.java:385)
[alterdatabasedataall] at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)
[alterdatabasedataall] at org.apache.tools.ant.Project.executeTarget(Project.java:1306)
[alterdatabasedataall] at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
[alterdatabasedataall] at org.apache.tools.ant.Project.executeTargets(Project.java:1189)
[alterdatabasedataall] at org.apache.tools.ant.Main.runBuild(Main.java:758)
[alterdatabasedataall] at org.apache.tools.ant.Main.startAnt(Main.java:217)
[alterdatabasedataall] at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
[alterdatabasedataall] at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
[alterdatabasedataall] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (TAD_250.ADMODULE_ADDSTABLE) - parent keys not found
[alterdatabasedataall]
[alterdatabasedataall] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)
[alterdatabasedataall] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[alterdatabasedataall] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[alterdatabasedataall] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[alterdatabasedataall] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
[alterdatabasedataall] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
[alterdatabasedataall] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
[alterdatabasedataall] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
[alterdatabasedataall] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
[alterdatabasedataall] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
[alterdatabasedataall] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
[alterdatabasedataall] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
[alterdatabasedataall] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
[alterdatabasedataall] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:165)
[alterdatabasedataall] ... 32 more
Steps To ReproduceUpdate to last PI revision
Launch an update.database
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-29 11:43plujanNew Issue
2009-05-29 11:43plujanAssigned To => marvintm
2009-05-29 11:43plujanOBNetwork customer => No
2009-06-01 10:12rafarodaPrioritynormal => high
2009-06-01 10:12rafarodaStatusnew => scheduled
2009-06-02 18:20hgbotCheckin
2009-06-02 18:20hgbotNote Added: 0016878
2009-06-02 18:20hgbotStatusscheduled => resolved
2009-06-02 18:20hgbotResolutionopen => fixed
2009-06-02 18:21hgbotCheckin
2009-06-02 18:21hgbotNote Added: 0016879
2009-06-02 18:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d2186c00f52ea150e10a687c4099f84dacccc0e8 [^]
2009-06-03 19:08psarobeStatusresolved => closed
2009-06-04 00:00anonymoussf_bug_id0 => 2800788

Notes
(0016878)
hgbot   
2009-06-02 18:20   
Repository: dbsourcemanager
Revision: 331
Author: marvintm
Date: 2009-06-02 18:20:13 +0200 (Tue, 02 Jun 2009)

Fixed issue 9237. Update.database should no longer fail with a constraint violation when a new table is added to a dataset.

---
U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseDataAll.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=331&sc=1 [^]
(0016879)
hgbot   
2009-06-02 18:21   
Repository: erp/devel/pi
Changeset: d2186c00f52ea150e10a687c4099f84dacccc0e8
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Jun 02 18:20:04 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d2186c00f52ea150e10a687c4099f84dacccc0e8 [^]

Fixed issue 9237. Update.database should no longer fail with a constraint violation when a new table is added to a dataset.

---
M src-db/database/lib/dbsourcemanager.jar
---