ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

Username:	Password:
Save Password
Forgot your Password?

All Forums

ReportPortal General Forum

Report Portal General Issues

XMLA does not work

New Topic

Reply to Topic

Printer Friendly

Author

Topic

markmal

Canada
5 Posts

Posted - 08/13/2004 : 08:55:35

Hi Igor,
I have installed all by the instructions several times. But OLAP part does not work. The authentication method for XMLA and MSXISAPI.DLL is Anonimous with using an account that is a member of Administrators.

What is wrong?

I dont have the VB to test XMLA, so I use just a telnet.
When I send to my IIS the following message

POST /xmla/msxisapi.dll HTTP/1.1
Host: http://labpe1500sc
Content-Type: text/xml
SOAPAction: Discover

<?xml version="1.0"?>
<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>DISCOVER_DATASOURCES</RequestType>
<Restrictions><RestrictionList></RestrictionList></Restrictions>
<Properties><PropertyList></PropertyList></Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

The response is

HTTP/1.1 500 Server Error
Server: Microsoft-IIS/5.0
Date: Fri, 13 Aug 2004 15:39:20 GMT
Connection: close
Content-Type: text/xml; charset="utf-8"

<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SO
AP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<SOAP-ENV:Fault xmlns:XA="urn:schemas-microsoft-com:xml-analysis">
<faultcode>XA:XMLAnalysisError.80040154</faultcode>
<faultstring>An error occurred while processing the request.</faultstring>
<faultactor>urn:schemas-microsoft-com:xml-analysis</faultactor>
<detail>
<Error ErrorCode="2147746132" Description="" Source="urn:schemas-microsoft-com:x
ml-analysis"/></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

admin

1647 Posts

Posted - 08/13/2004 : 21:32:16

XMLA SDK 1.1 requires MSXML 4.0. It can be downloaded here: [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en[/url]. Try using the SDK sample application ([url]http://www.reportportal.com/XmlaSampleApp.zip[/url]) to make sure that XMLA SDK is properly installed. You can also test the connection with this page [url]http://www.reportportal.com/MDX.htm[/url]. Please save this page to desktop before running it. Sometime it is necessary to restart the IIS service or the PC for the XML/A web service to work.

Topic

New Topic

Reply to Topic

Printer Friendly

ReportPortal