IFW Starts Although Several Critical DB Errors Occur During Loading Of Balance Data Module

(Doc ID 1308832.1)

Last updated on JANUARY 23, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2013***

Symptoms

IFW rating process ignores a lot of database critical occurs during loading of BalanceData module.

Brief Problem Statement:


The Balances module gets DB errors while loading balances, during the pipeline start up. The pipeline reports critical errors in the process log, but still comes up. This is fatal, since balances are not complete and could lead to incorrect discounts being applied.


Although a lot of database critical errors occur during load of BalanceData module, IFW rating process (version 7.4 PS4 + libPLG64.so PS5) starts ignoring them.

snippet of the error:


26.07.2010 14:15:47 xxxx ifw IFW CRITICAL [T:85]
31233 - (ifw.DataPool.BalanceDataModule.Module) Database operation failed in
DAT_BalanceBatch: '[SERVERERROR] ORA-01555: snapshot too old: rollback
segment number 36 with name "_SYSSMU36_1257368393$" too small'
26.07.2010 14:15:48 xxxx ifw IFW CRITICAL [T:85]
31230 - (ifw.DataPool.BalanceDataModule.Module) Thread-16 has died with an
expection in DAT_InitCustomerThread::run() -
26.07.2010 14:15:51 xxxx ifw IFW CRITICAL [T:89]
31233 - (ifw.DataPool.BalanceDataModule.Module) Database operation failed in
DAT_BalanceBatch: '[SERVERERROR] ORA-01555: snapshot too old: rollback
segment number 51 with name "_SYSSMU51_1257393328$" too small'
26.07.2010 14:15:52 xxxx ifw IFW CRITICAL [T:89]
31230 - (ifw.DataPool.BalanceDataModule.Module) Thread-20 has died with an
expection in DAT_InitCustomerThread::run() -







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