cancel
Showing results for 
Search instead for 
Did you mean: 

EVDRE encountered an error retriving data from web server in PROD

Former Member
0 Kudos

Hi friends,

We are checking Evdre reports in BPC production system. We checked few application' EVdre input templates & reports and are fine.

But yesterday evening onwards we are facing below error message.

EVDRE encountered an error retriving data from web server. This message we are getting for all BPC applications in BPC production. There is no short dump in backend.

But when i checked in BPC developement there is no probelm.

We are on BPC7.5 NWsp04 and BI7.01.

In BPC, production,when i try to create evdre template(just after filling

information in evdre builder), immediately getting same error information.

I read few notes, did as per that but sill problem exists. In note, mentioned process dim of particular application and process application. Logout from bpc admin & excel. I did this and, that error message not received for upto 20min. After that i'm getting error. We checked communciation between ABAP layer and bpc, reset IIS also. Still same probelm exists.

Any suggestions pls.

thanks,

naresh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check your version of BPC client.

We have faced this issue working with xlt reports in SAP BPC Client 7.5 SP06

We resolved this point installing BPC client SP07

BPCCLIENT07_0-10009079

i hope it helps

Regards

Nicolas

sunny_reddy
Explorer
0 Kudos

Dear Friends..!

Good Morning for all..!

I would like know in SAP BPC Side

1) What is Goal seek functions?

2) why we need in SAP BPC Side?

3) what kind of advantage with SAP BPC System?

4) Goal seek function is good to work in SAP BPC MS version?

5) if any one using Pl let it know how they are enabling SAP BPC System?

Thanks Advance..!

Regards

Sasi

Answers (1)

Answers (1)

Former Member
0 Kudos

HI Naresh,

I would request you to check the hierarchies of the dimensions in the excel client (action pane/CV).

Below can be few reasons.

i assume someone would have modifed any of the dimensions improperly and did not process them.

Check the major dimensions if you are able to see the hierarchies correctly in excel client ,if not refresh the dimensions.

Also you can check with your basis guy to run the db statistics which allows the reports to work efficiently and faster.

Please let me once you make the changes and if still facing the same error. Thanks.

Regards,

Sanjeev

Former Member
0 Kudos

Thanks Sanjeev for your reply.

We processed all dims of all applications and, as well processed all apps once. Still same error getting.

Even BPC appl, has no records still getting evdre error.

we tested the MDX RFC connection which is working fine at the backend system.

I will ask basis guy to run db statistics.

regads, naresh

Former Member
0 Kudos

Hi Naresh,

Can you check the backend application model ? The infoprovider realtime model should be set to "Real-Time Data Target Can Be Planned;Data Loading Not Allowed". Hopefully this helps.

Best Regards,

Richard

Former Member
0 Kudos

Richard,

All underlying infoproviders of BPC applicaitons, have in same mode what you mentioned.

Still problm exists.

naresh

Former Member
0 Kudos

Naresh,

Did you check with your basis guy ask to restart the .net server during offline hours or ask him to run the db stastics which should help you resolve this. Thanks.

Rgds,

Sanjeev

Former Member
0 Kudos

Try the below steps.

1. Login into BPC for Admin

2. Once logged into your Appset , open the Dimension library

3. Process each dimension by selecting the "Process members from membersheet" and by unchecking the "Take system offline" option

4. Process all the dimensions one by one not together.

5. Once processing the dimensions is done then open the Applications and Modify each Application by adding or changing the Application Description.

6. Once done modifying Applications then logout of the BPC Admin and BPC Excel.

7. Login back again into BPC for Excel by going through the connection wizard.

This should definitely solve the problem. .Thanks.

Regards,

Sanjeev

Former Member
0 Kudos

Hi Naresh,

Have you made any changes to your BPC system recently. Try to recall and assess if those changes had any impact.

We had a similar error on evdre reports. Like everyone mentioned process all the dimensions.....the reason for this if the dimension members have any special characters in their names.

- Check security profiles. If you have specifically denied access to any members for which you are trying to retrieve the data.

We have resolved the issue by implementing a note suggested by SAP support. You might consider creating a message with SAP.

Thanks

Former Member
0 Kudos

Hi Srinu,

We also facing the same problem, can you please give me the Sap Note number to overcome from this issue.

Thanks & Regards

Swathi Roy

Former Member
0 Kudos

Hi Swathi,

What we have encountered may be different from your scenario. Whenever there is an error, we received a short dump in st22 backend. This actually caused as we have enabled a calc hierarchy to improve the performance. The note suggested to us was 1509493.

I am not recommending this directly. Please review your scenario thouroughly before using this note. Sometimes you also get evdre error if you have in the security specifically denied access to a member.

Also, process all your dimensions and other advice given by others in this thread

Thanks.

Former Member
0 Kudos

Hi frineds,

SAP OSS team resolved along with our basis guy.

Initially SAP supported notes:

1.1475233 and 1378705 Process all dimensions and applications.

2.1355954 Drop SAP temp tables.

3.1428764 confilict only if you use Oracle 10 g, if you don't, then forget it.

I used 1378705 and problem resolved temporarly, but still exists after 1 day.

There are different reasons for getting the error message. In our case, problem is at backend BW and, BW system running on HP unix OS.

Checked librfc32.dll in the

directory /usr/sap/BP1/DVEBMGS00/exe.

Executed the following MDX statment in MDXTEST transcaction, and it

executed in both the available instances.

SELECT

{[Measures].MEMBERS} ON COLUMNS,

[0MATERIAL].[LEVEL00].MEMBERS ON ROWS

FROM [$ZCO_CDPC].

Even i also don't have clue how SAP resolved this issue.

Regards,

Naresh

rishi_jain5
Explorer
0 Kudos

Hi Swathi,

Could you please provide the SAP Note No. ? or the details about how to resolve this issue.