Pin_ledger_report In Detail Mode Causes Ora-01455 Error (Doc ID 878560.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.1 [Release 7.3.1]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 06-Dec-2012***

Symptoms

When running ledger report in detail mode with the transaction_grouping parameter set  in the pin.conf,
the utility returns 'error detected' and an ORA-01455 error is generated in the dm_oracle.pinlog:

E Sat Oct 29 01:16:04 2011 machine1 dm:8454 dm_subr.c(116):7750 1:machine1:pin_ledger_report:8589:1:133:1238419182:2
ORACLE error: do_sql_mr_select: PINStmtExecute: code 1455, op 0
=ORA-01455: converting column overflows integer datatype
E Sat Oct 29 01:16:04 2011 machine1 dm:8454 dm_subr.c(116):6311 1:machine1:pin_ledger_report:8589:1:133:1238419182:2
dm_read_subrow_multi_select: do_sql_mr_select failed select rec_id, beg_acct, end_acct, grp_stat from ledger_report_account_groups_t where obj_id0 = :1
E Sat Oct 29 01:16:04 2011 machine1 dm:8454 dm_subr.c(116):6219 1:machine1:pin_ledger_report:8589:1:133:1238419182:2
dm_read_subrows_wild: dm_read_subrow_multiple_select failed
E Sat Oct 29 01:16:04 2011 machine1 dm:8454 dm_do_ops.c(73):2514 1:machine1:pin_ledger_report:8589:1:133:1238419182:2
ERROR OP_ROBJ: dm_read_subrows_wild() FAILED err=43(PIN_ERR_STORAGE)
E Sat Oct 29 01:16:04 2011 machine1 dm:8454 dm_do_ops.c(73):2923 1:machine1:pin_ledger_report:8589:1:133:1238419182:2
do_robj (10000003309) do_robj... field name 9/2401, err=43(PIN_ERR_STORAGE)

 


-- Steps To Reproduce:
a) Add the following entry in $PIN_HOME/apps/pin_billd/pin.conf file
- pin_ledger_report transaction_grouping 100000

b) Set poid_ids2 sequence to 10000000000

e.g.
DROP SEQUENCE USER.POID_IDS2;
CREATE SEQUENCE USER.POID_IDS2
START WITH 10000000000
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;

Here USER in USER.POID_IDS2 is a valid database user


c) stop_all and start_all

d) create an account on 10/29/2011 and run pin_ledger_report in detail mode
For ex, pin_ledger_report -start 10/29/2011 -end 10/30/2011 -type unbilled -report file.dat -detail

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