• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 1542 views
  • Users 0 members are here
Options
Related

lock mail missing information

egaultier
over 3 years ago

Hello

Since the update in version 13.5, the information of the blocking session in the alert email is no longer present.



Have you the same error ?

Thank you for your help.

Emmanuel
Parents
  • 0 over 2 years ago

    Hi Emmanuel,

    Thank you so much for your question and we did have some tickets regarding this issue but in version 13.5.1.

    In this case, I would like to confirm if you are able to see the information using the following statement:

    SELECTdec.session_id,dec.properties,dec.creation_time,dec.is_open, sqltext.text
    FROM sys.dm_exec_cursors(@sessoinid)dec
    CROSSAPPLY sys.dm_exec_sql_text(dec.sql_handle) sqltext

     

    If you are able to see the blocking session information, but cannot see in Spotlight, please open a ticket with the Spotlight technical support team for further investigation.

    https://support.quest.com/create-service-request

    Thank you,

    Edgar

Reply
  • 0 over 2 years ago

    Hi Emmanuel,

    Thank you so much for your question and we did have some tickets regarding this issue but in version 13.5.1.

    In this case, I would like to confirm if you are able to see the information using the following statement:

    SELECTdec.session_id,dec.properties,dec.creation_time,dec.is_open, sqltext.text
    FROM sys.dm_exec_cursors(@sessoinid)dec
    CROSSAPPLY sys.dm_exec_sql_text(dec.sql_handle) sqltext

     

    If you are able to see the blocking session information, but cannot see in Spotlight, please open a ticket with the Spotlight technical support team for further investigation.

    https://support.quest.com/create-service-request

    Thank you,

    Edgar

Children
No Data