MIS Systems Thread, FMS Lock request time out period exceeded [Solved] in Technical; We've got one particular order record on FMS that we are unable to delete and keep getting the following error:
17th May 2011, 11:42 AM #1
- Rep Power
FMS Lock request time out period exceeded [Solved]
We've got one particular order record on FMS that we are unable to delete and keep getting the following error:
[Microsoft][SQL Native Client][SQL Server]Lock request time out period exceeded [Microsoft][SQL Native Client][SQL Server]The statement has been terminated
I logged a call with Capita, only for them to come back with, it's a Microsoft problem, not caused by FMS and here is a link to an article How to Minimize SQL Server Blocking
I'm now waiting for them to confirm that it is ok to apply this setting to the CCSFMS db as I don't want to be held accountable if something else breaks.
Assuming they do, does anybody have any suggestions on a suitable time out period?
17th May 2011, 02:32 PM #2
you should fire back with this quote :
In many ways, the best way to avoid blocking is to write well-tuned applications that follow the tuning advice found on this website.
In the meantime, start with a shortish time, depending on how long it takes for the error to return. I'd have thought 10,000 ms isn't too bad.
17th May 2011, 02:36 PM #3
- Rep Power
I went for 1800 in the end as this was the example used on MSDN. It's enabled me to remove the order.
17th May 2011, 02:56 PM #4
By mark-p in forum MIS Systems
Last Post: 6th January 2011, 08:05 PM
By jamesloker in forum MIS Systems
Last Post: 15th July 2010, 12:04 AM
By Disease in forum MIS Systems
Last Post: 13th July 2010, 02:27 PM
By timbo343 in forum Windows
Last Post: 30th March 2007, 08:54 AM
By nuttygeek in forum Windows
Last Post: 22nd March 2006, 10:51 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)