Data Manager package Not working properly using destination app script logic

[Former Member]

Dear BPC Team,

We are moving the data form one model(EXP) to other model(MIS) using destination app script logic and some times it is getting succedded and some times not(check attachment). So, Please suggest us the reason for failure of data manager packages. Please find the script logic used for the same.

Error:-

ERROR : RUN_LOGIC:MDX statement error: Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV',

Logic Script :

*XDIM_MEMBERSET PROFIT_CENTER = BAS(%PROFIT_CENTER_SET%)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET MEASURES = YTD

*XDIM_MEMBERSET VALUATION = AMT

*DESTINATION_APP = MIS_CLNT1

*SKIP_DIM = DRIVER, EMPLOYEE, VALUATION, SCENARIO

*RENAME_DIM OP_ACCOUNT = GL_ACCOUNT

*ADD_DIM FLOW=F_999

*ADD_DIM INTERCO=I_NONE

*ADD_DIM SCOPE=NON_GROUP

*ADD_DIM ACCOUNT = OP_ACCOUNT:GRP_GL

*WHEN OP_ACCOUNT

*IS <> RENT_INC,RENT_EXP

*WHEN OP_ACCOUNT.ACCTYPE

*IS = EXP,INC

*WHEN CATEGORY

*IS %CATEGORY_SET%

*REC(EXPRESSION = 0,AUDITTRAIL=INP_EXP,CATEGORY=%CATEGORY_SET%)

*REC(EXPRESSION = (%VALUE%),AUDITTRAIL=INP_EXP,CATEGORY=%CATEGORY_SET%)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Regards,

Dumpa Reddy

[former_member186338]

Please remove not related secondary tag:

EPM Add-In for Excel

[former_member186338]

Sorry, but the user name "KPMG BPC" violates forum rules. I will not provide answers.

[former_member186338]

Have you read this note:

https://launchpad.support.sap.com/#/notes/638701

[former_member186338]

There is nothing wrong with your script.

Please check this note:

https://launchpad.support.sap.com/#/notes/2417959

[former_member186338]

P.S. Some lines/statements of this script are useless and can be removed:

*WHEN OP_ACCOUNT
*IS <> RENT_INC,RENT_EXP
*WHEN OP_ACCOUNT.ACCTYPE
*IS = EXP,INC 
*REC(EXPRESSION = %VALUE%,AUDITTRAIL=INP_EXP)
*ENDWHEN
*ENDWHEN

and remove useless COMMIT at the end!

[former_member543945]

Dear Vadim,

Thanks for your quick response. Issue still persists.

We have applied the note in the BW system and have restarted the server.But Still issue persists.

Can you please suggest

Regards,
DUmpa Reddy

[Former Member]

Error after applying SAP Note.

[former_member186338]

When you convert answer to comment my reply on this answer is lost!

From the deleted rely: Please read note:

https://launchpad.support.sap.com/#/notes/638701

Also, please remove unrelated question tag:

EPM Add-In for Excel