« Last post by marke on April 25, 2017, 07:45:54 pm »
I have been running a project for some time using EA1309 on a MySQL server. I have started getting duplicate entry messages when I save a number of diagrams:
Microsoft OLE DB Provider for ODBC Drivers [-21472179001]
[MySQL][ODBC 5.3(w) Driver][mysqld-5 5.9]Duplicate entry'2147483647' for key 'PRIMARY'
and then EA crashes with a "Runtime Error!".
I have run a Project Integrity Check and it reports no errors. I have disabled all add-ins which made no difference.
I'm a bit of db newbie but I tried searching for 2147483647 in phpmyadmin but found only 1 match inside table t_diagramlinks. 2147483647 appeared as an Instance_ID on a diagram. I was able to trace down the diagram. I deleted it in EA and the 2147483647 just appeared as an Instance_ID on the next diagram (in phymyadmin). At this point I decided I was out of my depth.
I'd really appreciate any tips on how to diagnose this further and, ideally, how to fix it. Restoring to a backup would be a last resort (although we do nightly backups) as a number of people have been working on the project for a few days since the problem appeared. I think I know the root package below which the problem manifests so I guess another option would be to xmi export that/delete it/xmi import it to clean things up. I'd lose a few baselines but that wouldn't be the end of the world.