More in this section

Forums / General Discussions / Lock request time out period exceeded

Lock request time out period exceeded

5 posts, 0 answered
  1. Louis Farrell
    Louis Farrell avatar
    37 posts
    Registered:
    24 May 2010
    26 Jan 2011
    Link to this post
    Hey,

    I have been updating text values in multilingual_value_en in sf_control_properties just trying to do a mass replace of text over ~400rows and it updates it, but i receive the error:

    Message: Telerik.OpenAccess.RT.sql.SQLException: Lock request time out period exceeded. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.next() at OpenAccessRuntime.Relational.fetch.FetchResultImp.rsNext() at OpenAccessRuntime.Relational.fetch.FetchResultImp.hasNext()

    When trying to view any page after that. Is there anywhere to increase this lock timeout period?? Would that make a difference if i did? It must be a time issue, as when i tell it to update text on less rows it updates fine...thoughts?

    Many thanks,

    Louis
  2. Pavel Iliev
    Pavel Iliev avatar
    140 posts
    Registered:
    18 Jul 2016
    27 Jan 2011
    Link to this post
    Hello Louis,

    Can you give us some sample code or project to see how exactly you're doing it? If possible attach a backup of the database before the changes you made and a backup with the changes after that.

    Best wishes,
    Pavel
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Louis Farrell
    Louis Farrell avatar
    37 posts
    Registered:
    24 May 2010
    27 Jan 2011
    Link to this post
    Thanks for the response Pavel, however this does seem to have fixed itself; having changed no settings, this is now updating absolutely fine. I am unsure as to why it works now, but just pleased that it does!
  4. Charles
    Charles avatar
    61 posts
    Registered:
    18 Jul 2012
    09 Mar 2012
    Link to this post
    Ya, we get this occasionally too. Just got this trying to log into a website.
  5. Charles
    Charles avatar
    61 posts
    Registered:
    18 Jul 2012
    12 Mar 2012
    Link to this post
    Now getting this all over the website. Even just loading the homepage. I've submitted a ticket. Can this timeout be increased till we determine why websites are randomly failing with this message?
5 posts, 0 answered