I am facing issue RUNLOGIC_PH split time period

[former_member6334]

Hi All,

I am also facing issue in RUNLOGIC_PH code.

I am trying run-allocation script for 12 or 18 months and it is taking more time. then we plan to run through RUNLOGIC_PH where time selection will split for parallel execution.

Her below blog that i am try for this..

see the line..4.3.4 Run the Calling Script (RUNLOGIC_PH)

http://a248.g.akamai.net/n/248/420835/ee59edcf1448740ecb046a544ab13c4c2992c1441f6ff9ac092fb9ff29d3c5...

Her i am try to call logic RUNLOGIC_PH..it is getting abort. Can you please help me her how can i split my time period for parallel execution. below code for RUNLOGIC_PH is correct..?

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET PROFITCENTER = $PROFITCENTER_SELECTION$
*XDIM_MEMBERSET COSTCENTER = $COSTCENTER_SELECTION$
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET FLOW = CL_05
*XDIM_MEMBERSET SCOPE = G_NONE
*XDIM_MEMBERSET RPTCURRENCY = LC
*START_BADI RUNLOGIC_PH
QUERY = OFF
WRITE = ON
VALIDATION = OFF
LOGIC = T1.LGF
APP = FLASH_RFC_DIV
DIMENSION TIME = %TIME_SET%
CHANGED = TIME 
*END_BADI

I am passing selection from data manager package based on that my logic should split the time period if i select 4 months it should be run for 4 months at parallel..

PARALLEL_EXECUTION(ON)
PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%ENTITY_DIM%,%TIME_DIM%")
PROMPT(SELECT, %COSTCENTER_SELECTION%,, "Select the COSTCENTER" , "COSTCENTER")
PROMPT(SELECT, %PROFITCENTER_SELECTION%,, "Select the PROFITCENTERS" , "PROFITCENTER")
PROMPT(TEXT,%PRFCT%,"Enter profitcenter group")

INFO(%EQU%,=)
INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)
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,SELECTION,%SELECTION%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,GLACCOUNT%EQU%%GLACCOUNT%%TAB%PRFCT%EQU%%PRFCT%%TAB%ALLOC_BASE%EQU%%ALLOC_BASE%)
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION, COSTCENTER_SELECTION%EQU%%COSTCENTER_SELECTION%%TAB%PROFITCENTER_SELECTION%EQU%%PROFITCENTER_SELECTION%)

***************

When i am running below logic it perfectly working fine her the issue when user is selecting time data manager package it is for 12 or 18 months it taking more time to execute the logic..

The FLASH_RFC_DIV Model: T1.LGF (Called Code)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*XDIM_MEMBERSET PROFITCENTER = $PROFITCENTER_SELECTION$
*XDIM_MEMBERSET COSTCENTER = $COSTCENTER_SELECTION$
*XDIM_MEMBERSET ENTITY = %ENTITY_SET%
*XDIM_MEMBERSET FLOW = CL_05
*XDIM_MEMBERSET SCOPE = G_NONE
*XDIM_MEMBERSET RPTCURRENCY = LC
*SELECT(%PREV%, PREV_CATEGORY, CATEGORY, ID = %CATEGORY_SET%) *SELECT(%YR%, NEXTYEAR, CATEGORY, ID = %CATEGORY_SET%)
*SELECT(%CY%, YEAR, CATEGORY, ID = %CATEGORY_SET%)
*SELECT(%RFCMNTH%, STARTMNTH, CATEGORY, ID = %CATEGORY_SET%) *SELECT(%TIMYR%,"[TIMEID]",TIME,"[TIMEID] >= %YR%0100 AND [TIMEID] <= %YR%1200")
*SELECT(%TIMN%,"[TIMEID]",TIME,"[TIMEID] <> %TIMYR% AND [ID] = %TIME_SET%'") *SELECT(%MNTHSCYM%,"[ID]", TIME,"[TIMEID] >= %CY%%RFCMNTH% AND [TIMEID] = %TIMN%'")

*FOR %GLSET% = ALMAPAYROLL
*FOR %TIM% = %MNTHSCYM%
*RUNALLOCATION 
*FACTOR = USING/TOTAL
*DIM COSTCENTER WHAT = ALMANONE;WHERE = $COSTCENTER_SELECTION$,ALMANONE ;USING = <<<; TOTAL = <<<
*DIM ACCOUNT WHAT = ALMANONE ;WHERE <> ALMA; USING = <<<; TOTAL = <<<
*DIM PROFITCENTER WHAT = $PRFCT$_ND;WHERE = $PROFITCENTER_SELECTION$ ; USING = <<<; TOTAL = <<<
*DIM GLACCOUNT WHAT = %GLSET%_ND; WHERE = BAS(%GLSET%); USING = <<<; TOTAL = <<<
*DIM TIME WHAT = %TIM%; WHERE = <<<; USING = <<<; TOTAL = <<<
*DIM ENTITY WHAT = ALMA ; WHERE = %ENTITY_SET%; USING = <<< ; TOTAL = <<< *DIM CATEGORY WHAT = %CATEGORY_SET%; WHERE = <<<; USING = %PREV%; TOTAL = <<<
*DIM SEGMENT WHAT = SNONE; WHERE<>ALMA; USING = <<<; TOTAL = <<<
*ENDALLOCATION
*NEXT
*NEXT

