EVDRE error - error retrieving data from webserver

[Former Member]

I have a EVDRE report that produces the 'Error retriving data from Webserver' message for a particular Account node.

This is a "1x2" evdre expansion with time dimension for column and Entity account for row expansion. When trying to expand one particular Account memeber to BAS (I.e. total_expense), the error would occur. Expand to BAS works well for parent or child member of this particular member (i.e. all account or Salary). I also tried to use LDEP(3, Total_Expense, Y) which is the base level, that works fine. Expand using DEP also works for this particular member. So far we have reprocessed the application many times. We also tried to update the account dimension by delete and then add back the member. Nothing worked.

On the EVDRE log, I can see that the evdre is brining back data, but it gives 'error parsing data' at some point, then the whole thing terminates.

Any idea why this happens?

[Former Member · Accepted solution]

I am wondering about veresion of BPC you are currently using now. There is a known issue regarding decompress dataset in client computer. If your version is above BPC 5.1 SP3, please take a look SAP note 1231889.

If you cannot take a look SAP note, just execute following query in your appset SQL database.

INSERT INTO [dbo].[tbldefaults] (Userid, Type, App, KeyID, Value) VALUES(N'_INTERNAL', N'SYSTEM', '', N'DO_COMPRESS','0')

Hope it would work.

[Former Member · Accepted solution]

It worked! Thank you very much for your help!

[daria_shirokova · Accepted solution]

Hello!

I have the same error on my CPM Demo virtual machine.

Appl set: Demo5b

Application: Legal

Business Process Flow: Monthly Submission

Step: Enter Data

Any report (PL01- Profit and Loss, BS01- Balance Sheet, u2026 absolutely all reports ) opens with error.

I've made "INSERT" in Demo5b database.

INSERT INTO dbo.tbldefaults (Userid, Type, App, KeyID, Value)

VALUES(N'_INTERNAL', N'SYSTEM', '', N'DO_COMPRESS',N'0')

But solution is not workingu2026

[james_lim · Accepted solution]

For your information,

Recently, Developers found the solution about this without using that option.

I think it will release soon so please keep watching Release note.

This is only for 5.1 version.

7 version doesn't have this issue

[former_member725491]

Hello,

I am in version 7 NW and I am having the same problem with account x entity EVDRE report. Could anybody suggest me any solution?.

Best Regards and thnaks in advanced,

F.R.L

[vinoo_gan]

Hi

I am facing same issue, "EVDRE encountered an error retrieving data from web server " did you get any solution.

can you please help.

GV

[vinoo_gan]

IN NW 7.0 we have same issue.

I have fixed this issue. In Time dimension current view we have given 2009.INP and expansion we gave before BASE this caused the error "ERROR Retrieving data from WebServer ".

Now I gave in the expansion for Time Dimension SELF,BAS it worked fine. please check with your Product account dimension.

Cheers

Vinoo

[Former Member]

BPC has terrible messages, this is generic I beleive.

I usualy only see this when the intersection of the defined members don't exist. for example if I try to query the bas level member of a child.

DEP AccountTotal = AccountSum1, AccountSum2

BAS AccountTotal = Account1, Account2, Account3

BAS AccountSum1 = Account1

BAS Account2 = ERROR

AccountTotal (Parent)

AccountSum1 (Dependant)

Account1 (Child)

AccountSum2 (Dependant)

Account2 (Child)

Account3 (Child)