Mediation Pipeline Failed to Start Due To Error "Procedure: 'PROC_CREATE_IDX_DUPCHK' Execute Failed 'Vendor Error: 959'" (Doc ID 1333529.1)

Last updated on AUGUST 20, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 20-Aug-2013***

Symptoms

Following are steps:-

1) Configure the FCT_DuplicateCheck module

Below is the FCT_DuplicateCheck configuration in the registry:-

#--------------------------------------------------
# Duplicate Check
#--------------------------------------------------
DuplicateCheck
{
    ModuleName = FCT_DuplicateCheck
    Module
    {
        Active = True
        DataConnection = ifw.DataPool.Login
        TableSpaceName = PIN00
        IndexSpaceName = PINX00
        TableSuffix = DISE
        Path = ./data/DISE_MEDIATE/dup
        FileName = call.duplicate
        StreamName = RejectedOutput
        BufferLimit = 20110606
        StoreLimit = 20100101
        SearchKey = DETAIL.C_NUMBER
        NumberOfThreads=1
        Fields
        {
            1 = DETAIL.B_NUMBER
            2 = DETAIL.CHAIN_REFERENCE
        }
    }
}


2) Process the following semaphore variable to change the StoreLimit and BufferLimit of FCT_DuplicateCheck module.

e.g:-
ifw.Pipelines.DISE_MEDIATE.Functions.Mediation.FunctionPool.DuplicateCheck.Module.BufferLimit = 20110613
ifw.Pipelines.DISE_MEDIATE.Functions.Mediation.FunctionPool.DuplicateCheck.Module.StoreLimit = 20110610


Observed following error in process log:-

26.06.2011 18:46:17 vinli005.gmt.intra ifw IFW NORMAL [T:1099192640] 00129 - (ifw.Registry) INF_BEGIN_REG_UPDATE | Begin to process the command for registry update: 'ifw.Pipelines.DISE_MEDIATE.Functions.Mediation.FunctionPool.DuplicateCheck.Module.BufferLimit = 20110613 ifw.Pipelines.DISE_MEDIATE.Functions.Media
26.06.2011 18:46:28 vinli005.gmt.intra ifw IFW MAJOR [T:1099192640] 00000 - (ifw.Pipelines.DISE_MEDIATE.Functions.Mediation.FunctionPool.DuplicateCheck.Module) ERR_PROC_EXEC_FAILED | Procedure: 'PROC_CREATE_IDX_DUPCHK' execute failed, 'Vendor Error: 959'.


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