Running the Database Schema Upgrade Script For PatchSet 2 (PATCH 9254093) Fails
Last updated on SEPTEMBER 24, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.4.0]
Information in this document applies to any platform.
Checked for relevance on 19-Oct-2011.
Checked for relevance on 01-Oct-2013
After a fresh install of BRM 7.4, we installed <Patch 8943067> successfully. We then installed PatchSet 2 (<Patch 9254093>).
The install of the 'bin' file was successful but when we tried upgrading the database schema as written in the install documentation of the patch, it failed.
We followed every step but running 'pin_upgrade_74ps2.pl' always fails.
The error message in the 'tmp.out' file is as follows:-
ERROR at line 1:
ORA-20001: INDEX CREATION FAILED FOR i_au_coll_action_created__id ORA-01408:
such column list already indexed
ORA-06512: at line 28
ORA-01408: such column list already indexed
Why is this?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms