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 sugg...
Need Help
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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Yes it has worked for me as well ini the past. If I execute a refresh I see the new session come up and that one I can cancel. But it just waits for the original session to finish (it's been hanging there for 2 days now) and it never does so our refresh times out after 5 hours. Data source is cloud based so no gateway being used. Thanks again for your insight/suggestions.