Object Not Found Exception: No row with the given identifier exists error occurs when trying to open a record

[tlammer]

Issue: When trying to open a record (can happen to any kind of record), the form for that kind of record opens, but a popup error occurs with text similar to the error below.

Cause: Specify is looking for a record that does not exist. Either the base record itself does not exist or it is referencing a record that does not exist. This usually happens because the table is in ISAM instead of InnoDB

Resolution: The tables need to be changed to InnoDB

org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [edu.ku.brc.specify.datamodel.CollectionObject#143840]

            at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377)

            at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145)

            at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:179)

            at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)

            at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)

            at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)

            at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)

            at org.hibernate.type.EntityType.resolve(EntityType.java:379)

            at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)

            at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:854)

            at org.hibernate.loader.Loader.doQuery(Loader.java:729)

            at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)

            at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)

            at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)

            at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)

            at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)

            at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)

            at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)

            at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)

            at org.hibernate.collection.PersistentSet.toArray(PersistentSet.java:171)

            at java.util.Vector.<init>(Unknown Source)

            at edu.ku.brc.specify.treeutils.TreeAdditionalProcFactory$TaxonAdditionalProcessing.processTaxonSynonymy(TreeAdditionalProcFactory.java:120)

            at edu.ku.brc.specify.treeutils.TreeAdditionalProcFactory$TaxonAdditionalProcessing.process(TreeAdditionalProcFactory.java:96)

            at edu.ku.brc.specify.treeutils.HibernateTreeDataServiceImpl.fixAdditionalRelationsips(HibernateTreeDataServiceImpl.java:1074)

            at edu.ku.brc.specify.treeutils.HibernateTreeDataServiceImpl.synonymize(HibernateTreeDataServiceImpl.java:1098)

            at edu.ku.brc.specify.ui.treetables.TreeTableViewer$26.doInBackground(TreeTableViewer.java:2609)

            at edu.ku.brc.specify.ui.treetables.TreeTableViewer$26.doInBackground(TreeTableViewer.java:1)

            at javax.swing.SwingWorker$1.call(Unknown Source)

            at java.util.concurrent.FutureTask.run(Unknown Source)

            at javax.swing.SwingWorker.run(Unknown Source)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

            at java.lang.Thread.run(Unknown Source)

[hexx870206helen]

I got the same issue when I tried to open the Specify...Did you get any clues for this problem? @tlammer

[tlammer]

The record being opened is is no longer in the database or it is looking for an associated record that is no longer in the database, or can't be opened. The error happens for our users when either the engine for the table is ISAM instead of InnoDB or when a record got deleted through MySQL (the original record points to the record ID but that ID no longer exists). In the example I had, it was looking for a Collection Object record with the collectionObjectID 143840. If that doesn't help let me know at [email protected] and I can have the programmer work with you a bit more.