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]

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

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!