PPU Dataset - Unable to cancel user session

[Anonymous]

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.

[GilbertQ]

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]

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]

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]

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.