Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016982 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Initial data load | critical | have not tried | 2011-05-03 16:29 | 2014-04-01 21:46 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | dalsasua | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 82aaa94a9c09 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Oracle 10g | Ant version | |||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Regression introduced in release | ||||||||
| Summary | 0016982: Initial Data Load cannot be installed in Oracle | |||||||
| Description | Since the cleanup project, the Data type column (AD_Element_ID='1315') does not exist. Since it is referred by IDL, this module cannot be installed. See attached screenshot. | |||||||
| Steps To Reproduce | When rebuilding the system after installing IDL, an error is shown. The log shows following error: [java] 129775 INFO - Enabling Foreign Keys and Triggers [java] SQL command failed with ORA-02298: cannot validate (QA_PI_INC_ORACLE.AD_ELEMENT_AD_COLUMN) - parent keys not found [java] [java] ALTER TABLE AD_COLUMN ENABLE CONSTRAINT AD_ELEMENT_AD_COLUMN [java] 157450 ERROR - Error while enabling foreign key [java] java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (QA_PI_INC_ORACLE.AD_ELEMENT_AD_COLUMN) - parent keys not found [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:177) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:195) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:185) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:195) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (QA_PI_INC_ORACLE.AD_ELEMENT_AD_COLUMN) - parent keys not found [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:177) [java] ... 3 more [java] Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:225) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] Caused by: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:185) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:195) [java] ... 2 more [java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (QA_PI_INC_ORACLE.AD_ELEMENT_AD_COLUMN) - parent keys not found [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:177) [java] ... 3 more [java] --- Nested Exception --- [java] org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:185) [java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:195) [java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:86) [java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:38) [java] Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02298: cannot validate (QA_PI_INC_ORACLE.AD_ELEMENT_AD_COLUMN) - parent keys not found [java] [java] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85) [java] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) [java] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) [java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) [java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) [java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) [java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) [java] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468) [java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) [java] at org.apache.ddlutils.platform.oracle.Oracle8Platform.enableAllFK(Oracle8Platform.java:177) [java] ... 3 more | |||||||
| Proposed Solution | Do not use missing AD_Element | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Openbravo - Module Management 2011-05-03 16-24-52.png [^] (28,020 bytes) 2011-05-03 16:29
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0036329) hgbot (developer) 2011-05-03 17:54 |
Repository: erp/pmods/org.openbravo.idl Changeset: 82aaa94a9c091a9aa9e854110d91339d718c2a9c Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue May 03 17:53:02 2011 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.idl/rev/82aaa94a9c091a9aa9e854110d91339d718c2a9c [^] Fixes issue 0016982: Initial Data Load cannot be installed in Oracle It has been added the required AD_ELEMENT to the module --- M src-db/database/sourcedata/AD_COLUMN.xml M src-db/database/sourcedata/AD_ELEMENT.xml --- |
|
(0036334) adrianromero (manager) 2011-05-03 18:40 |
* Testing the issue Verify that IDL 3.0.0 can be installed properly. Verify also that going to the column definition "Data Type" of the Tab "Entity fields" of the window "Default Entity values" no error is raised by the application and you can see all field values of the column definition. * Other areas affected. No other areas affected. |
|
(0065706) plujan (manager) 2014-04-01 21:46 |
Closed as marked as Resolved for too long |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-05-03 16:29 | plujan | New Issue | |
| 2011-05-03 16:29 | plujan | Assigned To | => mirurita |
| 2011-05-03 16:29 | plujan | File Added: Openbravo - Module Management 2011-05-03 16-24-52.png | |
| 2011-05-03 17:05 | adrianromero | Assigned To | mirurita => adrianromero |
| 2011-05-03 17:54 | hgbot | Checkin | |
| 2011-05-03 17:54 | hgbot | Note Added: 0036329 | |
| 2011-05-03 17:54 | hgbot | Status | new => resolved |
| 2011-05-03 17:54 | hgbot | Resolution | open => fixed |
| 2011-05-03 17:54 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.idl/rev/82aaa94a9c091a9aa9e854110d91339d718c2a9c [^] |
| 2011-05-03 18:40 | adrianromero | Note Added: 0036334 | |
| 2011-06-03 10:58 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2014-04-01 21:46 | plujan | Note Added: 0065706 | |
| 2014-04-01 21:46 | plujan | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |