Error While running the Data Manager package in SAP BPC 10.0

[former_member623548]

We have recently upgraded to SP19. After the upgrade the Data Manager is getting failed with the below error.

The Data manager Script is as below:

PROMPT(SELECT,,,"Select Org Hierarchy member","%ENTITY_DIM%") INFO(%SUFFIX1%,DIMENSION:OBC_EVENT|LIVE_VERSION|) 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%%SUFFIX1%) TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,DM134_HF_CALC_FIN_OC.LGF)

The Script Logic is as below:

*SELECT(%FP%,"FIRST_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")

*SELECT(%LP%,"LAST_PLAN_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")

*SELECT(%LFP%,"LAST_FORECAST_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")

*SELECT(%TIME_SELECT%,"ID","TIME","[REP_Q_END] = 'X' AND [CALC] = 'N' AND [ID] >= %FP% AND [ID] <= %LP%")

*SELECT(%PLANTIME_SELECT%,"ID","TIME","[REP_Q_END] = 'X' AND [CALC] = 'N' AND [ID] > %LFP% AND [ID] <= %LP%")

*XDIM_MEMBERSET OBC_ORG_HIER = %OBC_ORG_HIER_SET%

*XDIM_MEMBERSET OBC_EVENT = %OBC_EVENT_SET%

*XDIM_MEMBERSET TIME = %TIME_SELECT%

*START_BADI ZCL_GFR_CUSTOM_LOGIC

QUERY = ON

WRITE = ON

FUNCTION = HF_CURRENCY_TRANS

*END_BADI

*COMMIT

*XDIM_MEMBERSET OBC_ORG_HIER = %OBC_ORG_HIER_SET%

*XDIM_MEMBERSET OBC_EVENT = %OBC_EVENT_SET%

*XDIM_MEMBERSET TIME = %TIME_SELECT%

*START_BADI ZCL_GFR_CUSTOM_LOGIC

QUERY = ON

WRITE = ON

FUNCTION = HF_CURRENCY_TRANS_PLAN

*END_BADI

*COMMIT

*XDIM_MEMBERSET OBC_ORG_HIER = %OBC_ORG_HIER_SET%

*XDIM_MEMBERSET OBC_EVENT = %OBC_EVENT_SET%

*XDIM_MEMBERSET TIME = %PLANTIME_SELECT%

*XDIM_MEMBERSET RPTCURRENCY = USD

*WHEN RPTCURRENCY

*IS USD

*REC(FACTOR = 1,RPTCURRENCY = USD_PLAN)

*ENDWHEN

*COMMIT

// 2. Calculated BS items & memo / sundry accounts

*INCLUDE DM41A_HF_CLC_BS.LGF

// 3. Opening balances

*INCLUDE DM40_HF_COPY_OPENBAL.LGF

// 4. Calculated CF items

*INCLUDE DM41_HF_CLC_CASHFLOW.LGF

Please help me resolve this.

Regards,

Happy

[former_member623548]

The Package gets success If I comment everything except the first line.

Here is the log:

/CPMB/MODIFY completed in 0 seconds
/CPMB/DEFAULT_FORMULAS_LOGIC completed in 0 seconds
/CPMB/CLEAR completed in 0 seconds
[Selection]
--------------------------------------------------------------
SELECTION = /OBC_PFMI/OBCPHF/PRIVATEPUBLICATIONS/RAHDAX/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:OBC_ORG_HIER|F3_00262_INP
SELECTION_KEYDATE = 
[Message]
--------------------------------------------------------------
model: OBCPHF. Package status: SUCCESS

[former_member186338]

Again! Included scripts are not posted! And the issue is with one of the included scripts!

[former_member623548]

Attached the log file.

I am getting the similar error for time dimension also. If I change the OBC_EVENT Value to Actuals.

I have tried refreshing the dimension from BW side and reprocessed the dimension from ADMIN part.

We have Debugged the Script logic, that is also working fine.

We are trying to understand what has changed after the upgrade.

Regards,

Happy

log.txt

[former_member186338]

Looking on your log file I can see that OBC_EVENT:LIVE_VERSION was successfully passed to script logic!

Result of the script line:

*XDIM_MEMBERSET OBC_EVENT = %OBC_EVENT_SET

In the log:

OBC_EVENT:LIVE_VERSION,1 in total.

The issue can be in the included scripts, but you didn't provided the includes code! Please provide.

[former_member186338]

P.S. Try to execute only first step of the script:

*SELECT(%FP%,"FIRST_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")
*SELECT(%LP%,"LAST_PLAN_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")
*SELECT(%LFP%,"LAST_FORECAST_PERIOD","OBC_EVENT","[ID] = 'LIVE_VERSION'")
*SELECT(%TIME_SELECT%,"ID","TIME","[REP_Q_END] = 'X' AND [CALC] = 'N' AND [ID] >= %FP% AND [ID] <= %LP%")
*SELECT(%PLANTIME_SELECT%,"ID","TIME","[REP_Q_END] = 'X' AND [CALC] = 'N' AND [ID] > %LFP% AND [ID] <= %LP%")
*XDIM_MEMBERSET OBC_ORG_HIER = %OBC_ORG_HIER_SET%
*XDIM_MEMBERSET OBC_EVENT = %OBC_EVENT_SET%
*XDIM_MEMBERSET TIME = %TIME_SELECT%
*START_BADI ZCL_GFR_CUSTOM_LOGIC
QUERY = ON
WRITE = ON
FUNCTION = HF_CURRENCY_TRANS
*END_BADI
//comment the rest

and post log!

[former_member623548]

Hi,

Attaching the Screenshot.

[former_member186338]

And latest log file?

[former_member623548]

Hi Vadim,

Thanks for your reply.

I have changed the DM Script ,but it didn't worked.

I am getting the same error.

Regards,

Happy

[former_member186338]

Screenshot of your advanced DM script, please!

[former_member186338]

Looking on your advanced DM script (by the way, please check line breacks after posting!!!!):

PROMPT(SELECT,,,"Select Org Hierarchy member","%ENTITY_DIM%") 
INFO(%SUFFIX1%,DIMENSION:OBC_EVENT|LIVE_VERSION|) 
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%%SUFFIX1%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,DM134_HF_CALC_FIN_OC.LGF)

%SELECTION% will be:

...|F0_00049_INP - without "|" at the end

Instead of:

INFO(%SUFFIX1%,DIMENSION:OBC_EVENT|LIVE_VERSION|)

You have to use:

INFO(%SUFFIX1%,|DIMENSION:OBC_EVENT|LIVE_VERSION|)

with "|" before "DIMENSION:..."