ORA-02158 Error When Running pin_731_74_pipeline_upgrade.pl Script

(Doc ID 2323811.1)

Last updated on NOVEMBER 08, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When installing <Patch 7594320> which is upgrading Billing and Revenue Management (BRM) 7.3 to 7.4 version, there is a step in the installation/upgrade procedure (presented in Readme file of the patch) which is upgrading the Pipeline Manager database schema.

At step 9, a perl script is run (pin_731_74_pipeline_upgrade.pl) but before running it there are two variables from $IFW_HOME/upgrade/pin_setup.values which have to be set: PIN_TEMP_DIR and PIPELINE_TBLSPACE.

When running pin_731_74_pipeline_upgrade.pl script the following error occurs:

Execution of pipeline upgrade script pin_upg_common.source successful  

ORA-20002: SCRIPT FAILED WITH THE ERROR ORA-02158: invalid CREATE INDEX option
ORA-06512: at "INTEGRATE.ADD_NEW_COLUMNS_74", line 766
ORA-02158: invalid CREATE INDEX option
ORA-06512: at line 1

Synonym created.

Grant succeeded.

Synonym created.

Grant succeeded.

Synonym created.

Grant succeeded.
#-------------

Execution of pipeline upgrade script add_new_columns_74.source is unsuccessful

The issue can be reproduced at will with the following steps:

  1. Open a terminal session on BRM environment running 7.3.0 version
  2. Run first 8 steps from installation procedure of <Patch 7594320>
  3. Go to $IFW_HOME/upgrade and update information about the databases section with Pipeline DB details in file IFW_HOME/upgrade/pin_setup.values
  4. cd $IFW_HOME/upgrade/731_74
  5. Run perl script pin_731_74_pipeline_upgrade.pl (as per step 9 of <Patch 7594320> installation procedure)

Cause

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