Environment
Novell
ZENworks 10 Configuration Management
Situation
Within the
loader.messages.log we can see there seems to be a loop within
Loader.Status Storer Module - About to save StatusData, the same
objectUID, targetDeviceUID and targetUserUID are shown followed by
a Java exception.
ERROR: "[DEBUG] [01/11/07 17:16:00] []
[Loader.Status Storer Module] [Failed to save status data because
of Exception:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.ConstraintViolationException: could not
insert:
[[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]]
[Failed to save status data because of Exception:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.ConstraintViolationException: could not
insert:
[[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]]
[] []"
Resolution
This is fixed in
version 10.0.2 - see KB 3486285 "Updates to
ZENworks 10 Configuration Management" which can be found athttps://www.novell.com/support
Additional Information
For other
possible causes of high utilization, see TID
3389520"High utilization on ZCM server"
Extract from
loader-messages.log with logging set to debug level (SeeTID
3418069"Enable debug logging for ZENworks
10 Configuration Management" athttp://novell.com/support)
[DEBUG] [01/11/07
17:16:00] [] [Loader.Status Storer Module] [Failed to save status
data because of Exception:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.ConstraintViolationException: could not
insert:
[[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]]
[Failed to save status data because of Exception:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.ConstraintViolationException: could not
insert:
[[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]]
[] []
[DEBUG] [01/11/07 17:16:00] [] [Loader.Status Storer Module] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 18 more
] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 18 more
] [] []
[DEBUG] [01/11/07 17:16:00] [] [Loader.Status Storer Module] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 18 more
] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:331)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleSave(HibernateBasicSession.java:895)
at com.novell.zenworks.datamodel.services.status.StatusImpl.saveStatusEvent(StatusImpl.java:310)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.processStatus(StatusStorerModule.java:211)
at com.novell.zenworks.loader.modules.statusstorer.StatusStorerModule.run(StatusStorerModule.java:136)
at com.novell.zenworks.loader.ZENModuleThread.run(ZENModuleThread.java:111)
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [[com.novell.zenworks.datamodel.objects.status.ObjectInformation]]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2140)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2503)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:320)
... 5 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zObjectInfo_objectUID". The conflict occurred in database "zenworks_ZONE", table"dbo.zZENObject", column 'UID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2120)
... 18 more
] [] []