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 laterInformation 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:
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:
*** 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 |