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
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.