Skip to Content

BPC Delta load, rejected records are not loaded in the subsequent run

Situation at one of my clients:

The have a new account in the account structure. This is loaded during the nightly loads into BW. However, this load failed, the account is now not in BPC. During the delta load, the records for this account have been rejected. This all works fine. However, in the delta load I have flagged KEEP_REJECT_DATA to be 1. We add the missing account to BPC, but the next time the delta load is executed, the missing records are not loaded into BPC.

Is there something else I need to configure in order for this to work?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 18, 2017 at 02:31 PM

    Can you provide a full details on your Delta load?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2017 at 02:54 PM

    Sure.

    We are loading data from a cube with financial data, which has 0ACCOUNT in it as an object. We filter on:

    Fiscal year between 2017 and 9999
    Currency type = 10

    For the options, when executing the package, we have selected:
    Run default logic = 0
    Check work status = No
    Keep rejected data = Yes, keep the rejected data for the next delta loading

    Below is the script that is called in the data manager package:

    PROMPT(INFOPROVINITNAME,%INFOPROV_INIT_NAME%,"Please select delta initialization")
    PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})
    PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})
    PROMPT(KEYDATE,%KEYDATE%,"Key date",0)
    PROMPT(RADIOBUTTON,%KEEPREJDATA%,"IF Keep Rejected Data",0,{"Yes, Keep the rejected data for the next delta loading","No, Do not keep the rejected data for the next delta loading"},{"1","0"})
    INFO(%TEMPNO1%,%INCREASENO%)
    INFO(%TEMPNO2%,%INCREASENO%)
    INFO(%KEYDATE%,)
    TASK(/CPMB/SOURCE_DELTA_IP,OUTPUTNO,%TEMPNO1%)
    TASK(/CPMB/SOURCE_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
    TASK(/CPMB/SOURCE_DELTA_IP,BYPASS_COMPRESS,0)
    TASK(/CPMB/SOURCE_DELTA_IP,KEEP_REJECT_DATA,%KEEPREJDATA%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,OUTPUTNO,%TEMPNO2%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,SUSER,%USER%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPPSET,%APPSET%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,SAPP,%APP%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,INPUTNO,%TEMPNO1%)
    TASK(/CPMB/INFOPROV_DELTA_CONVERT,KEYDATE,%KEYDATE%)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,INPUTNO,%TEMPNO2%)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,RUNLOGIC,%RUNLOGIC%)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,CHECKLCK,%CHECKLCK%)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,INFOPROV_INIT_NAME,%INFOPROV_INIT_NAME%)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,PREPROCESSMODE,0)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,TARGETMODE,0)
    TASK(/CPMB/APPEND_LOAD_DELTA_IP,KEYDATE,%KEYDATE%)
    With kind regards,

    Tim

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 02 at 06:47 AM
    Add comment
    10|10000 characters needed characters exceeded