sqlkendo-uissasxmlapivot-grid

SSAS webservice msmdpump.dll return error on 'OPTIONS'


I am having trouble getting a response from SSAS web service "http://localhost/OLAP/msmdpump.dll" in kendo pivot grid. The thrown error is

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body><soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>XMLAnalysisError.0xc10e0002</faultcode><faultstring>Parser: The 
syntax for 'OPTIONS' is incorrect.</faultstring><detail>
<Error ErrorCode="3238920194" Description="Parser: The syntax for 'OPTIONS' is incorrect." Source="Unknown" HelpFile=""/></detail></soap:Fault>
 </soap:Body>
 </soap:Envelope>

I checked cros multiple time and service address successfully work with excel.


Solution

  • Finally, I found my solution. A handler for options header should add to webservice setting. It's easier to do it in your web.config. It's not not mandatory for all controls but atlease kendo ui pivot grid and devexpress pivotgrid need this configuration to work.