Pipeline Not Purging Events From ifw_sync Queue During Startup (Doc ID 1333903.1)

Last updated on MARCH 07, 2017

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 01-28-2014 ***

Goal

Pipeline is not purging events from ifw_sync queue during startup.

pipeline is not purging the events from the ifw_sync_1 table as seen bellow (even though there were events in the queue/table).

......................................................................................
22.03.2011 14:51:07 brmmlapp1 ifw IFW NORMAL [T:9] 31012 - () INF_PURGE_EVENT | Purging '0' event(s) from queue 'IFW_SYNC_QUEUE_1' succeeded.
......................................................................................

Once the data got loaded, then those events gets dequeued (as seen bellow). See the timestam of above & bellow:

......................................................................................
22.03.2011 14:52:39 brmmlapp1 ifw IFW NORMAL [T:30] 31001 - (ifw.DataPool.CustomerDataBatch.Module) INF_EVENT | Event received: 'CustCreate'.
22.03.2011 14:52:39 brmmlapp1 ifw IFW NORMAL [T:30] 31001 - (ifw.DataPool.CustomerDataBatch.Module) INF_EVENT | Event received: '# number of field entries allocated 20, used 5
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 82597738617 0
0 PIN_FLD_STRING STR [0] "CustCreate"
0 PIN_FLD_END_T TSTAMP [0] (1300696295) Mon Mar 21 19:31:35 2011
0 PIN_FLD_BAL_INFO ARRAY [0] allocated 20, used 2
1 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 82597738745 0
0 PIN_FLD_BAL_INFO ARRAY [1] allocated 20, used 3
1 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
1 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 82597740409 0
1 PIN_FLD_BALANCES ARRAY [36] allocated 20, used 1
2 PIN_FLD_CREDIT_PROFILE INT [0] 0
......................................................................................

So the events are getting dequeued after the pipeline loads all the data from the DB, which is wrong.


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