Retrievedata function not working in test environment

[Former Member]

Hi All,

We have a report with quite a few retrievedata lines, around 700.

This report seems to produce results in Dev environment but has #VALUE! all over in Test environment.

If I select a few cells and refresh selected cells only then it produces data in Test environment. But doesnt work if I try to refresh the entire report.

I have seen the error System.OutOfMemoryException popping up on couple of occasions.

Any suggestions to get this working in Test environment.

Thanks,

Pratap

[Former Member]

Error log from the EPM Log option:

2016-06-03 15:02:43,294|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request|USERID|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2016-06-03 15:02:43,294|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteCellQuery|USERID|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2016-06-03

15:02:43,294|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.RetrieveData|USERID|||||1|The remote server returned an unexpected response: (400) Bad Request.#

2016-06-03 15:02:43,294|ERROR|FormattingSheet|FPMXLClient.Office.EPMExcelSheet.RefreshData|USERID|||||1|Error in RefreshEVFunctions - Data partThe remote server returned an unexpected response: (400) Bad Request.#

[Former Member]

Hi Pratap,

BPC version, SP level and EPM add in version please.

Andy

[Former Member]

BPC 10.0 SP12

EPM 10 SP18 patch 2 .NET 4

[Former Member]

Hi Pratap,

Upgrade your BPC backend to the latest.

I remembered one of the SP between SP13 to SP16 fixed the EPM retrieve issue.

Your EPM add in is out of date too. install the latest.

Andy

[former_member186338]

BPC 10.0 SP12 - meaningless without BW version...

But anyway, upgrade is required.

[Former Member]

SAP_BW 740 SP12

CPMBPC 801 SP 12

All the environments are on same level so how would this report work in Dev & prod but not in Test.

[former_member186338]

First test with new EPM SP!

[Former Member]

Hi Pratap,

are all master data in sync from Prod to Dev?

Andy