Patch Upgrade from BRM 12 PS3 To 12 PS8, Failed With Table : Journal_t Is Not Linked To Object:/journalerror (Doc ID 3000240.1)

Last updated on JANUARY 29, 2024

Applies to:

Goal

When trying to upgrade from Billing and Revenue Management (BRM) 12 Patch Set (PS) 3 to BRM 12 PS 8 the following error occurs:

Upgrade BRM 12.0.0.8.0 is now executing upgrade_12_functions()
Execute SQL statement from file /opt/rms/opt/brm/brm/12.0/BRM/sys/dd/data/pre_modular_oracle.sql
################################################
Started dd_objects_journal.source at Thu Jan 25 02:56:05 2024
12PS1 filename /opt/rms/opt/brm/brm/12.0/BRM/sys/dd/data/dd_objects_journal.source
Table : journal_t is not linked to object : /journal,script execution is unsuccessful for dd_objects_journal.source
Modifying DB Schema...
Re-reading the pin.conf file "./pin.conf" since it has changed. Previous file mod time was 1615190055, now it is 1706172912
 
EBUF: errno=<PIN_ERR_BAD_ARG:4> location=<PIN_ERRLOC_DM:4> class= field num=<PIN_FLD_ACTION:5,83> recid= reserved=
*** 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.

DM_ORACLE Error:
E Thu Jan 25 02:56:28 2024 <hostname> dm:1322762 sm_dd_obj_set.c(24):2067 2:<hostname>:<no_name>:1322372:-13847110421:1706172988:1::::
  sdo_process_simpletype: cannot specify ADD for an existing field, name "PIN_FLD_TYPE"
E Thu Jan 25 02:56:28 2024 <hostname> dm:1322762 dm_back.c(41):1635 2:<hostname>:<no_name>:1322372:-13847110421:1706172988:1::::
  DMbe #8: process_op: op 21(PCM_OP_SET_DD), err 4(PIN_ERR_BAD_ARG)
 

Solution

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