[former_member186338]

Please prepare your question in a readable form!

Use "Code" button to post code.

Check line breaks.

Remove useless commented lines.

Provide additional info based on: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

P.S. I am not sure that your code is the best for performance, first it's necessary to understand what do you want to achieve!

[former_member6334]

Hi Vadim,

Now time split is working fine now..

I am getting warning error msg..

Can you please help me on this...?

APPLICATION:FLASH_RFC_DIV
[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:ACCOUNT WILL QUERY ON ALL BASE MEMBERS.
[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:AUDITTRAIL WILL QUERY ON ALL BASE MEMBERS.
[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:GLACCOUNT WILL QUERY ON ALL BASE MEMBERS.
[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:SEGMENT WILL QUERY ON ALL BASE MEMBERS.
EXECUTION BADI:RUNLOGIC_PH
QUERY: OFF
WRITE: ON
                                               10 Data Regions will be generated.
                                                4 parallel processes will be used.
Dimension TIME memeber 2019.03 used for a new Data Region.
Process Task  1 Started at 13:58:48 .
Dimension TIME memeber 2019.04 used for a new Data Region.
Process Task  2 Started at 13:58:48 .
Dimension TIME memeber 2019.05 used for a new Data Region.
Process Task  3 Started at 13:58:48 .
Dimension TIME memeber 2019.06 used for a new Data Region.
Process Task  4 Started at 13:58:48 .
Dimension TIME memeber 2019.07 used for a new Data Region.
Process Task  1 Ended at 14:02:51 succesfully.
Dimension TIME memeber 2019.07 used for a new Data Region.
Process Task  6 Started at 14:02:51 .
Dimension TIME memeber 2019.08 used for a new Data Region.
Process Task  2 Ended at 14:02:52 succesfully.
Dimension TIME memeber 2019.08 used for a new Data Region.
Process Task  8 Started at 14:02:52 .
Dimension TIME memeber 2019.09 used for a new Data Region.
Process Task  3 Ended at 14:02:53 succesfully.
Dimension TIME memeber 2019.09 used for a new Data Region.
Process Task 10 Started at 14:02:53 .
Dimension TIME memeber 2019.10 used for a new Data Region.
Process Task  4 Ended at 14:02:55 succesfully.
Dimension TIME memeber 2019.10 used for a new Data Region.
Process Task 12 Started at 14:02:55 .
Dimension TIME memeber 2019.11 used for a new Data Region.
Process Task  6 Ended at 14:06:46 succesfully.
Dimension TIME memeber 2019.11 used for a new Data Region.
Process Task 14 Started at 14:06:46 .
Dimension TIME memeber 2019.12 used for a new Data Region.
Process Task  8 Ended at 14:06:50 succesfully.
Dimension TIME memeber 2019.12 used for a new Data Region.
Process Task 16 Started at 14:06:50 .
Process Task 10 Ended at 14:06:58 succesfully.
Process Task 12 Ended at 14:06:59 succesfully.
Process Task 16 Ended at 14:09:58  with error.
Error obtaining concurrency lock (enqueue_server_b usy)
Process Task 14 Ended at 14:12:46 succesfully.
                                                1 processes failed out of                                                10.
BADI EXECUTION TIME IN TOTAL :875.00 ms.
MESSAGE FROM CUSTOM LOGIC:
W::020                                                 

[former_member186338]

Now it's much better) I will look on the issue

[former_member186338]

First strange thing:

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,GLACCOUNT%EQU%%GLACCOUNT%%TAB%PRFCT%EQU%%PRFCT%%TAB%ALLOC_BASE%EQU%%ALLOC_BASE%)

But

%GLACCOUNT% and %ALLOC_BASE%

are not assigned...

???

[former_member186338]

Second strange thing:

*DIM COSTCENTER WHAT = ALMANONE;WHERE = $COSTCENTER_SELECTION$,ALMANONE ;USING = <<<; TOTAL = <<<
*DIM ACCOUNT WHAT = ALMANONE ;WHERE <> ALMA; USING = <<<; TOTAL = <<<

Do you really have ALMANONE as a member of both COSTCENTER and ACCOUNT???

Very bad idea!

[former_member186338]

Third strange thing:

*FOR %GLSET% = ALMAPAYROLL

What do you mean by this line???

[former_member186338]

And at the end - I am unable to understand the required logic with TIME selection based onyour script! Please explain it in words and samples!

[former_member6334 · Accepted solution]

Thank you Vadim

Issue is with RUNLOGIC_PH for split time period which will execute parallel for selected months.

We have missed one paramater in SPRO setting which we have corrected

In SPRO transaction, you have set global parameter PARALLEL_SERVER_GROUP=parallel_generators
In RZ12 transaction, you have set:
Logon Group Instance
parallel_generators XXXXXX

Warning msg which we got is concurrency lock..?

I have followed step with this sap note 1960682 to fix the concurrency lock issue

Error obtaining concurrency lock (enqueue_server_b usy)

Thanks,

Kaman singh

[former_member186338 · Accepted solution]

Anyway, your script code is somehow strange and have to be corrected!