Index "I_AU_ACCOUNT__ID" Creation Error In Upgrade Script For 6.2 - 7.0
Last updated on SEPTEMBER 26, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 to 22.214.171.124.1 [Release 7.0.0 to 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 24-Dec-2012***
During upgrade from 6.2 - 7.0 add_new_indexes_70.sql runs first in the SQL_OFFLINE3 listing this
creates the i_au_account_t__parent_obj_id0 index on the au_parent_obj_id0 field on the
Then, 62_70_default_values.sql script executes next. This script looks for an index of
i_au_account__id on the au_account_t table referencing the au_parent_obj_id0 field which does not
exist so it tries to create it. This generates an error in the upg_log_t table because this column has an
existing index at that point with a different name.
In OOB it is observed that the i_au_account__id is the index on this table and field.
This is an upgrade from 6.2SP1 - 6.2SP4 - 7.0, partial steps to overall upgrade to 7.3.1.
Steps to Reproduce
Upgrade from 6.2SP1 - 7.0
Review the upg_log_t table for msg_type = 'E'
Should see one indicating step_name = populating_audit_tables and an oracle error message of ORA-01408: such column list already indexed
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms