how to use subscribe command in sql server analysis services?

Ask a question

Friday, April 23, 2010 6:37 AM

0

Hi all,

I have a question regarding subscribe command in ssas 2008 need your help, when I send a request as below to server, server will be hanged, and no response for me.

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">

   <Header>

</Header>

   <Body>

     <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">

       <Command>

         <Subscribe xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

           <Object xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

            <TraceID>Events</TraceID>

          </Object>

        </Subscribe>

      </Command>

       <Properties>

         <PropertyList>

          <LocaleIdentifier>1033</LocaleIdentifier>

        </PropertyList>

      </Properties>

    </Execute>

</Body>

</Envelope>

Is there some issue in my request?? Can you help me ??? how to send a correct Subscribe command request???? what objects must be included???

Thanks

Rocky
- Reply
- Quote

All Replies

Friday, April 23, 2010 6:44 AM

0
Hi all,

I have a question regarding subscribe command in ssas 2008 need your help, when I send a request as below to server, server will be hanged, and no response for me.

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">

   <Header>

</Header>

   <Body>

     <Execute xmlns="urn:schemas-microsoft-com:xml-analysis">

       <Command>

         <Subscribe xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

           <Object xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

            <TraceID>Events</TraceID>

          </Object>

        </Subscribe>

      </Command>

       <Properties>

         <PropertyList>

          <LocaleIdentifier>1033</LocaleIdentifier>

        </PropertyList>

      </Properties>

    </Execute>

</Body>

</Envelope>

Is there some issue in my request?? Can you help me ??? how to send a correct Subscribe command request???? what objects must be included???

Thanks

Rocky
- Moved by Todd McDermidMVP Friday, April 23, 2010 1:52 PM SSAS question (From:SQL Server Integration Services)
- Merged by Raymond-LeeMicrosoft Employee, Moderator Monday, April 26, 2010 8:34 AM the same question
- Reply
- Quote
Friday, April 23, 2010 7:00 AM

0

Rocky,

for Better and fast response, please post this question here (SSAS).

Let us TRY this |

http://quest4gen.blogspot.com/
- Reply
- Quote
Monday, April 26, 2010 8:32 AM

Moderator

0
Hi Rocky,

You script seems fine, but you need to run a Cancel command. Note: The Subscribe command returns trace results only until the command is canceled by the Cancel command.

http://msdn.microsoft.com/en-us/library/ms187206.aspx

From the “Returning Results” section, you can find the following description:

http://msdn.microsoft.com/en-us/library/ms187206.aspx

The sample of Cancel command:

<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<SPID>249678</SPID>

<CancelAssociated>false</CancelAssociated>

</Cancel>

Hope this helps,

Raymond
- Marked As Answer by Darren GosbellMVP, Moderator Tuesday, April 27, 2010 9:33 PM
- Reply
- Quote
Monday, April 26, 2010 9:51 AM

0

Thanks Raymond for your support! I have resolved my problem as your comments. thanks again!
- Reply
- Quote