1829067 - EvDRE encountered an error retrieving data from the WebServer when trying to refresh certain reports

When trying to refresh certain reports in SAP Business Planning and Consolidation (BPC), the following message is displayed:

"EvDRE encountered an error retrieving  data from the WebServer"

The issue occurs only when refreshing certain reports.

The following error is recorded in the tblLogs table:

Error: System.InvalidCastException: Conversion from string "" to type 'Integer' is not valid. ---> System.FormatException: Input str
ing was not in a correct format.    at Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo
  NumberFormat) at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)    --- End of inner exception stack
trace --- at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value)    at DataService.OSoft.Services.Webservi
ce.SharedQueryEngine.cls DataQuery.SetMemberWithHierarchyByAxisQuery(String& strDim, Int32 indexofDimension, ArrayList& dMembers, _A
XIS_TYPE axisType, String sCalc, Int32 iWithMemberNo)    at DataService.OSoft.Services.Webservice.SharedQueryEngine.cls DataQuery.do
AxisQuery(String& sParam, String& sRet)

After restarting the IIS service the issue is resolved.

• SAP Business Planning and Consolidation 7.5 SP6 for Microsoft

evdre,report,crash,stopped responding,not responding,unresponsive,excel,client,error,error retrieving data,conversion,integer,string,not valid,type, change dimension, add member , KBA , EPM-BPC-MS-CON , Connection , Problem