Pipeline Stopped When Changing StoreLimit and BufferLimit With Semaphore (Doc ID 850503.1)

Last updated on JUNE 22, 2017

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 21-Jan-2013***
***Checked for relevance on 24-Feb-2015***

Symptoms

When processing a semaphore file to change the StoreLimit and BufferLimit for one of the Mediation Pipelines, its stops with the message:

12.06.2009 15:07:59 brmRoamD ifw IFW NORMAL [T:3] 00129 - (ifw.Registry)
INF_BEGIN_REG_UPDATE | Begin to process the command for registry update:
'ifw.Pipelines.GSM_MEDIATION.Functions.Standard.FunctionPool.DuplicateCheck.Module.BufferLimit =
20090612 ' .
12.06.2009 15:08:00 brmRoamD ifw IFW NORMAL [T:27] 00093 -
(ifw.Pipelines.SMS_MEDIATION) INF_PIPELINE_STOP | The pipeline 'ifw.Pipelines.SMS_MEDIATION' is
stopped (inactive).
12.06.2009 15:08:00 brmRoamD ifw IFW NORMAL [T:24] 00093 -
(ifw.Pipelines.GSM_MEDIATION) INF_PIPELINE_STOP | The pipeline 'ifw.Pipelines.GSM_MEDIATION' is
stopped (inactive).
12.06.2009 15:08:00 brmRoamD ifw IFW NORMAL [T:30] 00093 -
(ifw.Pipelines.MMS_MEDIATION) INF_PIPELINE_STOP | The pipeline 'ifw.Pipelines.MMS_MEDIATION' is
stopped (inactive).
12.06.2009 15:08:00 brmRoamD ifw IFW NORMAL [T:33] 00093 -
(ifw.Pipelines.GPRS_MEDIATION) INF_PIPELINE_STOP | The pipeline 'ifw.Pipelines.GPRS_MEDIATION' is
stopped (inactive).
12.06.2009 15:08:09 brmRoamD ifw IFW MAJOR [T:3] 00000 -
(ifw.Pipelines.GSM_MEDIATION.Functions.Standard.FunctionPool.DuplicateCheck.Module)
ERR_PROC_EXEC_FAILED | Procedure: PROC_CREATE_IDX_DUPCHK execute failed , Vendor Error: 959
12.06.2009 15:08:09 brmRoamD ifw IFW WARNING [T:3] 00131 - (ifw.Registry)
INF_ERROR_REG_UPDATE | Error occurred during command processing: update objects failed; PIPELINES
DEACTIVATED; please check system consistency and start pipelines manually.


There are 4 custom pipelines for mediation and the Duplicate Checks are configured on these pipelines. This error can happen in any pipeline.
Once this error appears, the table Index is dropped.

Pipeline has <patch 7552887> has been applied on top of BRM 7.3.1.

One of the FCT_DuplicateCheck modules is configured as following:

#--------------------------------------------------
# Duplicate Check
#--------------------------------------------------
DuplicateCheck
{
  ModuleName = FCT_DuplicateCheck
  Module
  {
    Active = True
    DataConnection = ifw.DataPool.Login
    Path = $PIN_HOME/ifw/data/GSM/dup
    FileName = calls.duplicate
    StreamName = SuspenseCreateOutput
    StoreLimit = 20080601
    BufferLimit = 20080825
    SearchKey = DETAIL.A_NUMBER
    TableSuffix = GSM
    TableSpaceName = PORTAL_DAT
    IndexSpaceName = PORTAL_IDX
    Fields
    {
      1 = DETAIL.B_NUMBER
      2 = DETAIL.SOURCE_NETWORK
      3 = DETAIL.CONNECT_TYPE
      4 = DETAIL.RECORD_TYPE
      5 = DETAIL.CHARGING_START_TIMESTAMP
    }
  }
}

DuplicateCheck module version is 10026.

Custom sql files are used to create the Dup_Check tables and its indexes.

-- Steps To Reproduce:
1 - Start the pipeline.
2 - Create the semaphore file MEDIATION_semaphore.reg and send the same semaphore to pipeline:

ifw.Pipelines.MMS_MEDIATION.Functions.Standard.FunctionPool.DuplicateCheck.Module.BufferLimit = 20090612

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