Munis SQL Locks

Ran job or report, it's taking forever to complete:

Lock request time out period exceeded.

• Enterprise ERP

• Munis ERP

• Database Administration

• SQL

A locked record in the DB preventing the process from completing.

Locks are held on SQL Server resources, such as rows read or modified during a transaction, to prevent concurrent use of resources by different transactions. For example, if an exclusive (X) lock is held on a row within a table by a transaction, no other transaction can modify that row until the lock is released.

To clear a lock, please contact Tyler Systems Management or log a case via the Online Support Client Portal. Support typically requires access to the SQL server to troubleshoot this issue. 

Please note, Tyler System Management can assist with clearing SQL locks, but they cannot assist with determining why SQL locks are occurring. Root causes of SQL locks are the responsibility of software support teams.