AnsweredAssumed Answered

Problems with Schema Migration must be resolved, then retried.

Question asked by Aaron Duncan on May 24, 2017
Latest reply on May 24, 2017 by Russell Waliszewski

I'm attempting to update the schema on an RSA provided database that I imported on a new server install with version 7.0.2. When I start the import, it gets to 24% complete, and sticks on ACM-70821.sql. Looking through the error, I'm showing the following text below. Anyone run into this issue? 

 

ORA-01408: such column list already indexed
ORA-06512: at line 78

 

Schema Migration completed in 0h 1m 4s with errors.

....

 

java.sql.SQLException: ORA-01408: such column list already indexed
ORA-06512: at line 78

   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
   at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1707)
   at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1670)
   at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:310)
   at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
   at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:221)
   at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:107)
   at com.aveksa.migration.jdbctool.SQLFileExecutor.execute(SQLFileExecutor.java:98)
   at com.aveksa.migration.jdbctool.IncrementalUpdate.update(IncrementalUpdate.java:481)
   at com.aveksa.migration.jdbctool.MigrateSchema.execute(MigrateSchema.java:140)
   at com.aveksa.migration.jdbctool.CheckDatabase.migrateSchema(CheckDatabase.java:1375)
   at com.aveksa.migration.jdbctool.CheckDatabase.migrateSchema(CheckDatabase.java:1349)
   at com.aveksa.migration.jdbctool.CheckDatabase.runMigration(CheckDatabase.java:2045)
   at com.aveksa.migration.jdbctool.CheckDatabase.run(CheckDatabase.java:1991)
   at java.lang.Thread.run(Thread.java:745)

Outcomes