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, 10: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?
IDG Tech News
17th May 2011, 01: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, 01: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, 01:56 PM #4
By mark-p in forum MIS Systems
Last Post: 6th January 2011, 07:05 PM
By jamesloker in forum MIS Systems
Last Post: 14th July 2010, 11:04 PM
By Disease in forum MIS Systems
Last Post: 13th July 2010, 01:27 PM
By timbo343 in forum Windows
Last Post: 30th March 2007, 07:54 AM
By nuttygeek in forum Windows
Last Post: 22nd March 2006, 09:51 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)