This is a migrated thread and some comments may be shown as answers.

Row not found in delete statement

1 Answer 112 Views
Data Access Free Edition
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Palani
Top achievements
Rank 1
Palani asked on 19 Mar 2014, 01:58 PM
Hi,
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.

1 Answer, 1 is accepted

Sort by
0
Viktor Zhivkov
Telerik team
answered on 19 Mar 2014, 04:38 PM
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.

Regards,
Viktor Zhivkov
Telerik
 
OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
 
Tags
Data Access Free Edition
Asked by
Palani
Top achievements
Rank 1
Answers by
Viktor Zhivkov
Telerik team
Share this question
or