"proc_create_idx_dupchk" Execution Failed While Processing Storelimit/Bufferlimit Semaphore (Doc ID 1104527.1)

Last updated on APRIL 28, 2016

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.

Goal

Passing a semaphore to set storelimit and bufferlimit for duplicate check plugin results in following error and makes pipeline inactive :

*  Snippet from pipeline log :

(ifw.Pipelines.RATING_SMS.Functions.PreProcessing.FunctionPool.DuplicateCheck.Module) ERR_PROC_EXEC_FAILED | Procedure: PROC_CREATE_IDX_DUPCHK execute failed , Vendor Error: 2158



*  Below is the duplicate check plugin configuration from the registry :

DuplicateCheck
{
ModuleName = FCT_DuplicateCheck
Module
{
Active = True
DataConnection = ifw.DataPool.Login

Path = /ifw/data/Rating/dup
FileName = call.duplicate.telephony_A
StreamName = DuplicateOutput

BufferLimit = 20091129
StoreLimit = 20091104


NumberOfThreads = 26
NumberOfStartupThreads = 20

SearchKey = DETAIL.A_NUMBER
IndexSpaceName = int_ic.INT_IC_TS_1_IDX
TableSpaceName = int_ic.INT_IC_TS_1_DAT

TableSuffix = IC_TEL_A

Fields
{
1 = DETAIL.B_NUMBER
2 = DETAIL.CHAIN_REFERENCE
3 = DETAIL.SOURCE_NETWORK_TYPE
}
}
}


*  In above configuration , notice that "int_ic" is the schema name while "INT_IC_TS_1_IDX" and "INT_IC_TS_1_DAT" is the table space name

*  Below is the semaphore that is passed to the pipeline :

ifw.Pipelines.RATING_SMS.Functions.PreProcessing.FunctionPool.DuplicateCheck.Module.BufferLimit= 20091205


* After passing semaphore, if we check database, none of the index on the duplicate check tables would be present

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