XMLAnalysisError.88BA0500

XMLAnalysisError.88BA0500

Post by Akshai Mir » Sun, 14 Sep 2003 07:19:13


Hi Nabani,

The problem here is that you have hard-coded the value of DataSourceInfo
while the XMLA spec requires that you do DISCOVER_DATASOURCES first and use
the value returned in that response for your future requests. There has ben
a change between v1.0 and v1.1 to return a different value for the
DataSourceInfo property. Therefore, the DataSourceInfo that you are sending
is probably incorrect for v1.1.

HTH,
Akshai


are
 
 
 

XMLAnalysisError.88BA0500

Post by Nabani Sil » Sun, 14 Sep 2003 09:41:02

Hi, Im getting a SOAP Response with this error: XMLAnalysisError.88BA0500,
Unable to process the request, because the DataSourceInfo property was
missing or not correctly specified.

Im trying a soap request using JavaScript, here is my code:

<script language="JavaScript">
function execute()
{
var soapCode = "<SOAP-ENV:Envelope ";
soapCode = soapCode +
"xmlns:SOAP-ENV=\" http://www.yqcomputer.com/ \" ";
soapCode = soapCode +
"xmlns:xsi=\" http://www.yqcomputer.com/ \" ";
soapCode = soapCode + "xmlns:xsd=\" http://www.yqcomputer.com/ \">";
soapCode = soapCode + "<SOAP-ENV:Body>";
soapCode = soapCode + "<Discover
xmlns=\"urn:schemas-microsoft-com:xml-analysis\" ";
soapCode = soapCode +
"SOAP-ENV:encodingStyle=\" http://www.yqcomputer.com/ \">";
soapCode = soapCode + "<RequestType>DISCOVER_DATASOURCES</RequestType>";
soapCode = soapCode + "<Restrictions>";
soapCode = soapCode + "<RestrictionList>";
soapCode = soapCode + "<CATALOG_NAME>FoodMart 2000</CATALOG_NAME>";
soapCode = soapCode + "</RestrictionList>";
soapCode = soapCode + "</Restrictions>";
soapCode = soapCode + "<Properties>";
soapCode = soapCode + "<PropertyList>";
soapCode = soapCode + "<DataSourceInfo>Provider=MSOLAP;Data
Source=EXTERMINADOR</DataSourceInfo>";
soapCode = soapCode + "<Catalog>Foodmart 2000</Catalog>";
soapCode = soapCode + "<Format>Tabular</Format>";
soapCode = soapCode + "</PropertyList>";
soapCode = soapCode + "</Properties>";
soapCode = soapCode + "</Discover>";
soapCode = soapCode + "</SOAP-ENV:Body>";
soapCode = soapCode + "</SOAP-ENV:Envelope>";

var oHttp = new ActiveXObject("Microsoft.XMLHTTP");
oHttp.open("POST", "http://localhost/xmla/msxisapi.dll", false);
oHttp.setRequestHeader("SOAPAction", '"'+
"urn:schemas-microsoft-com:xml-analysis:Discover" + '"');
oHttp.setRequestHeader("Content-Type", "text/xml");
oHttp.send(soapCode);

return oHttp.responseText;
}
</script>



I don't know whats happening... Ive tryied XMLA Browser
(www.xmlabrowser.com) and it works fine, I think that its because there are
using a webservice to get datasources... I don't know... Any help????

Thanks a lot
Nabani

 
 
 

XMLAnalysisError.88BA0500

Post by prjfinalxm » Sun, 16 Nov 2003 23:32:43

ello All,

I'm using XMLA1.1 SDK and I'm trying make a connection using Axis Java
client. I've installed the Microsoft XML for Analysis provider in
http://localhost:8088/xmlaservice/msxisapi.dll and I'm being able to
get the DISCOVER_DATASOURCES and DISCOVER_PROPERTIES to work. But for
the other discover RequestType values as DISCOVER_ENUMERATOR,
DISCOVER_KEYWORDS, DISCOVER_LITERALS, DISCOVER_SCHEMA_ROWSETS and
DBSCHEMA_CATALOGS I was not able to put them to work.
Below is an example of the SOAP request sent over the wire:

