EVDRE error AFTER expanding on a newly added member, sometimes....

[brian_hsu]

Dear all:

SITUATION

Sometimes when we want to add additional dimension member(s), we would get EVDRE error out (EVDRE has encountered a problem...) on expanding on that new member, with or without data and no suppression.

After the new member(s) are added, we can clearly see them in Current View. Also, we have no problem using the same template to report on old members.

DATA

BPC 7.5 MS

Multi Server Environment

Accessing via Citrix Client

This problem is intermittent, and the work-around is to rename the members and re-process. Sometimes it works and others it doesn't.

QUESTION

Has anyone ever experienced this?

Thanks for sharing!

Sincerely,

Brian

[JohnL · Accepted solution]

Hi Brian,

When you get that evDRE count down error, do any errors appear in the TBLLOGS table of the AppServer database?

Use this query in SQL Server Management Studio:

SELECT * FROM [AppServer].[dbo].[tblLogs]

Let us know what you find.

Thanks,

John

[brian_hsu · Accepted solution]

John:

We looked into the log table but couldn't find anythign relevant.

An interesting thing is, this EVDRE problem goes away after the member was added in about 24 hours later. There seems to be some latency between the members being added to where the system takes it.

Any thought on that?

Thank you for your help!

Brian

[brian_hsu]

Update to SQL2008 SP1 CU2 resolved this bizzare behavior.

[Former Member]

Hi Brian,

I have a similar issue and was trying to download the hotfix from Windows centre. It give me 4 options as below. Can you please tell me which one we should run. Also as per the mail from MS these hotfixes are not fully tested.

2008R2_SP1_MDS_CU2_2567714_10_50_2772_x64

2008R2_SP1_SNAC_CU2_2567714_10_50_2772_x64

SQLServer2008R2_SP1_CU2_2567714_10_50_2772_x64

2008R2_SP1_RSShrPnt_CU2_2567714_10_50_2772_x64

Did you apply all of the 4?

Thanks for your response.

Regards,

Baskhar

[brian_hsu]

Baskhar:

Sorry but I am not sure exactly how many patch files got applied. I was only told by my technical team that the mentioned Update was patched up.

[Former Member]

Hi Brian,

We found that we were on SQL Server 2008 RTM. Then we installed SP1 that contained CU1-CU6. The on top of SP1 we installed CU1-CU3 (for SP1). After that we were able to add members without any EVDRE retreival error.

Thanks for sharing your solution.

Below i give links on SQL Server versions that was helpful.

http://support.microsoft.com/kb/321185

http://support.microsoft.com/kb/2527041

http://support.microsoft.com/kb/981356

http://support.microsoft.com/kb/2567616

One can use the below query to find the Build of SQL Server currently installed.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Regards,

Baskhar

[Former Member]

Hi Brian,

In that case, please use "Refresh Dimension Members" option from eTools to re-import the updated dimension cache.

Karthik AJ

[brian_hsu]

Karthik:

We have learned that such bizzare EVDRE error came from a outdated/unpatched SQL2008. We were on SQL2008 R2, and the SP1 CU2 fixed it.

Thank you for your input.

Brian