Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SOAP Envelope for Batch commands?

23 views
Skip to first unread message

zgr...@mac.com

unread,
Aug 6, 2009, 4:09:22 PM8/6/09
to
(sorry if this is a double post)

What is the appropriate SOAP Envelope wrapper for a Batch command?

I'm trying to reprocess a cube through the msmdpump.dll and I'm
getting messages along the lines of "The Batch element at line 1,
column 233 (namespace http://schemas.microsoft.com/analysisservices/2003/engine)
cannot appear under Envelope/Body."

Currently I'm using

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/
envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/
encoding/">
<SOAP-ENV:Body>${Body}</SOAP-ENV:Body></SOAP-ENV:Envelope>

where ${Body} is replaced with

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/
engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/
2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/
engine/2/2">
<Object>
<DatabaseID>${Catalog}</DatabaseID>
<CubeID>${Cube}</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</
WriteBackTableCreation>
</Process>
</Parallel>
</Batch>

All my data queries are working the problem must be with this message
itself. This would be the first type of message that didn't exist in
2000 so I'm guessing its expecting a different format but I can't find
what exactly its expecting on MSDN.

-zoltan

zgr...@mac.com

unread,
Aug 11, 2009, 1:23:53 PM8/11/09
to
OK, I found the info. The Batch command needs to be run like a MDX
except its not a Statement. So the envelope looks like:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/
envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/
encoding/">

<SOAP-ENV:Body><Execute xmlns="urn:schemas-microsoft-com:xml-
analysis"><Command>${Body}</Command><Properties><PropertyList></
PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-
ENV:Envelope>

Felix Santos

unread,
Oct 11, 2009, 8:41:26 AM10/11/09
to
do you have other links that we can look into?

<zgr...@mac.com> wrote in message
news:38e40ee5-7f4e-48d6...@o9g2000prg.googlegroups.com...

0 new messages