Pipeline Failed To Start With Error Err_proc_exec_failed For Proc_check_idx_dupck (Doc ID 802745.1)

Last updated on JANUARY 27, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 to 7.2.1.0.0 [Release 7.2.1]
Information in this document applies to any platform.
Check for relevance on 21-Dec-2010
Check for relevance on 12-Nov-2013.

Symptoms

After IFW_DUPLICATECHECK was partitioned, the index does not get recreated and Patch Pipeline failed to start with the following error:

ifw.log

ifw started at: Fri Mar 13 10:48:29 EDT 2009
Portal Pipeline Server / Version 7.2 10087 started at 13.03.2009 10:48:30.
Copyright (c) 1998 - 2005 Portal Software. All rights reserved.

ifw: An error occurred during creation.

Originator : ifw.Pipelines.DUPCHK.Functions.PreProcessing.FunctionPool.DuplicateCheck.Module
Destination :
Message : ERR_PROC_EXEC_FAILED
Arguments : PROC_CHECK_IDX_DUPCHK
Vendor Error: 0

State : false
Severity : MAJOR
Thread : 1

Portal Pipeline Server / Version 7.2 10087 finished at 13.03.2009 09:49:00.

End Timestamp - Fri Mar 13 10:49:00 EDT 2009@

/opt/esp/scripts/aurora_launcher.sh: Exiting with Return Code = 1


ifw_process.log:

================================ PIPELINE SERVER STARTED ================================   13.03.2009 10:48:35 eapbup02     ifw          IFW       NORMAL   [T:1] 00340 -    (ifw.ProcessLog.Module.ITO) The actual log level is WARNING. All messages with this or higher severity will be logged.
13.03.2009 10:48:40 eapbup02     ifw          IFW       WARNING  [T:1] 30937 -    (ifw.DataPool.DiscountModelDataModule.Module) Unexpected value set for registry  parameter SupportExclusion.
13.03.2009 10:48:55 eapbup02     ifw          IFW       MAJOR    [T:1] 00000 -    (ifw.Pipelines.DUPCHK.Functions.PreProcessing.FunctionPool.DuplicateCheck.Module) Procedure:    PROC_CHECK_IDX_DUPCHK execute failed , Vendor Error: 0   ================================ PIPELINE SERVER STOPPED ================================


-- Steps To Reproduce:
Start Batch Pipeline with Registry entry for DuplicateCheck:

############################################################################
# Parameter: DuplicateCheck
# Purpose: Check for duplicate EDRs.
############################################################################

DuplicateCheck
{
    ModuleName = FCT_DuplicateCheck
    Module
    {
        Active = True
        DataConnection = ifw.DataPool.Login
        Path = /data/PB/integrate/aur401/dupcheck/dup
        FileName = dups
        StreamName = DuplicateOutput
        TableSpaceName = IFW_IDX_L
        IndexSpaceName = IFW_IDX_S
        BufferLimit = 20070906
        StoreLimit = 20070822
        SearchKey = DETAIL.A_NUMBER
        Fields
        {
            1 = DETAIL.BASIC_SERVICE
            2 = DETAIL.B_NUMBER
        }
    }
}

 

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