"pin_ledger_report -mode create_journal" Throws PIN_ERR_STORAGE Error (Doc ID 557733.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.1 [Release 7.3.0]
HP-UX PA-RISC (32-bit)
HP-UX Itanium (32-bit)
z*OBSOLETE: Microsoft Windows
Oracle Solaris on SPARC (32-bit)
***Checked for relevance on 14-Apr-2010***
***Checked for relevance on 25-Apr-2013***

Symptoms

After upgrading from previous BRM release version to 7.3 (for example - upgrade from 6.5 to 7.3), attempt to execute pin_ledger_report in create journal mode ends in PIN_ERR_STORAGE error.

pin_ledger_report -mode create_journal -verbose

The following is a snippet from default.pinlog:

pin_ledger_report:572.404 pin_ledger_report.c:1603
1:<m/c>:pin_ledger_report:572:404:1:1189122167:2
ledger_report_create_journal error
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
pin_ledger_report:572.404 pin_ledger_report.c:378
1:<m/c>:pin_ledger_report:572:404:1:1189122167:2
pin_ledger_report error
<location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>N.

 The following is a snippet from the corresponding dm_oracle log:

 dm:1412.1728 dm_subr.c(108):2181 1:<m/c>:pin_ledger_report:648:1396:1:1189122949:2
ORACLE error: do_sql_insert: PINStmtExecute: code 20101, op 0
=ORA-20101: error while accessing data_journal_t
ORA-06512: at "PIN.GL", line 2105
ORA-06512: at "PIN.LEDGER_REPORT_TRIGGER", line 8
ORA-04088: error during execution of trigger 'PIN.LEDGER_REPORT_TRIGGER'
"insert into ledger_report_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, start_t, end_t, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, type, gl_report_type, currency_only, name, created_t, mod_t, read_access, write_access, accts_num_for_group, gl_segment ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :start_t, :end_t, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :type, :gl_report_type, :currency_only, :name, :created_t, :mod_t, :read_access, :write_access, :accts_num_for_group, :gl_segment )" 
dm:1412.1728 dm_do_ops.c(68):2027 1::<m/c>::pin_ledger_report:648:1396:1:1189122949:2
ERROR do_create_create sql_insert err=1(PIN_ERR_NO_MEM)

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