Can you provide a full details on your Delta load?
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
I was able to fix the issue by applying the following notes:
Add comment