Error during E1 9.0 Update1 install

[wadie]

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.

 

[jppareek]

Can you exactly tell whether or not you are trying to install standalone of update1?
=A0
Pareek

 

[samuel]

Have you applied the latest Planner ESU for E900? I have just completed an E900 installation with UL1 successfully, but mine's on SSE.

 

[wadie]

Yes, I installed the latest planner ESU right before I started my UL1 install. I did not build it into a full package but I suppose that's not necessary yet

I tested this install on our own servers before installing it at a client, but now I'm in doubt of trying it at the client site

 

[wadie]

Full install

 

[wadie]

Is it possible this is caused because I've installed most updates contained in UL1 already as seperate ESU?