Row cannot be located for updating. Some values...

[Ryan Kelly]

I'm seeing errors reported updating certain elements within our model.  The update seems to work but I'm concerned by the error. The following is the error reported.

Microsoft Cursor Engine [-2147217864]
Row cannot be located for updating. Some values may have been changed since it was last read.


We are using the shared database (MySQL) backed by VC (Subversion) team sharing setup.

Other members of the team are not experiencing the problem. I have tried re-installing EA and using a fresh Subversion working copy of the model but this has not rectified the problem.

Does EA store some data locally, outside of any VC working copy? I'm thinking that it does since this error seems to suggest that this data is out-of-sync with that in the shared database.

[Eve]

That error usually indicates that you haven't checked the 'Return matched rows instead of affected rows' checkbox when setting up your MySQL ODBC connection.

[Otávio Ventura]

Same here when trying to create/edit Documentation Templates. It doesn't get to insert the register in the database successfully.

Using PostgreSQL 9.0 as the project repository.

Any sugestions?

Tks in advance!

[skiwi]

I've noticed this or something similar when EA has generated duplicate GUIDs.

Tools | Data Management | Run Data Integrity check

(note your model may change!)