Error While Processing Reload Semaphore For FCT_SocialNo (Doc ID 728707.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0 to 7.3.0.0.1
This problem can occur on any platform.

Symptoms

Consider one is using the FCT_SocialNo plugin with several million entries in IFW_SOCIALNUMBER table. These entries are updated periodically, for which a semaphore is issued as below :

ifw.Pipelines.IFW_VOIP_CM.Functions.PreProcessing.FunctionPool.SocialNo.Module.Reload {}

However, after processing the semaphore, an error is logged and the pipelines are not re-activated.
The error is:

15.07.2008 14:57:57 s0000001 IFW_VOIP_CM IFW NORMAL [T:3] 00188 -
(ifw.Pipelines.IFW_VOIP_CM.Functions.PreProcessing.FunctionPool.SocialNo.Module) Start data
loading from database table 'ifw_socialnumber'.
15.07.2008 15:04:09 s0000001 IFW_VOIP_CM IFW NORMAL [T:3] 00235 -
(ifw.Pipelines.IFW_VOIP_CM.Functions.PreProcessing.FunctionPool.SocialNo.Module) 5933676 lines read.
15.07.2008 15:04:09 s0000001 IFW_VOIP_CM IFW NORMAL [T:3] 00189 -
(ifw.Pipelines.IFW_VOIP_CM.Functions.PreProcessing.FunctionPool.SocialNo.Module) Finished data
loading (ifw_socialnumber).
15.07.2008 15:04:09 s0000001 IFW_VOIP_CM IFW WARNING [T:3] 00131 - (ifw.Registry)
Error occurred during command processing: update objects failed; PIPELINES DEACTIVATED; please
check system consistency and start pipelines manually.

Note that patch 6962071 (fixing FCT_SocialNo performance issue at startup), was recently installed.

-- Steps To Reproduce:
1. Start pipeline
2. Issue reload semaphore for FCT_SocialNo
3. The error is logged as above


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