POST /xmlaservice/msxisapi.dll HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related,
text/*
User-Agent: Axis/1.1
Host: localhost
Cache-Control: no-cache
Pragma: no-cache

SOAPAction: "urn:schemas-microsoft-com:xml-analysis:Discover"
Content-Length: 1053

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<ns1:Discover soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:ns1="urn:schemas-microsoft-com:xml-analysis">
<RequestType xsi:type="xsd:string">DBSCHEMA_CATALOGS</RequestType>
<Restrictions href="#id0"/>
<Properties href="#id1"/>
</ns1:Discover>
<multiRef id="id0" soapenc:root="0"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xsi:type="ns2:clsXMLAProx.Discover.Restrictions"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:ns2="http://XMLAprojeto/20031108"/>
<multiRef id="id1" soapenc:root="0"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xsi:type="ns3:clsXMLAProx.Discover.Properties"
xmlns:ns3="http://XMLAprojeto/20031108"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"/>
</soapenv:Body>
</soapenv:Envelope>
--------------------------------------------------------------------

And the response that I got:

HTTP/1.1 500 Server Error
Server: Microsoft-IIS/5.0
Date: Sat, 15 Nov 2003 13:23:55 GMT
Content-Type: text/xml; charset="utf-8"

<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>XMLAnalysisError.88BA0500</faultcode>
<faultstring>Unable to process the request, because the DataSourceInfo
property was missing or not correctly specified.</faultstring>
<faultactor>XML for Analysis Provider</faultactor>
<detail>
<Error ErrorCode="2293892352" Description="Unable to process the
request, because the DataSourceInfo property was missing or not
correctly specified." Source="XML for Analysis
Provider"/></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
--------------------------------------------------------------------

As the error was related to the datasource info I have changed the
DataSourceInfo tag in the datasources.xml from Provider=MSOLAP.2;Data
Source=local to Local Analysis Server. In both cases it did not work.

I have used the 'XML for Analysis SDK: WSDL Files -
msxmla.workswithsoapsdk.WSDL: WSDL file for development using the SOAP
toolkit.' from Microsoft s
 
 
 

XMLAnalysisError.88BA0500

Post by Akshai Mir » Thu, 20 Nov 2003 03:09:55

i,

The XMLA SDK doesn't support the "href" style properties and restrictions...
You should make sure these get serialized inline.

HTH,
Akshai
"Luciano_Sandro" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
location='http://localhost:8088/xmlaservice/msxisapi.dll'


 
 
 

XMLAnalysisError.88BA0500

Post by Luciano_Sa » Fri, 21 Nov 2003 03:58:52

hanks Akshai!

So, if the client wants send to server an empty
restriction list and properties list the tags should be...

***********
soap-Client
***********
...
<Restrictions/>
<Properties/>
...

right?

Luciano / Sandro

and restrictions...
confers no rights
alias is for newsgroup
message
using Axis Java
provider in
being able to
work. But for
DISCOVER_ENUMERATOR,
DISCOVER_SCHEMA_ROWSETS and
wire:
multipart/related,
analysis:Discover"
oding/"
xsi:type="xsd:string">DBSCHEMA_CATALOGS</RequestType>
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/enco
ding/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/enco
ding/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"/>
------------
ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding
/">
DataSourceInfo
specified.</faultstring>
process the
missing or not
ENV:Body></SOAP-ENV:Envelope>
------------
changed the
Provider=MSOLAP.2;Data
did not work.
using the SOAP
WSDL2Java tool (that is
only thing I
is the tag
properly?
 
 
 

XMLAnalysisError.88BA0500

Post by Akshai Mir » Fri, 21 Nov 2003 04:12:33

es, or:

<Restrictions>
<RestrictionList/>
</Restrictions>

<Properties>
<PropertyList/>
</Properties>

The above is sometimes easier to program with.

Thanks,
Akshai
"Luciano_Sandro" < XXXX@XXXXX.COM > wrote in message
news:032701c3aecf$2c79a9e0$ XXXX@XXXXX.COM ...