2 Replies Latest reply on Sep 23, 2013 3:29 PM by andy.yu

    Lock resources error message

    andy.yu

      Hello,

       

      I've been trying to search an answer through the forums and Google, but didn't really find anything similar to my issue.

       

      So my situation is that we schedule refreshes on our workbooks, and occasionally get the error below:

       

      "com.tableausoftware.vizql.dll.DataSourceException: Database error 0x80004005: Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction"

       

      In this particular situation, the workbook is based on an extract, so we are basically refreshing the extract file for it. I am not sure if the error is more related to Tableau itself or to the database?

       

      If it's related to the database, the query behind the extract is just selecting values, so I am a little confused on why there would be a lock on a SELECT statement.

       

      Any insight or advice would be greatly appreciated.

       

      Thanks so much everyone!