My server will not upgrade to 10.0.2 and it will also not upgrade to the latest 10.0.3. I watch the log fil as it is attempting to upgrade but it logs a SQL error:

Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [[com.novell.zenworks.datamodel.objects.status.Objec tInformation]]
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(En tityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQue ue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:297)
at org.hibernate.event.def.DefaultFlushEventListener. onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.j ava:988)
at org.hibernate.impl.SessionImpl.managedFlush(Sessio nImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(J DBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateTransactionImpl._commit(HibernateTransactio nImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateTransactionImpl.commit(AbstractHibe rnateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleSave(AbstractHibe rnateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]No primary key value for foreign key 'fk_zObjectInfo_objectUID' in table 'zObjectInfo'
at ianywhere.ml.jdbcodbc.IIPreparedStatement.executeU pdate(Native Method)
at ianywhere.ml.jdbcodbc.IPreparedStatement.executeUp date(IPreparedStatement.java:177)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(N onBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2120)
... 18 more
] [com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [[com.novell.zenworks.datamodel.objects.status.Objec tInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.Abst ractDatabaseTypeHelper.newStandardDataModelExcepti on(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.sqla nywhere.SQLAnywhereHelper.newStandardDataModelExce ption(SQLAnywhereHelper.java:262)
at com.novell.zenworks.datamodel.utils.hibernate.Abst ractDatabaseTypeHelper.throwStandardDataModelExcep tion(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleSave(AbstractHibe rnateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.simpleSave(HibernateBasicSessi on.java:895)
at com.novell.zenworks.datamodel.services.status.Stat usImpl.saveStatusEvent(StatusImpl.java:312)
at com.novell.zenworks.loader.modules.statusstorer.St atusStorerModule.processStatus(StatusStorerModule. java:211)
at com.novell.zenworks.loader.modules.statusstorer.St atusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZEN ModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [[com.novell.zenworks.datamodel.objects.status.Objec tInformation]]
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(En tityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQue ue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:297)
at org.hibernate.event.def.DefaultFlushEventListener. onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.j ava:988)
at org.hibernate.impl.SessionImpl.managedFlush(Sessio nImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(J DBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateTransactionImpl._commit(HibernateTransactio nImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateTransactionImpl.commit(AbstractHibe rnateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleSave(AbstractHibe rnateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]No primary key value for foreign key 'fk_zObjectInfo_objectUID' in table 'zObjectInfo'
at ianywhere.ml.jdbcodbc.IIPreparedStatement.executeU pdate(Native Method)
at ianywhere.ml.jdbcodbc.IPreparedStatement.executeUp date(IPreparedStatement.java:177)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(N onBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2120)
... 18 more


Any ideas? It never gets past pending. I have made a backup of the server in an attempt to reinstall the database in a secondary server but documentation for that is very minimal and sketchy at best on these forums.