Perl Script pin_74_74ps6_pipeline_upgrade.pl Giving Error (Doc ID 1279448.1)

Last updated on SEPTEMBER 18, 2014

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 21-02-2013
*** Checked for relevance on 09-18-2014 ***

Goal

The perl script "pin_74_74ps6_pipeline_upgrade.pl" is giving error:

-bash-3.2$ perl pin_74_74ps6_pipeline_upgrade.pl

now executing pipeline upgrade module ...
################################################
pipeline upgrade from 74 to 74ps6 is now executing api:upgrade_pipeline_db()
################################################
Execute SQL statement from file /home/app/ifw/upgrade/74_74ps1/pin_upg_common.source
Execution of pipeline upgrade script pin_upg_common.source successful
################################################
################################################
Execute SQL statement from file /home/app/ifw/upgrade/74_74ps1/add_new_tables_74ps1.source
Execution of pipeline upgrade script add_new_tables_74ps1.source unsuccessful
################################################
################################################
the pipeline upgrade did not happen successfully
please see the pipeline upgrade log file at /home/app/ifw/log/pin_74_74ps6_pipeline_upgrade.log
################################################

 

-bash-3.2$ cat /home/app/ifw/log/pin_74_74ps6_pipeline_upgrade.log

execution failed for upgrade_pipeline_db(),
Please see the log file at /home/app/ifw/log.

 

-bash-3.2$ cat /home/app/ifw/log/add_new_pipeline_objects_74ps1.log

Execution of pipeline upgrade script pin_upg_common.source successful

ORA-20002: SCRIPT FAILED WITH THE ERRORORA-20001: Table creation failed for
nrtrde_files due to ||SQLERRM
ORA-00922: missing or invalid option

ORA-06512: at "PIN.ADD_NEW_TABLES_74", line 60
ORA-20001: Table creation failed for nrtrde_files due to ||SQLERRM
ORA-00922: missing or invalid option
ORA-06512: at line 1
#-------------



Solution

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