Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009237 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2009-05-29 11:43 | 2009-06-04 00:00 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | d2186c00f52e | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009237: Update database fails on last PI revision | |||||||
| Description | After 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 Reproduce | Update to last PI revision Launch an update.database | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0016878) hgbot (developer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-05-29 11:43 | plujan | New Issue | |
| 2009-05-29 11:43 | plujan | Assigned To | => marvintm |
| 2009-05-29 11:43 | plujan | OBNetwork customer | => No |
| 2009-06-01 10:12 | rafaroda | Priority | normal => high |
| 2009-06-01 10:12 | rafaroda | Status | new => scheduled |
| 2009-06-02 18:20 | hgbot | Checkin | |
| 2009-06-02 18:20 | hgbot | Note Added: 0016878 | |
| 2009-06-02 18:20 | hgbot | Status | scheduled => resolved |
| 2009-06-02 18:20 | hgbot | Resolution | open => fixed |
| 2009-06-02 18:21 | hgbot | Checkin | |
| 2009-06-02 18:21 | hgbot | Note Added: 0016879 | |
| 2009-06-02 18:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/d2186c00f52ea150e10a687c4099f84dacccc0e8 [^] |
| 2009-06-03 19:08 | psarobe | Status | resolved => closed |
| 2009-06-04 00:00 | anonymous | sf_bug_id | 0 => 2800788 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |