SAP BPC Error reading the data of InfoProvider /CPMB/XXXXX when running DMP

[former_member493004]

Hi,

I am facing this issue where on running the data Manager Package getting the below error:-

RUN_LOGIC:MDX statement error: Error reading the data of InfoProvider /CPMB/TMIM1FD$X

few days back i was not getting this error and same script is working in another system.

Product details:

BPC 10.1 Classic

I am not sure as what parameters to check in this case or what more details should I provide related to this.

Can anyone guide/help me.

Thanks,

Ambika

[former_member186338]

Please read:

https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Details required!

[former_member493004]

Hi Vadim,

Do you mean this error "Error in BW:deleteofbuffer entry0BW:BIA:BI0_0800000011 faile" that I am getting while running DMP is due to this upgrade issue.

but able to run other packages in other model under same environment.

any help on this error.

Regards,

Ambika

[former_member493004]

Sorry for late reply but this error kind of disappeared itself. could not get the reason as what caused this error.

and dont know how to close this question.

[former_member493004]

sorry Vadim,

I could not get SP details for BPC.

for BW :Release 751 and SP level 0002.

I followed the steps as per your link https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/ to check for SP for BPC but could not found any info related to CPMBPC on this.

from BPC Excel addin below is the version info:-

2.6.101.79403

Any help.

thanks,

Ambika

[former_member186338]

For BW 75x there is no separate BPC SP and this is clearly stated in my blog!

Not sure that sp02 is the most recent, try to upgrade!

[former_member493004]

Hi Vadim,

Do you mean this error "Error in BW:deleteofbuffer entry0BW:BIA:BI0_0800000011 faile" that I am getting while running DMP is due to this upgrade issue.

but able to run other packages in other model under same environment.

any help on this error.

Regards,

Ambika

[akos_beres]

Ambika,

Are you getting any short dumps (ST22) when the error occurs?

Akos

[former_member493004]

Hi,

Hello ,

Product version: BPCNW 10.1 Classic

In the model Planning, we have dimensions TIME,VERSION,ACCOUNT,COMPANY_CODE to name few.

Script to be launched by Data Manager package.

Calculation Logic:- The calculation for each account is different. the logic involves the division of few accounts and post to target accounts. I am able to build logic which is running successfully in another system but when running in development environment getting the error.

Error:- RUN_LOGIC:MDX statement error: Error in BW: delete of buffer entry0BW:BIA:BI0_0800000009 faile

Script code below:-

*XDIM_MEMBERSET VERSION = ACTUAL, %VERSION_SET%
*XDIM_MEMBERSET TIME = %TIME_SET%
*WHEN ACCOUNT
  *IS
AUS1065
*REC(EXPRESSION= [ACCOUNT].[AUS1063]/[ACCOUNT].[AUS1065],ACCOUNT = GP)
 *REC(EXPRESSION= [ACCOUNT].[AUS1061]/[ACCOUNT].[AUS1065],ACCOUNT = OP)
*REC(EXPRESSION= [ACCOUNT].[AUS1060]/[ACCOUNT].[AUS1065],ACCOUNT = margin )    

*WHEN
VERSION
*IS
%VERSION_SET%
*REC(EXPRESSION= ([ACCOUNT].[AUS1010],[VERSION].[ACTUAL],[TIME].[TMVL(0,%TIME_SET%)])/(([TIME].[TMVL(1,%TIME_SET%)]+[TIME].[TMVL(2,%TIME_SET%)]+[TIME].[TMVL(3,%TIME_SET%)])/3),ACCOUNT= CYI_Ratio_AMT,TIME = TMVL(0,%TIME_SET%),VERSION=ACTUAL)  
 *ENDWHEN

*WHEN
VERSION
 *IS
ACTUAL
*REC(EXPRESSION =([ACCOUNT].[AUS1010],[TIME].[TMVL(-12,%TIME_SET%)])/(([TIME].[TMVL(1,%TIME_SET%)]+[TIME].[TMVL(2,%TIME_SET%)]+[TIME].[TMVL(3,%TIME_SET%)])/3),ACCOUNT
= PYI_Ratio_AMT,TIME = TMVL(0,%TIME_SET%))

 *REC(EXPRESSION= ([ACCOUNT].[AUS109],[TIME].[TMVL(0,%TIME_SET%)])/(([TIME].[TMVL(0,%TIME_SET%)]+[TIME].[TMVL(-1,%TIME_SET%)]+[TIME].[TMVL(-2,%TIME_SET%)])/3),ACCOUNT= ARCY_Ratio,TIME = TMVL(0,%TIME_SET%))


