ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

XMLA does not work

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Message:

* HTML is ON
* Forum Code is OFF

Smilies

[quote][i]Originally posted by markmal[/i]
[br]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>

[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
markmal	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>
1 L A T E S T R E P L I E S (Newest First)
admin	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.

ReportPortal