Error Running Pin_set -all With Init_db = No On Secondary Existing Secondary Schema (Doc ID 1569891.1)

Last updated on NOVEMBER 27, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 29-December-2015***

Symptoms

While  installing  BRM 7.5 and running pin_setup with "init_db = no" on secondary DB an error is encountered in pin_setup

Load pin_rerate fields failed

 dm_oracle.pinlog error snippet

E Fri Apr 26 09:36:26 2013 ukne27sr-vf dm:2887 dm_subr.c(154):2615 1:ukne27sr-vf:load_pin_rerate_flds:3202:-156673616:1:1366965386:4
  ORACLE error: do_sql_insert: PINStmtExecute: code 1733, op 0
  =ORA-01733: virtual column not allowed here
  "insert into config_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, hostname, name, program_name, created_t, mod_t, read_access, write_access, descr, value, version ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :hostname, :name, :program_name, :created_t, :mod_t, :read_access, :write_access, :descr, :value, :version )"
E Fri Apr 26 09:36:26 2013 ukne27sr-vf dm:2887 dm_do_ops.c(92):2179 1:ukne27sr-vf:load_pin_rerate_flds:3202:-156673616:1:1366965386:4
  ERROR do_create_create sql_insert err=43(PIN_ERR_STORAGE)
E Fri Apr 26 09:36:26 2013 ukne27sr-vf dm:2887 dm_back.c(31):1440 1:ukne27sr-vf:load_pin_rerate_flds:3202:-156673616:1:1366965386:4
  DMbe #8: process_op: op 1(PCM_OP_CREATE_OBJ), err 43(PIN_ERR_STORAGE)

 

Cause

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