+ Post New Thread
Results 1 to 4 of 4
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: ...
  1. #1

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21

    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?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    sucks!
    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.

  3. #3

    Join Date
    Apr 2007
    Location
    Croydon
    Posts
    500
    Thank Post
    18
    Thanked 31 Times in 30 Posts
    Rep Power
    21
    So true!

    I went for 1800 in the end as this was the example used on MSDN. It's enabled me to remove the order.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Goodoh

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] DBATTACH for FMS Why different? [Solved]
    By mark-p in forum MIS Systems
    Replies: 9
    Last Post: 6th January 2011, 07:05 PM
  2. [SIMS - FMS] GDI32.DLL error [Solved]
    By jamesloker in forum MIS Systems
    Replies: 36
    Last Post: 14th July 2010, 11:04 PM
  3. Replies: 4
    Last Post: 13th July 2010, 01:27 PM
  4. auto lock computer after set time
    By timbo343 in forum Windows
    Replies: 13
    Last Post: 30th March 2007, 07:54 AM
  5. Force Logoff After idle time period
    By nuttygeek in forum Windows
    Replies: 11
    Last Post: 22nd March 2006, 09:51 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •