Sequencer Error: Err_double_seq_number, But No Double Sequence Was Found (Doc ID 1304996.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Jul-2014***
Checked for relevance on 4-Apr-2017.

Symptoms

When processing a file and the database connection to the Sequencer was lost, it errored out ERR_DOUBLE_SEQ_NUMBER, but the file never got processed before.

The process log showed that the connection to the database was lost as following:

10.01.2011 12:04:52 brm01 ifw IFW MAJOR [T:9] 00217 - f(ifw.DataPool.Login.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-03135: connection lost contact (method DBC::DatabasePlugIn::connection)'.
10.01.2011 12:04:52 brm01 ifw IFW CRITICAL [T:9] 00217 - (ifw.SequencerPool.SEQ_CHECK_TAPIN.Controller) ERR_DATABASE | Database error '[NOTINITIALIZED] Use of uninitialized RWDBDatabase'.

The pipeline log showed the following:

10.01.2011 12:04:53 brm01 ifw IFW NORMAL [T:9] 00526 - (ifw.Pipelines.TP_TAP_REFORMATTER.TransactionManager) Transaction '220' rollback demanded by 'ifw.Pipelines.TP_TAP_REFORMATTER.Output'-'ERR_DOUBLE_SEQ_NUMBER'.
10.01.2011 12:04:53 brm01 ifw IFW CRITICAL [T:9] 00147 - (ifw.SequencerPool.SEQ_CHECK_TAPIN.Controller) Double sequence number found (sequence number: '9')


If there was no connection to the database when checking the sequence, it was expected a "DataBase Connection Error", not a "Double Sequence Found" ( the sequence 9 was not stored in the ifw_seqlog_in ).

Changes

 

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