Row not found in delete statement

Thread is closed for posting
2 posts, 0 answers
  1. Palani
    Palani avatar
    5 posts
    Member since:
    Jul 2012

    Posted 19 Mar 2014 Link to this post

    OpenAccess throws the following error while deleting records,

    Row not found: GenericOID@7897c458 TableName PrimaryKeyID=280996

    DELETE FROM [TableName] WHERE [PrimaryKeyID] = ?

    I am using Telerik OpenAccess for past 2 years, i am not faced this error before.
    Can you please advice what is causing this issue.
    I am not use threading while delete records, so this issue is not related to threading i think.
  2. Viktor Zhivkov
    Viktor Zhivkov avatar
    324 posts

    Posted 19 Mar 2014 Link to this post

    Hello Palani,

    The exception that you are experiencing usually is related to concurrency issues when one client modifies the data and commits a transaction that affects another client manipulating the same data. It can happen even if you have no multiple threads in your application, but just by starting the client application twice (or more).
    I would like to ask you if you can check whether the record that you are trying to delete is in the database before and after you have performed the delete operation. If you find the record in the database after the delete has thrown this exception please send us your code with more detailed description of the scenario so we can analyze it for any issues in our side.

    Viktor Zhivkov
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
Back to Top