Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016982ModulesInitial data loadpublic2011-05-03 16:292014-04-01 21:46
Reporterplujan 
Assigned Todalsasua 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0016982: Initial Data Load cannot be installed in Oracle
DescriptionSince 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 ReproduceWhen 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 SolutionDo not use missing AD_Element
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Openbravo - Module Management 2011-05-03 16-24-52.png (28,020) 2011-05-03 16:29
https://issues.openbravo.com/file_download.php?file_id=3936&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-05-03 16:29plujanNew Issue
2011-05-03 16:29plujanAssigned To => mirurita
2011-05-03 16:29plujanFile Added: Openbravo - Module Management 2011-05-03 16-24-52.png
2011-05-03 17:05adrianromeroAssigned Tomirurita => adrianromero
2011-05-03 17:54hgbotCheckin
2011-05-03 17:54hgbotNote Added: 0036329
2011-05-03 17:54hgbotStatusnew => resolved
2011-05-03 17:54hgbotResolutionopen => fixed
2011-05-03 17:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.idl/rev/82aaa94a9c091a9aa9e854110d91339d718c2a9c [^]
2011-05-03 18:40adrianromeroNote Added: 0036334
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2014-04-01 21:46plujanNote Added: 0065706
2014-04-01 21:46plujanStatusresolved => closed

Notes
(0036329)
hgbot   
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   
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   
2014-04-01 21:46   
Closed as marked as Resolved for too long