ErrorMessage using MariaDB with OpenAccess

[seeware]

Hi,

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

UPDATE
`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?

 

Regards

Jorge Guevara

[Yavor Slavchev]

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.


Regards,
Yavor Slavchev
Telerik