Problem During Upgrading BRM 7.3.1 To BRM 7.4 (Doc ID 1135985.1)

Last updated on JANUARY 25, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 27-May-2014***

Goal

Getting below error while running database upgrade script after installing the upgrade <Patch 7594327>.

brms/portal/7.3/sys/dd/data/731_74_create_sox_user_activity.source found
Started 731_74_create_sox_user_activity.source at Fri Jun 4 12:51:03 2010
Creating Objects in BRM Database
Updating DB Schema
Loading objects from file /brms/portal/7.3/sys/dd/data/731_74_create_sox_user_activity.source
Executing start_dm_oracle
EBUF: errno=<PIN_ERR_NOT_FOUND:3> location=<PIN_ERRLOC_DM:4> class=<SYSTEM_DETERMINATE:1> field num=<PIN_FLD_FIELD_NAME:5,508> recid=<0> reserved=<0>
*** Error: Unable to update the Portal Base database.
Exiting from the install without finishing successfully.
Please check for errors in /brms/portal/7.3/tmp/tmp.out
and then rerun this program.


The dm_oracle pinlog reporting the following messages:

D Fri Jun 11 14:59:58 2010 machine1 dm:22282 dm_if_oracle.c(112):4358 1:machine1:<no_name>:22252:1:21:1276248598:1
Start of opcode PCM_OP_SET_DD
E Fri Jun 11 14:59:58 2010 machine1 dm:22282 sm_dd_obj_set.c(11):3365 1:machine1:<no_name>:22252:1:21:1276248598:1
sdo_add_main: unknown FIELD_NAME "PIN_FLD_NAP_IP_ADDRESS"when processing /user_activity
W Fri Jun 11 14:59:58 2010 machine1 dm:22282 dm_subr.c(116):1111 1:machine1:<no_name>:22252:1:21:1276248598:1
SQL_STMT do_sql: cmd="rollback"
D Fri Jun 11 14:59:58 2010 machine1 dm:22282 ../dm_oracle_stmt_cache.c:324 1:machine1:<no_name>:22252:1:21:1276248598:1
PINStmtPrepare: SQL Statement = rollback
audsession-id: 63377; Statement-id: 1232452;
D Fri Jun 11 14:59:58 2010 machine1 dm:22282 ../dm_oracle_stmt_cache.c:334 1:machine1:<no_name>:22252:1:21:1276248598:1
audsession-id: 63377; Statement-id: 1232452; Time taken by OCIStmtPrepare = 0.070810 milliseconds
D Fri Jun 11 14:59:58 2010 machine1 dm:22282 dm_if_oracle.c(112):625 1:machine1:<no_name>:22252:1:21:1276248598:1
audsession-id: 63377; Statement-id: 1232452; Time taken by OCIStmtExecute = 1.024961 milliseconds
D Fri Jun 11 14:59:58 2010 machine1 dm:22282 dm_if_oracle.c(112):5477 1:machine1:<no_name>:22252:1:21:1276248598:1
End of opcode PCM_OP_SET_DD



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