OpenSync

Home Forums OpenSync Query Time outs due to Exclusive Wait Locks

This topic contains 0 replies, has 1 voice, and was last updated by  David Kite 1 year, 1 month ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #66687

    David Kite
    Participant

    I have been getting errors while running syncs, and I finally tracked down what is causing the error, but I am not sure why the wait locks are happening.

    Here is the SQL results for the query (show the active query list):
    SELECT sqltext.TEXT, req.session_id, req.status, req.start_time, req.command, req.cpu_time, req.total_elapsed_time, req.wait_type FROM sys.dm_exec_requests req
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

    TEXT session_id status start_time command cpu_time total_elapsed_time wait_type
    (@1 varchar(8000))DELETE [txnitemlinedetail] WHERE [IDKEY]=@1 86 suspended 2020-01-28 10:59:35.537 DELETE 0 59695 LCK_M_IX

    corresponding Opensync Log File
    2020-01-28 10:59:34 0 ModAccess Refresh Table: bill
    2020-01-28 11:00:36 -2147217871 ModAccess ERROR: Query timeout expired(UpdateEntryDB TxnID in table bill 674FC0-1580166824 674FC0-1580166824)
    2020-01-28 11:00:36 -2147217871 ModAccess ERROR: Query timeout expired TxnID(RefreshDatabase TxnID in table bill 674FC0-1580166824 674FC0-1580166824)
    2020-01-28 11:00:36 0 ModAccess ERROR: (GenMakeDBRecs: Query timeout expired TxnID err#:-2147217871 field:TxnID: in table bill 674FC0-1580166824 – )

    I am wondering if there are any suggestions as to why the wait lock is happening?

    Any help is very much appreciated.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.