SAP BPC Datamanager Issue - FPMXLClient.Common.InternalServerErrorException

[karwen]

error.txt

Dear experts,

we are currently facing a strange issue in our SAP BPC 10.1 NW system. We got several custom DM packages which all include a REPLACEPARAM statement for updating the script logic behind. These DM packages run all well, but, and this is the strange thing, only once. If we execute them a second time, we get the error message attached. The BW transaction ST22 did not receive any error, but the SLG1 shows the following message:

Following the instructions in the message (logoff and logon) does not solve the problem. Deleting meta data cache neither. Any research did not help.

Does anyone of you guys know, how to solve this issue? We are running on BPC 10.1 SP16 and SAP BW SP18.

Thank you in advance,

Karsten

[former_member186338 · Accepted solution]

"Version 10.0 SP23 .NET 4, Build 9256" - very old!

Try something recent!

[former_member186338 · Accepted solution]

P.S. May be it's even not fully compatible with your current BPC 10.1 SP!

[karwen · Accepted solution]

A possible upgrade is already in discussion at this customer. I have a PC with the new SP32 here next to me for testing purposes. I will give it a try and let you know how it worked.

[former_member186338 · Accepted solution]

If you will have no issues with SP32 then you can test some older versions to find the minimum SP required.

[karwen · Accepted solution]

Same behaviour on SP32 😞

[former_member186338 · Accepted solution]

Absolutely strange! Never have any issues with REPLACEPARAM!

Try very simple test:

Create new DM package based on chain /CPMB/DEFAULT_FORMULAS

PROMPT(TEXT,%CATMEMBER%,"Enter CATEGORY",,)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,CATMEMBER%EQU%%CATMEMBER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)

$CATMEMBER$ variable will be passed using REPLACEPARAM

with the script like:

*XDIM_MEMBERSET CATEGORY=$CATMEMBER$ //use your name for category dimension
// Add extra scoping for other dimensions to narrow down the scope
*WHEN CATEGORY //use your name for category dimension
*IS *
*REC(EXPRESSION=%VALUE%) // no changes
*ENDWHEN

And post results!

[karwen · Accepted solution]

Hi Vadim,

ran this DM package 5 times in a row without any problems.

Thanks, Karsten

[former_member186338 · Accepted solution]

Then the issue is not related to REPLACEPARAM

Please post advanced DM script and script logic for the package generating error (try to simplify it as much as possible)

[karwen · Accepted solution]

It's the same we talked about in another thread (regarding time dependent hierarchies and eliminations):

PROMPT(SELECT,%SELECTION%,,"Please make your selections ...","%ENTITY_DIM%,%CATEGORY_DIM%,%TIME_DIM%",0)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/IC_ELIMINATION_LOGIC,TAB,%TAB%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,EQU,%EQU%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,REPLACEPARAM,KD%EQU%%SELECTION_KEYDATE%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SUSER,%USER%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,LOGICFILENAME,ICELIM.LGF)

And in the script logic:

*RUN_PROGRAM US_ELIM
CATEGORY = %CATEGORY_SET%
CURRENCY = EUR,CHF
TID_RA = %TIME_SET%
OTHER = [PRCTR=%PRCTR_SET%]
KEYDATE = $KD$
*ENDRUN_PROGRAM

Thanks, Karsten

[former_member186338 · Accepted solution]

By the way, have you added KEYDATE parameter to this chain?

Then try to add:

TASK(/CPMB/IC_ELIMINATION_LOGIC,KEYDATE,%SELECTION_KEYDATE%)

[karwen · Accepted solution]

Yeah, I did and the package works as expected.

If I use your statement, then the KEYDATE will be ignored by the script logic and the current KEYDATE will be used. That was the reason, why we choosed the approach above using prompt variable $KD$.

[former_member186338 · Accepted solution]

I told you in my previous message to use both methods!

[karwen · Accepted solution]

Like this?

