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)
Could you run the following in the database as AVUSER or the schema containing the Aveksa tables. Then re-run the migration.
set serveroutput on size unlimited
begin
for fkind in
(select index_name from user_ind_columns uic
where table_name='T_AV_CRDETAIL_DEPENDENCY'
and column_position = 1
and column_name='CHANGE_REQUEST_ID'
and not exists
(select 'x' from user_ind_columns
where index_name = uic.index_name
and column_position = 2)) loop
dbms_output.put_line('Index Name: ' ||fkind.index_name);
execute immediate 'drop index '||fkind.index_name;
end loop;
end;
/
What is the version that you are migrating from?
Thanks.