Dynamics AX 2012 Reporting: Error “Client found response content type of ”, but expected ‘text/xml'” when running a report based on cubes
You may run into this error running OLAP reports on a SQL Server 2016 Reporting Services instance on which the ENU\x86\SQL_AS_ADOMD.msi component from the Microsoft® SQL Server® 2012 SP1 Feature Pack was not installed.
SYMPTOMS:
When running the report in AX 2012 client you will see this error in the info log:
“Client found response content type of ”, but expected ‘text/xml’. The request failed with an empty response.”
When opening a Role Center in Enterprise Portal that contains an OLAP report (CEO /EPCEORoleCenter/ or CFO /EPChiefFinancialOfficerRoleCenter/, for example) you will see the following error:
“An unhandled error has occurred. To view details about this error, enable debugging in the web.config file or view the Windows event logs.”
If you enable debugging in the web.config more exception details will be included:
Error
Message: An unhandled error has occurred. To view details about this error, enable debugging in the web.config file or view the Windows event logs.
Source: System.Web.Service
Exception details:
Client found response content type of ”, but expected ‘text/xml’. The request failed with an empty response.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.Invoke(String methodName, Object[] parameters)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.SetExecutionParameters2(ParameterValue[] Parameters, String ParameterLanguage)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)”
Trying to open the shared data source that is used with OLAP reports, “DynamicsAXOLAP”, in Report Manager an error will be thrown, the Properties page will display all fields disabled and the Connection Type field empty while it should be “Microsoft Dynamics AX AdoMd”.
“An error occurred.”
SOLUTION:
Installing the missing component ENU\x64\SQL_AS_ADOMD.msi of the Microsoft® SQL Server® 2012 SP1 Feature Pack may resolve the issue.
https://www.microsoft.com/en-us/download/details.aspx?id=35580