PROMPT(SELECT,%SELECTION%,,"Please make your selections ...","%ENTITY_DIM%,%CATEGORY_DIM%,%TIME_DIM%",0)
INFO(%EQU%,=)
INFO(%TAB%,;)
TASK(/CPMB/IC_ELIMINATION_LOGIC,TAB,%TAB%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,EQU,%EQU%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,KEYDATE,%SELECTION_KEYDATE%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,REPLACEPARAM,KD%EQU%%SELECTION_KEYDATE%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SUSER,%USER%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPPSET,%APPSET%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SAPP,%APP%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,SELECTION,%SELECTION%)
TASK(/CPMB/IC_ELIMINATION_LOGIC,LOGICFILENAME,ICELIM.LGF)

[former_member186338 · Accepted solution]

Yes, with the same script logic!

[karwen · Accepted solution]

Same error. Runs once and then the error occurs.

[former_member186338 · Accepted solution]

Looks like you need to open discussion with SAP support! Your case require ABAP debugging and I can't do it on my system, because I don't have TDH enabled (it's a global setting)

[karwen · Accepted solution]

Found the reason ...

It depends on the saved prompt values in the system. If you run the package and afterwards clear the saved prompts, then it works. There is a setting in the DM pane (More - Clear Saved Prompt Values ...). If you do so, it will work.

Do you know if there is a possibility to add this clearing to the package in some way (process chain or script etc.)?

[former_member186338 · Accepted solution]

But after you cleared saved prompts then the issue disappears completely? Or you have to clear it each time?

[karwen · Accepted solution]

Each time after the package ran 😞

Otherwise the error will occur again.

[former_member186338 · Accepted solution]

Then again: "you need to open discussion with SAP support" - definitely a system bug!

"Do you know if there is a possibility to add this clearing to the package in some way (process chain or script etc.)?" - not possible to my mind!

[karwen · Accepted solution]

OK, I will do so.

I recently checked all BPC process types in order to add such a process type to the existing chain. Unfortunately, there is none - only "Clear temp data" and this does not include prompt values.

Thank you very much for your help again 🙂

Karsten

[former_member186338 · Accepted solution]

Saved prompts are stored locally on the user PC! Like on my PC:

C:\Users\KalininVE\Documents\PC_NW\PCNAME\KalininVE\AppInfo\SHELLTEST\Planning\DataManager\KalininVE\DMUserSelection.xml

You can try to analyze what is going wrong 🙂

[karwen]

Hi Vadim,

I already tried this, but without any success. Data checker did not show any issues, caches are cleared and refreshed.

It is really strange that all DM packages with a REPLACEPARAM statement run only once.

Regards,

Karsten

[former_member186338]

And what do you have in the dm package log?

[karwen]

Hi Vadim,

DM package log does not change. It always shows success and does the right calculations. If the error message appears, it is possible to click continue and the package runs through without any errors. The mentioned error only appears if the package gets started.

Regards,

Karsten

[former_member186338]

Sorry, but what do you mean by error message? Screenshot, please!

[karwen]

The attached file (error.txt) shows the error 🙂

[former_member186338]

Not clear! What do you see on the screen? Some pop-up? Where do you press "continue"?

[karwen]

Screen (pop-up) looks like this:

[former_member186338]

Ups, now it's clear 🙂 Never seen the error like this!

What is your EPM client version/SP?

[karwen]

We are running on Version 10.0 SP23 .NET 4, Build 9256.

Interestingly, the look of the DM package itself changes. The whole background is missing. See the screen below:

The standard package should look like this (IC Elim is just a copy of IC Elimination). Both behave in the same way:

[former_member186338]

I recommend you to refresh master data cashes for TDH

UJA_REFRESH_DIM_CACHE
UJXO_CLEAN_CACHE
UJXO_CLEAN_DIM_CACHE
UJXO_CLEAN_TDH_DIM_CACHE
UJA_DATA_CHECKER