Question
R10.2 upgrade manager: SQL Exception
Hello All,
R10.2 upgrade manager encounters an error in upgrade database schema step. The description of the error is
wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[ALTER INDEX ATOOPTION2$UNIQUE50 RENAME TO ATOOption2$UNIQUE50].
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
From the above SQL script it looks like the upgrade manager is attempting to rename the index from uppercase to lowercase.
Anyone out there who faced the same error and are there any fixes/workarounds.
Thanks in advance,
Saravanan
R10.2 upgrade manager encounters an error in upgrade database schema step. The description of the error is
wt.util.WTException: An error occurred during execution of SQL executor command SQLCommand[ALTER INDEX ATOOPTION2$UNIQUE50 RENAME TO ATOOption2$UNIQUE50].
Nested exception is: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
From the above SQL script it looks like the upgrade manager is attempting to rename the index from uppercase to lowercase.
Anyone out there who faced the same error and are there any fixes/workarounds.
Thanks in advance,
Saravanan