我在用 XMLA 通过SOAP调用 HTTP://localhost/olap/msmdpump.dll endpoint时,报错。
错误内容为:
<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>XMLAnalysisError.0xc10f000b</faultcode>
<faultstring>第 1 行、第 336 列(命名空间 )处的 Command 元素在 Envelope/Body/Execute 下的顺序不对。</faultstring>
<detail>
<Error ErrorCode="3238985739" Description="第 1 行、第 336 列(命名空间 )处的 Command 元素在 Envelope/Body/Execute 下的顺序不对。" Source="Microsoft SQL Server 2005 Analysis Services" HelpFile=""/>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>从错误提示看是似乎是请求的XML不符合schema,但把请求XML放到MS SQLServer Management Studio中直接执行却可以正常调用,不知为什么?请求的XML字符串为:
<?xml version="1.0" encoding="UTF-8"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
soap-env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<soap-env:Header/>
<soap-env:Body>
<Execute xmlns="urn:schemas-microsoft-com:xml-analysis"
soap-env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<Command>
<Statement>select [Measures].members on Columns from RPTDW</Statement>
</Command>
<Properties>
<PropertyList>
<Catalog>SFAS</Catalog>
<AxisFormat>TupleFormat</AxisFormat>
<DataSourceInfo>Provider=MSOLAP.3;Data Source=local;</DataSourceInfo>
<Format>Multidimensional</Format>
</PropertyList>
</Properties>
</Execute>
</soap-env:Body>
</soap-env:Envelope>
有请高手高手高高手
错误内容为:
<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>XMLAnalysisError.0xc10f000b</faultcode>
<faultstring>第 1 行、第 336 列(命名空间 )处的 Command 元素在 Envelope/Body/Execute 下的顺序不对。</faultstring>
<detail>
<Error ErrorCode="3238985739" Description="第 1 行、第 336 列(命名空间 )处的 Command 元素在 Envelope/Body/Execute 下的顺序不对。" Source="Microsoft SQL Server 2005 Analysis Services" HelpFile=""/>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>从错误提示看是似乎是请求的XML不符合schema,但把请求XML放到MS SQLServer Management Studio中直接执行却可以正常调用,不知为什么?请求的XML字符串为:
<?xml version="1.0" encoding="UTF-8"?>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
soap-env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<soap-env:Header/>
<soap-env:Body>
<Execute xmlns="urn:schemas-microsoft-com:xml-analysis"
soap-env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<Command>
<Statement>select [Measures].members on Columns from RPTDW</Statement>
</Command>
<Properties>
<PropertyList>
<Catalog>SFAS</Catalog>
<AxisFormat>TupleFormat</AxisFormat>
<DataSourceInfo>Provider=MSOLAP.3;Data Source=local;</DataSourceInfo>
<Format>Multidimensional</Format>
</PropertyList>
</Properties>
</Execute>
</soap-env:Body>
</soap-env:Envelope>
有请高手高手高高手
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货