BPC DM package failure /CPMB/LOAD_INFOPROVIDER

[Former Member]

Hi Experts,

/CPMB/LOAD_INFOPROVIDER ( BPC: Import transnational data from BW info provider without prompts)

DM package is getting with below error

Error:Failed to analyze instruction /CPMB/CLEAR_DATA,INPUTNO,%TEMPNO1%

Kindly help me from this issue.

Thanks

Raji P

[Former Member]

Hello Raji,

Would you please follow the steps below:

1. Run TCode 'SE16' and input table name 'RSCOMPTLOGO'
2. Check whether
there are two entries whose APPLNM fields are ‘/CPMB/BPC_EXAMPLE’ and
‘/CPMB/BPC’ respectively. If they are not in the table, you have to add
them.
Change them (either the existing ones or newly created ones) as
below:


3. Run TCode ‘RSPC’.
4. Delete the problematic chains
(whose Modify version does not equal to Activate version). Usually it’s Light
optimize and Full optimize.
5. Run TCode ‘SE38’ to execute program
‘UJS_ACTIVATE_CONTENT’ with option ‘Activate BI Content’ checked!

6.Please run UJS_ACTIVATE_CONTENT program again with only 'Update
DM Instructions' option checked.

Kind Regards,

Yosra

[former_member673393]

Hi Yosra,

I could not see the screenshot you have posted , could you please re-post screen-shots. I see, I can get solution to my problem from your answer.

Thanks,

[former_member186338]

kumamuk3

It's absolutely bad idea to comment in 4 years old post and to ask something from "Former Member"

Please, ask new question!

[former_member186338]

Please show full DM advanced script!

Vadim

[Former Member]

Hello Vadim,

below is the script for that perticuler DM package.

DEBUG(ON)

PROMPT(MESSAGE,"Load Budget Data from NS_PLANNING (/CPMB/XCVBNDF)")

INFO(%InforProvide%,/CPMB/XCVBNDF)

INFO(%CLEARDATA%,0)

INFO(%TRANSFORMATION%,\ROOT\WEBFOLDERS\SH_QWE\SEC\DATAMANAGER\TRANSFORMATIONFILES\SHl_QWAS_TRANS.xls)

INFO(%RUNLOGIC%,0)

INFO(%CHECKLCK%,0)

INFO(%INO%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%INO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,CLEARDATA,%CLEARDATA%)

TASK(/CPMB/CLEAR_DATA,INPUTNO,%INO%)

TASK(/CPMB/CLEAR_DATA,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/APPEND_LOAD,INPUTNO,%INO%)

TASK(/CPMB/APPEND_LOAD,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/APPEND_LOAD,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/APPEND_LOAD,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/APPEND_LOAD,CLEARDATA,%CLEARDATA%)

Thanks

Raji P

[former_member186338]

I see an attempt to customize the standard DM package...

And I don't see something like:

/CPMB/CLEAR_DATA,INPUTNO,%TEMPNO1%

What chain are you using?

Please read:

Vadim

[Former Member]

Hello,

Below is the chain name.

/CPMB/LOAD_INFOPROVIDER

Thanks

Raji P

[former_member186338]

BPC version and SP?

[former_member186338]

And in general - create a new DM package with the chain /CPMB/LOAD_INFOPROVIDER and default advanced script. Ensure it's running OK. Then start customization!

Vadim

[Former Member]

Hello,

Below are the BPC and BW version and SP details.

BPC     810     SP02

BW      740     SP07

Thanks

Raji P

[former_member186338]

Old, but anyway - use my previous answer!

[former_member186338]

By the way, the standard DM advanced script for /CPMB/LOAD_INFOPROVIDER will look like:

PROMPT(TEXT,%InforProvide%,"Please enter InfoProvider to download data",)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",0,{"Append","Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"0","1","2"})

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)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

[former_member186338]

By the way - do you upgrade from BPC 7.5?

Then not all steps were completed.

Vadim

[Former Member]

Vadim,

We were upgraded long back to 10.1 and below are the BPC and BW version details

BPC     810     SP02

BW      740     SP07

Regards

Raji P

[former_member186338]

Please look on the DM package advanced scripts in the ENVIRONMENTSHELL.

Vadim

[chuan_ding]

Hi Raji

I think you need to re-create BPC process chains.
You may take a look at the note below for detailed steps.
2069554 - BPCNW - Process Chain Execution Failed

Best regards,
Chuan