cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

R10.2 upgrade manager: SQL Exception

Saravanan
8-Gravel

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

0 REPLIES 0
Announcements

Top Tags