- #Lock request time out period exceeded upgrade#
- #Lock request time out period exceeded software#
- #Lock request time out period exceeded code#
Document control/access solution to prevent opening specific documents Best Practices & General IT.Other than work with your vendor, everything else this forum suggests is just a guess. It's very difficult to suggest anything without all of the info required.
#Lock request time out period exceeded upgrade#
Honestly, you need to either pony up the resources for an upgrade or have someone that knows SQL Server take a look.
#Lock request time out period exceeded software#
There are several ways to do this - query tuning, new indexes, maintaining indexes, updating statistics, purging data, hardware upgrades, software upgrades etc. You need to find a way to speed up that other process so it lets go of any locks as quickly as possible.
Your issue is a table that the session is trying to query is being blocked by another process. Your issue isnt when it tries to open the db. If you have a non-prod environment to test in, do it there first. The error occurs when we start the client and it tries to open the database.ĭoes this give any idea on the table / index info?įirst kick at the can, and keep in mind this is without knowing anything about your system - slap a covering index on that table if it doesnt already exist: CREATE INDEX idx_RecordLink ON (, The database is for Navision (a Microsoft Financial solution) - we do not create the queries or tables it is part of Navision. I'm not sure I can answer all your questions regarding execution plan and so. Proc varbinary(12))SELECT TOP 1 NULL FROM "Sodexo NAV 5 SP1"."dbo"."Record Link" WHERE AND AND (("Record
#Lock request time out period exceeded code#
If it isn't the code proper, then more than likely either a lack of database maintenance or some resource contention that's slowing a transaction down. It is a result of a transaction that is holding locks and not releasing them in a timely fashion. The number of users logged in isn't necessarily relevant. This error isn't a result of any limit (in SQL Server, anyway). Alternatively start up a SQL Profiler or XEvents session before your first user logs in and track lock timeouts. Use Performance Dashboard, it has a historical waits link that may be of help in tracking down the offending sessions. It may be you're not hitting it as it is happening. Unfortunately it is not as simple as logging one user out and then another can login. It looks more that it is some limit somewhere as the first users can login then we see this error. It might be that there is some bad code somewhere but we haven't changed any code for years and since some users can login and others can't it is not likely. We have tried to run that query on several attempts to login to Navision but the query does not report anything.