CCB - Customer Care and Billing v.2.1.0 Ar-Prfk Batch Job Goes To Error Ora-01555: Snapshot Too Old (Doc ID 1248184.1)

Last updated on DECEMBER 10, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.1.0 and later   [Release: 2.1 and later ]
Information in this document applies to any platform.

Goal

CCB v.2.1.0 / Oracle Solaris on SPARC (64-bit) / Oracle database 10.2.0.3

Batch Job AR-PRFK for Bills (CI_ARCBI) is ending in error; 3 out of 8 threads completed normally.
The 5 threads ended in following error:

SQL Error encountered sqlCode=1555, sqlState=72000 (ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small ) with SQL:
    'SELECT RI.ARC_ROOT_OBJ_ID, RI.ARC_ROOT_INST_ID FROM CI_ARC_ROOT_INST RI, CI_ARC_ROOT_OBJ RO WHERE RI.DB_PROC_CD =  ? AND RI.ARC_ROOT_INST_ID BETWEEN  ? AND  ? AND RI.ARC_ROOT_OBJ_ID = RO.ARC_ROOT_OBJ_ID AND RO.MAINT_OBJ_CD =  ? AND RO.ENV_REF_CD =  ? AND RO.ARC_ROOT_STAT_FLG =  ?'


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