My Oracle Support Banner

BRM Database Upgrade Script(pin_upgrade_12ps6.pl) Errors Out With "object Already Exists" Message (Doc ID 2941515.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

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

Symptoms


As par of BRM 12 upgrade from Patch Set PS3 to PS6, customer is running BRM database upgrade script - pin_upgrade_12ps6.pl
Doc followed: https://docs.oracle.com/en/industries/communications/billing-revenue/12.0/patch-set-install-guide/installing-brm-12.0-patch-sets.html#GUID-23950307-27C3-4002-AE46-878569E87A23

ERROR
-----------------------
from dm_oracle.pinlog:

E Wed Feb 15 04:14:50 2023  [HOSTNAME]  dm:16166  sm_dd_obj_set.c(24):2926 2:[HOSTNAME] :<no_name>:22805:-146069760:21:1676463290:22::::
sdo_ti_db_validate: error validating field PIN_FLD_ACTION_INFO in type /event/customer/contract/cancel, table event_contract_cancel_t already exists

SQL_STMT do_sql: cmd="rollback"
E Wed Feb 15 04:14:51 2023 [HOSTNAME]   dm:16166  dm_back.c(41):1635 2:[HOSTNAME] <no_name>:22805:-146069760:21:1676463290:22::::
DMbe #9: process_op: op 21(PCM_OP_SET_DD), err 10(PIN_ERR_DUPLICATE)



pin_upgrade_12ps6.pl output:

Updating DB Schema
*** Error: Unable to update the Portal Base database.
  Exiting from the install without finishing successfully.
  Please check for errors in
  and then rerun this program.
EBUF: errno=<PIN_ERR_DUPLICATE:10> location=<PIN_ERRLOC_DM:4> class= field num=<PIN_FLD_SM_ITEM_NAME:5,546> recid= reserved=

 

Customer faced this issue for the following tables: newsfeed_t, event_act_ssp_milestone_info_t, event_product_fee_penalty_t, event_contract_t. 

After deleting the objects and the entries from dd_objects_t and dd_objects_fields_t and re-runing the script the issue gets resolved for the particular DB object but another error pops up for another object.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.