*REC(EXPRESSION= ([ACCOUNT].[AUS109],[TIME].[TMVL(-12,%TIME_SET%)])/(([TIME].[TMVL(-11,%TIME_SET%)]+[TIME].[TMVL(-10,%TIME_SET%)]+[TIME].[TMVL(-9,%TIME_SET%)])/3),ACCOUNT=ARPY_Ratio ,TIME = TMVL(0,%TIME_SET%))
*ENDWHEN
*ENDWHEN
*COMMIT

Results in UJKT:-
LGX:
*XDIM_MEMBERSET VERSION = ACTUAL, %VERSION_SET%
*XDIM_MEMBERSET TIME =%TIME_SET%


*WHEN ACCOUNT
*IS AUS1065
*REC(EXPRESSION = [ACCOUNT].[AUS1063]/[ACCOUNT].[AUS1065],ACCOUNT= GP)
*REC(EXPRESSION = [ACCOUNT].[AUS1061]/[ACCOUNT].[AUS1065],ACCOUNT= OP)
*REC(EXPRESSION = [ACCOUNT].[AUS1060]/[ACCOUNT].[AUS1065],ACCOUNT= margin)

*WHEN VERSION

*IS %VERSION_SET%

*REC(EXPRESSION = ([ACCOUNT].[AUS1010],[VERSION].[ACTUAL],[TIME].[2019.05 ])/(([TIME].[ 2019.05 ]+[TIME].[ 2019.05 ]+[TIME].[ 2019.05 ])/3),ACCOUNT
= CYI_Ratio_AMT,TIME = 2019.05 ,VERSION=ACTUAL)

*ENDWHEN

*WHEN VERSION
*IS ACTUAL
*REC(EXPRESSION =([ACCOUNT].[AUS1010],[TIME].[2019.05 ])/(([TIME].[ 2019.05 ]+[TIME].[ 2019.05 ]+[TIME].[ 2019.05 ])/3),ACCOUNT
= PYI_Ratio_AMT,TIME = 2019.05 )
*REC(EXPRESSION = ([ACCOUNT].[AUS109],[TIME].[2019.05 ])/(([TIME].[ 2019.05 ]+[TIME].[ 2019.05 ]+[TIME].[ 2019.05 ])/3),ACCOUNT
= ARCY_Ratio,TIME = 2019.05 )
*REC(EXPRESSION = ([ACCOUNT].[AUS109],[TIME].[2019.05 ])/(([TIME].[ 2019.05 ]+[TIME].[ 2019.05 ]+[TIME].[ 2019.05 ])/3),ACCOUNT
= ARPY_Ratio ,TIME = 2019.05 )


*ENDWHEN 

*ENDWHEN


*COMMIT
------------------------------------------------------------------------------------------------------------------------------------


LOG:

FILE:\ROOT\WEBFOLDERS\XXXXXXX\ADMINAPP\YYYYY\TEST.LGF


USER:UUUUUUU


APPSET:XXXXXXX

APPLICATION:YYYYY

[INFO] GET_DIM_LIST():
I_APPL_ID="YYYYY", #dimensions=13
#dim_memberset=3 ENTITY:C0XXX,1 in total.


VERSION:ACTUAL,BUDGET_V1,2
in total.
TIME:2019.04,1 in
total.
REC :[ACCOUNT].[AUS1063]/[ACCOUNT].[AUS1065]
REC :[ACCOUNT].[AUS1061]/[ACCOUNT].[AUS1065]
REC :[ACCOUNT].[AUS1060]/[ACCOUNT].[AUS1065]

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 0.00 ms.2  RECORDS QUERIED OUT.


QUERY REFERENCE DATA

UJO_READ:MDX statement
error: Error in BW: delete of buffer entry0BW:BIA:BI0_0800000011 faile


 

Any help on this.

regards,

Ambika

[former_member186338]

Sorry, but looks like you don't want to read my blog!

"Product version: BPCNW 10.1 Classic"

BW version and SP?

BPC SP?