DB Errors While Processing Data In Bulk For Roaming (Doc ID 1147425.1)

Last updated on DECEMBER 14, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.
*** Checked for relevance on 05-27-2015 ***

Symptoms

When processing bulk files for roaming, received from a clearing house, we get database errors ORA-01013 and ORA-03117 in process log. Log snippet as below:

12.02.2010 22:14:57 xxxx ifw IFW NORMAL [T:47] 00153 - (ifw.SequencerPool.OR_SEQ_RAP.Controller) INF_SEQUENCE_COMMIT | New sequence number commited.
12.02.2010 22:15:04 xxxx ifw IFW NORMAL [T:47] 00153 - (ifw.SequencerPool.OR_SEQ_TAPIN.Controller) INF_SEQUENCE_COMMIT | New sequence number commited.
12.02.2010 22:15:04 xxxx ifw IFW NORMAL [T:47] 00153 - (ifw.SequencerPool.OR_SEQ_RAP.Controller) INF_SEQUENCE_COMMIT | New sequence number commited.
12.02.2010 22:15:18 xxxx ifw IFW CRITICAL [T:58] 00217 - (ifw.SequencerPool.OR_SEQ_GSMS_OUTPUT.Controller) ERR_DATABASE | Database error '[SERVERERROR] ORA-01013: user requested cancel of current operation'.
12.02.2010 22:15:20 xxxx ifw IFW NORMAL [T:58] 00054 - (ifw.DiagnosticDataHandler) INF_FILE_MOVED | File '/opt/apps/ifw/log/diagnostic.dat_or.25767' moved to '/opt/apps/ifw/log/diagnostic.dat_or.25767.20100212_221518'.
12.02.2010 22:15:20 xxxx ifw IFW CRITICAL [T:55] 00217 - (ifw.SequencerPool.OR_SEQ_GPRS_OUTPUT.Controller) ERR_DATABASE | Database error '[SERVERERROR] ORA-03117: two-task save area overflow'.
12.02.2010 22:15:23 xxxx ifw IFW NORMAL [T:55] 00054 - (ifw.DiagnosticDataHandler) INF_FILE_MOVED | File '/opt/apps/ifw/log/diagnostic.dat_or.25767' moved to '/opt/apps/ifw/log/diagnostic.dat_or.25767.20100212_221520'.

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