User1589893805 postedHi
We have hosted an Analysis Services data pump on IIS and it is working as expected where we are using Excel as a client.
But the requirement is to log every MDX query when request drop in IIS where MSMD pump dll is hosted. For that I am using httpmodule and when we are trying to read request body using Request.InputStream we are getting issue but rest of the properties we are able to read like Request.ContentLength, Request.Headers, Request.HttpMethod.
Below error and soap XML is getting when trying to read request payload using Request.InputStream:
Error Message in Excel:
"XML parsing failed at line 1, column 9: DTD is prohibited"
It means 500 - Internal server error..
SOAP:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><Version xmlns="http://schemas.microsoft.com/analysisservices/2008/engine/100" Sequence="400"/></soap:Header><soap:Body><Discover xmlns="urn:schemas-microsoft-com:xml-analysis"><RequestType>DISCOVER_PROPERTIES</RequestType><Restrictions><RestrictionList><PropertyName>DbpropMsmdSubqueries</PropertyName></RestrictionList></Restrictions><Properties><PropertyList/></Properties></Discover></soap:Body></soap:Envelope>
Expected SOAP traced by Fiddler:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Header><Session xmlns="urn:schemas-microsoft-com:xml-analysis" SessionId="CEF4BD2E-EE83-4571-B5B5-B27EDABBC983"/></soap:Header><soap:Body><Execute xmlns="urn:schemas-microsoft-com:xml-analysis"><Command><Statement>MDX Query</Statement></Command><Properties><PropertyList><Catalog></Catalog><Timeout>0</Timeout><Format>Native</Format><DbpropMsmdFlattened2>false</DbpropMsmdFlattened2><SafetyOptions>2</SafetyOptions><Dialect>MDX</Dialect><MdxMissingMemberMode>Error</MdxMissingMemberMode><DbpropMsmdOptimizeResponse>1</DbpropMsmdOptimizeResponse><DbpropMsmdActivityID>65856B36-998E-44D5-91C6-F6F99BAE2381</DbpropMsmdActivityID><DbpropMsmdRequestID>1532A70C-1C1B-4C6C-8A96-1751BB5FB624</DbpropMsmdRequestID><LocaleIdentifier>1033</LocaleIdentifier><DbpropMsmdMDXCompatibility>1</DbpropMsmdMDXCompatibility><DbpropMsmdSubqueries>2</DbpropMsmdSubqueries></PropertyList></Properties></Execute></soap:Body></soap:Envelope>
Thanks