ErrorMessage using MariaDB with OpenAccess

2 posts, 0 answers
  1. seeware
    seeware avatar
    1 posts
    Member since:
    Jul 2008

    Posted 14 Jun 2015 Link to this post


    We're using MariaDB with the latest version of OpenAccess version 2015 1.225

     The following error message is received:

    A first chance exception of type
    'Telerik.OpenAccess.Exceptions.OptimisticVerificationException' occurred
    in Telerik.OpenAccess.dll

    Additional information: Row not found: GenericOID@4836944b Usuario usr_llaveusuario=d0cc691b-8a11-4fae-94ea-94aecdbe99ce

    `cnf_icipos`.`cnf_usuarios` SET `usr_contadoraccesos` = ?,
    `usr_fechaultimoacceso` = ?, `usr_hora` = ? WHERE `usr_llaveusuario` = ?
    AND `usr_contadoraccesos` = ? AND `usr_fechaultimoacceso` = ? AND
    `usr_hora` = ?

    (set event logging to all to see parameter values)

    If there is a handler for this exception, the program may be safely continued.


    Any idea to solve this issue?



    Jorge Guevara

  2. Yavor Slavchev
    Yavor Slavchev avatar
    22 posts

    Posted 16 Jun 2015 Link to this post

    Hi Jorge,
    Thank you for contacting us.

    'OptimisticVerificationException' usually occurs when the updated entity is already updated by another context or domain. OpenAccess ORM is trying to updated the record based on its state in current context that might be changed in the meantime. This operations is called optimistic concurrency control. In order to resolve this issue, you should either refresh the context to get the new data or change the behavior of the context to not use optimistic verification if you do not care about this.
    Look at this article to see how you can manage concurrency and this article to see how to turn off concurrency for a specific entity by using the ConcurrencyMode property.

    I hope this information is useful.

    Yavor Slavchev
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  3. DevCraft banner
Back to Top