Neutral Copy Package Link fails on default logic

[former_member202404]

Dear all,

Settings:

BPC 10.0 SP13 Patch4 . NET3.5

BW 7.30 SP7

Issue Description:

The neutral copy package link was scheduled at a certain time during the month of July and failed on default logic though not all the times but quite often (no other jobs running in parallel as we know). And every time when the failed link was manually executed, it ran successfully. Therefore, we suspected the issue should have had something to do with the scheduling. For the next month of Aug. we therefore rescheduled the package at an another time, and it seemed to resolve the issue. However, the package link failed again twice with the same error message (shown only for one failure) according SLG1 as shown below: (Note: No run time errors found. The error message in SLG1 is not shown for each time the package failed.)

FILE:\ROOT\WEBFOLDERS\xxxxxxxxxx\ADMINAPP\Consolidation\DEFAULT.LGF

USER:xxxxxxxxx

APPSET:xxxxxxxxx

APPLICATION:Consolidation

RUN CALC_ACCOUNT

EXCEPTION OCCURRED WHEN RUNNING PROGRAMS:

An exception has occurr

CLASS:	CL_UJK_RUN_PROGRAMS
METHOD:	RUN_SP
EXCEPTION:	CX_UJK_EXECUTION_EXCEPTION
MESSAGE:

The good and mysterious thing is that the error seemed to stop appearing thereafter.

Any comments or advices?

Many thanks for you attention,

Ren

[former_member186338]

Hi Ren,

Can you provide some extra info? Contents of DEFAULT.LGF for example? Package details? Etc...

Vadim

[former_member202404]

Hi Vadim,

Sorry for my late reply. I was stuck with some quarter closing activities...

The following are the package log and the debugging result.

Package Log:

/CPMB/MODIFY completed in 0 seconds

/CPMB/DEFAULT_FORMULAS_LOGIC completed in 13 seconds

[Selection]

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

SELECTION = /XXXX/Consolidation/PRIVATEPUBLICATIONS/LMACKENZIE/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:CATEGORY|ACTUAL_PLAN|DIMENSION:ENTITY||DIMENSION:RPTCURRENCY||DIMENSION:TIME|2015.07

[Message]

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

RUN_LOGIC:Cannot perform read

model: Consolidation. Package status: ERROR

Debugging results:

Package status =>Error

<RESULT><PROMPT><![CDATA[]]></PROMPT><MESSAGE><![CDATA[Invalidate selection condition

model: Consolidation. Package status: ERROR]]></MESSAGE><STATUS_STEP><![CDATA[/CPMB/MODIFY completed in 0 seconds

/CPMB/DEFAULT_FORMULAS_LOGIC completed in 0 seconds]]></STATUS_STEP></RESULT>

Would it be possible if you write to me via my email address yuanen.ren@gmail.com? Then I will send you the default logic file. I do not feel comfortable to just post it here publicly.

Thank you and kind regards,

Ren

[former_member186338]

Hi Ren,

Sorry, but you have to post default.lgf here or use some not free BPC consultants . No other way!

Vadim

[former_member202404]

Vadim, you win. Here you go as below! Thank you.

//added afert added Memberset failed to resolve issue

*FOR %TIMELOOP%=%TIME_SET%

// This script contains the logic which is executed whenever data is entered and sen

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

//ENTITY = %ENTITY_SET%

CURRENCY = LC

//GROUPS = %GROUPS_SET%

TID_RA = %TIMELOOP%

OTHER = [ENTITY = %ENTITY_SET%]

CALC = ROLL_BEG_RE

*ENDRUN_PROGRAM

//added per SAP recomendation test showed issue still persits

*XDIM_MEMBERSET ENTITY=%ENTITY_SET%

*XDIM_MEMBERSET CATEGORY=%CATEGORY_SET%

*XDIM_MEMBERSET TIME=%TIMELOOP%

//MOVES DOLLAR OVERIDE ACCOUNTS FOR CALC AT BALANCESHEET RATES (TO BE USE IN CALCULATING CTA)

*WHEN ACCOUNT

*IS 121060,310200,310400,310600,310800,311010,311020,311030,311035,311040,311210,311215,311220,311230,311235,311240,311250,311255,311260,311270,311275

*WHEN RPTCURRENCY

*IS LC

*WHEN FLOW

*IS BALANCE

//*REC(EXPRESSION=%VALUE%,FLOW=F_47X,AUDITTRAIL=INPUT)

*REC(EXPRESSION=%VALUE%,FLOW=F_47X)

*ENDWHEN

*ENDWHEN

*ENDWHEN

//*COMMIT

//MOVES CYRE FOR CALC AT BALANCESHEET RATES (TO BE USE IN CALCULATING CTA)

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

//ENTITY = %ENTITY_SET%

CURRENCY = LC

//GROUPS = %GROUPS_SET%

TID_RA = %TIMELOOP%

OTHER = [ENTITY = %ENTITY_SET%]

CALC = NI_AT_BSRATE

*ENDRUN_PROGRAM

////////CLEAR AND Populate Backlog Stats//////

//*WHEN ACCOUNT

//*IS S_24002X,S_24003X,S_24003X

//*REC(EXPRESSION=0)

//*ENDWHEN

//*WHEN ACCOUNT.PARENTH1

//*IS 41020X

//*REC(EXPRESSION=%VALUE%,ACCOUNT=S_24002X)

//*IS 410400

//*REC(EXPRESSION=%VALUE%,ACCOUNT=S_24003X)

//*IS 410600

//*REC(EXPRESSION=%VALUE%,ACCOUNT=S_24003X)

//*ENDWHEN

//*COMMIT

//

//

//FX TRANSLATION

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

RPTCURRENCY = LC

//GROUP = S_NONE

TID_RA = %TIMELOOP%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = Global

*ENDRUN_PROGRAM

[former_member186338]

Incorrect script: *FOR without *NEXT... is it complete?

It's not a good idea to post script with commented code - just unreadable!

Vadim

Please provide full extra info:

Including DM package advanced script and the explanation of the initial script scope!