Error when hardcoding selections into Data Manager Package Delta

[Former Member]

Hi all,

I am trying to hardcode some selections for a data manager package which performs a delta load of data. I am encountering the following error message:

"Failed to analyze instruction INFO"

the advanced script is as follows:

INFO(%INFOPROV_INIT_NAME%, "delta_load")

INFO(%RUNLOGIC%,0)

INFO(%CHECKLCK%,0)

INFO(%KEYDATE%,0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%KEYDATE%,0)

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/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%)

What am I missing/doing wrong here?

Thanks in advance,

Nishil

[former_member186338]

Please show the log of the standard package without fixing %INFOPROV_INIT_NAME%

With

PROMPT(INFOPROVINITNAME,%INFOPROV_INIT_NAME%,"Please select delta initialization")

Vadim

[Former Member]

Hey Vadim,

Thanks for the response.

after following you instruction and running the DMP, It fails and shows the following:

[Selection]

--------------------------------------------------------------

INFOPROV_INIT_NAME = delta_load

　

[Message]

--------------------------------------------------------------

Failed to analyze instruction INFO

model: MATCHING. Package status: RUNNING

[former_member186338]

Sorry, I am talking about original, not modified package!

Simply create a new one - just default script for /CPMB/LOAD_DELTA_IP

Run it and show the log!

Vadim

[former_member186338]

P.S. And some comment about INFO - just put text after comma:

Not: INFO(%INFOPROV_INIT_NAME%, "delta_load")

But: INFO(%INFOPROV_INIT_NAME%,delta_load)

Vadim

[Former Member]

Hi,

Running the standard package returns successfully as:

[Former Member]

Thanks for the info, I have tried both ways and neither work but I will leave it as

INFO(%INFOPROV_INIT_NAME%,delta_load)

In future. 

[former_member186338]

Then try:

INFO(%INFOPROV_INIT_NAME%,delta_test)

Instead of:

PROMPT(INFOPROVINITNAME,%INFOPROV_INIT_NAME%,"Please select delta initialization")

[Former Member]

Hi Vadim,

that replacement leads to a warning and the following log:

[former_member186338]

Looks correct - nothing to load now since previous run...

You can see that selection is correct - as it's defined for delta_test

Vadim

[Former Member]

sorry I didn't mention - I had cleared all the data in the BPC cube before that last run and there is still nothing in there, so it cannot be correct

Cheers

Nishil

[former_member186338]

What is the result of second run of standard package?

[Former Member]

Hi Vadim,

that replacement leads to a warning and the following log:

[former_member186338]

Same result - nothing to load! Try to create a new delta initialization!

I don't see an issue with your original question. Please read how delta load works in EPM help:

40.5.11 About Delta Initialization

Vadim