Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PPU Dataset - Unable to cancel user session

Hello,

I am encountering an issue with a PPU dataset where the dataset is locked for modifications/processing. I have attempted to cancel the session but it appears to not work. Anyone have any suggestions on what to try?

 

 

Cancel command run:

<Cancel xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">  
   <SessionID>9BC583E5-A426-48EF-BE3E-BB31C8DFAC56</SessionID>  
</Cancel>

 

Thank you in advance.

Need Help

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous 

     

    What you will need to do is to first find the SPID with the following MDX Query

    SELECT

session_spid

, session_user_name

, session_last_command

, session_current_database

, session_cpu_time_ms

, session_elapsed_time_ms

, session_start_time

, session_last_command_start_time

, session_last_command_end_time

FROM $system.discover_sessions

WHERE session_status = 1



ORDER BY session_start_time desc

    And then kill it using the above SPID with this XMLA Query

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

<SPID>5622</SPID>

</Cancel>

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for the suggestion GilbertQ . I have tried the cancel command in many iterations (using SessionID, SPID, adding CancelAssociated true/false) and it does not kill the session. Just got of a call with Microsoft support and they seemed stumped. They are looking into with their various teams.

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        4 years ago

        It has certainly worked for me in the past.

         

        Also if you are using a Gateway just restart the Gateway service, that will kill the session if there is any data still going through