SYMPTOM:
The following time out message appears when running large reports that retrieve data from Microsoft Analysis Services:
(QueryEngine encountered error: XMLA Execute failed. SOAP Error. Error type: XMLA error. Time out while waiting for data from the XMLA Data Provider.. The embedded SOAP error is: . Connection String: HTTP://LOCALHOST/XMLA/MSXISAPI.DLL;.Error in Process method of Component: QueryEngineServer, Project msas, Job 2053, Error Code= -2147212544.)
CAUSE:
The error message displayed is a generic time out error message returned by the MicroSoft XML for Analysis component. The XML for Analysis toolkit in this case has timed out waiting for data from Analysis Services in response to the query sent.
ACTION:
This timeout setting is configurable. Edit the file datasources.xml file and set the named session and unnamed session time out values as appropriate.
NOTE: The default location of file datasources.xml is C:\Program Files\Microsoft XML For Analysis SDK\Config.
