cancel
Showing results for 
Search instead for 
Did you mean: 

SAP dump when executing more than 2 mdx statements in scripts

Former Member
0 Kudos

Dear experts,

I met an BPC script issue when trying to execute more than 2 mdx statements.

Here's script:

*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)

*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)

*XDIM_MEMBERSET TIME_PROC=2011.H1

*XDIM_MEMBERSET RPTCURRENCY=CNY

*XDIM_MEMBERSET CATEGORY=C800

*XDIM_MEMBERSET PERIOD_PROC=P08

*XDIM_MEMBERSET DATASRC=INPUT

*XDIM_MEMBERSET ACCOUNT_PROC=CG1007,CG1008,CG1009,CG1010,CG1013,CG1014,CG1015,CG1016,CG1017,CG1018

[ACCOUNT_PROC].[#CG1015]=(([ACCOUNT_PROC].[CG1007][ACCOUNT_PROC].[CG1008][ACCOUNT_PROC].[CG1009]) / 1.17 ) * (1 - [ACCOUNT_PROC].[CG1010]) - [ACCOUNT_PROC].[CG1013] - [ACCOUNT_PROC].[CG1014]

*COMMIT

*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018

[ACCOUNT_PROC].[#CG1016]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015])

[ACCOUNT_PROC].[#CG1018]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015]) - [ACCOUNT_PROC].[CG1017]

*COMMIT

When I populated ([#CG1015] and [#CG1016]) or ([#CG1016] and [#CG1018] ) in UJKT, it works fine. But if all these 3 statements included, UJKT will throw an error.

Termination occurred in the ABAP program "SAPLRRK0" - in "CHECK_KHANDLE".

The main program was "UJ0_START_PLAN ".

In the source code you have the termination point in line 34

of the (Include) program "LRRK0F05".

The program "SAPLRRK0" was started as a background job.

Job Name....... "BPC_4KWJ5B407J38PYXVRAHCB1890"

Any ideas on this?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I dont see any problem with the script. Can you please try to keep the entire logic in a single commit. How does it go?

Former Member
0 Kudos

I've tried to put all MDX statements in one commit, same issue happened in UJKT and DM.

But it is wired that following changes can be executed correctly from DM. I don't know why.


*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT
*XDIM_MEMBERSET ACCOUNT_PROC=CG1007,CG1008,CG1009,CG1010,CG1013,CG1014,CG1015,CG1016,CG1017,CG1018

*BEGIN
[ACCOUNT_PROC].[#CG1015]=(([ACCOUNT_PROC].[CG1007]+[ACCOUNT_PROC].[CG1008]+[ACCOUNT_PROC].[CG1009])
                                                 / 1.17 ) * (1 - [ACCOUNT_PROC].[CG1010])
                                               - [ACCOUNT_PROC].[CG1013] - [ACCOUNT_PROC].[CG1014]
*END

*COMMIT

*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT

*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018

[ACCOUNT_PROC].[#CG1016]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015])

*COMMIT

*XDIM_MEMBERSET ENTITY_PROC=BAS(<ALL>)
*XDIM_MEMBERSET PRODUCT=BAS(<ALL>)
*XDIM_MEMBERSET TIME_PROC=%TIME_PROC_SET%
*XDIM_MEMBERSET RPTCURRENCY=CNY
*XDIM_MEMBERSET CATEGORY=C800
*XDIM_MEMBERSET PERIOD_PROC=$V_PERIOD$
*XDIM_MEMBERSET DATASRC=INPUT

*XDIM_MEMBERSET ACCOUNT_PROC=CG1015,CG1016,CG1017,CG1018

[ACCOUNT_PROC].[#CG1018]=IIF([ACCOUNT_PROC].[CG1015]<0,0,[ACCOUNT_PROC].[CG1015]) - [ACCOUNT_PROC].[CG1017]

*COMMIT

Former Member
0 Kudos

Hi,

I would request you to put each commit section in UJKT and see which part is giving the problem and let us know your findings.

Answers (0)