wadie
Well Known Member
Hello list,
I'm encountering an error while installing update1 to my environments.
When, in ASU install application, I select DV900 to install Update1, he starts to copy the Control Tables from XML and next, he wants to insert those records into my database. I'm getting duplicate key errors on F9000 and the install stops. I don't know why I am getting these, our E1 9.0 installation is pretty basic...
Windows servers, Oracle10g, local Oracle Database, OAS
Any pointers on what to check? I tried it with debug turned on, but no useful information could be found there...
Error message in jde.log:
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:55:46.177000 B9600490.c1916
Verify Deployment Package (F98403): UL1 Environment: DV900
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:55:46.177001 B9600490.c1916
Dependent Objects Verified
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084000 JdeJvmWrapper.cpp349
JdeJvm::CheckForExceptions() - Java Exception encountered : java.lang.Exception: JDBException occured.
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084001 JdeJvmWrapper.cpp349
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: JDBException occured.
at oracle.e1.database.copytablexml.BaseCopyTableXML.singleDBInsert(Unknown Source)
at oracle.e1.database.copytablexml.BaseCopyTableXML.extractXMLToTable(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [DUPLICATE_KEY_ERROR] Duplicate key error obtained for table F9000.
at com.jdedwards.database.impl.sql.SQLPhysicalConnection.insert(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableInsert.lowLevelAttempt(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableWriteOperation.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryAccess.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.insert(Unknown Source)
at com.jdedwards.database.impl.standalone.JDBStandaloneTransformAccess.insert(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.insert(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.insert(Unknown Source)
... 2 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint (JDECTL900.F9000_PK) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at com.jdedwards.database.impl.physical.PreparedStatementDecorator.executeUpdate(Unknown Source)
... 13 more
.
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084002 Jdb_exet.c13074
JDB9900428 - A java exception occured during copying xml to table.
I'm encountering an error while installing update1 to my environments.
When, in ASU install application, I select DV900 to install Update1, he starts to copy the Control Tables from XML and next, he wants to insert those records into my database. I'm getting duplicate key errors on F9000 and the install stops. I don't know why I am getting these, our E1 9.0 installation is pretty basic...
Windows servers, Oracle10g, local Oracle Database, OAS
Any pointers on what to check? I tried it with debug turned on, but no useful information could be found there...
Error message in jde.log:
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:55:46.177000 B9600490.c1916
Verify Deployment Package (F98403): UL1 Environment: DV900
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:55:46.177001 B9600490.c1916
Dependent Objects Verified
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084000 JdeJvmWrapper.cpp349
JdeJvm::CheckForExceptions() - Java Exception encountered : java.lang.Exception: JDBException occured.
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084001 JdeJvmWrapper.cpp349
JdeJvm::CheckForExceptions() - Stack Trace for Exception : java.lang.Exception: JDBException occured.
at oracle.e1.database.copytablexml.BaseCopyTableXML.singleDBInsert(Unknown Source)
at oracle.e1.database.copytablexml.BaseCopyTableXML.extractXMLToTable(Unknown Source)
Caused by: com.jdedwards.database.base.JDBException: [DUPLICATE_KEY_ERROR] Duplicate key error obtained for table F9000.
at com.jdedwards.database.impl.sql.SQLPhysicalConnection.insert(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableInsert.lowLevelAttempt(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryableWriteOperation.attempt(Unknown Source)
at com.jdedwards.base.util.Retryer.retry(Unknown Source)
at com.jdedwards.database.impl.retry.JDBRetryAccess.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.insert(Unknown Source)
at com.jdedwards.database.impl.standalone.JDBStandaloneTransformAccess.insert(Unknown Source)
at com.jdedwards.database.impl.logical.JDBLogicalConnection.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessDelegate.insert(Unknown Source)
at com.jdedwards.database.impl.usage.JDBUsageTrackingAccess.insert(Unknown Source)
at com.jdedwards.database.impl.condensed.JDBCondensedAccessExpander.insert(Unknown Source)
... 2 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint (JDECTL900.F9000_PK) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at com.jdedwards.database.impl.physical.PreparedStatementDecorator.executeUpdate(Unknown Source)
... 13 more
.
2344/2464 WRK:Starting jdeCallObject Tue Nov 24 14:56:48.084002 Jdb_exet.c13074
JDB9900428 - A java exception occured during copying xml to table.