Transaction ID Controller Issue When Using Multiple Pipelines (Doc ID 2206193.1)

Last updated on DECEMBER 09, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.15.0 version, Pipeline Manager

In performance environment, the user has 4 application servers (129, 133, 132, 134), which have pipeline running connecting to the same DB schema brm01.

User implemented the semaphore to load pricing every two hours, and got below errors:

On server133: --> Semaphore passed through cronjob at 12:31
-----------------------
04.11.2016 12:31:17 xxxx ifw IFW CRITICAL [T:1251911424] 00322 - (ifw.TransactionIdController.Generator) Database value for field 'IFW_TAM.TAM_ID not in sequence, Actual id : 25289' is invalid.
04.11.2016 12:31:19 xxxx ifw IFW CRITICAL [T:1251911424] 11003 - (ifw.DataPool.RealtimePipeline.Module) Failed to open realtime transaction in pipeline 'ifw.Pipelines.RealtimePipelineGPRS1.Input'.


On server129 --> Semaphore passed through cronjob at 12:30
-----------------------
04.11.2016 12:30:07 xxxx ifw IFW CRITICAL [T:4093638400] 00322 - (ifw.TransactionIdController.Generator) Database value for field 'IFW_TAM.TAM_ID not in sequence, Actual id : 25339' is invalid.
04.11.2016 12:30:10 xxxx ifw IFW CRITICAL [T:4093638400] 11003 - (ifw.DataPool.RealtimePipeline.Module) Failed to open realtime transaction in pipeline 'ifw.Pipelines.RealtimePipelineGPRS1.Input'.


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