7006732: Errors in ZCC.LOG when creating Bundles or Policies in ZCC – Satellite or Primary server(s) deleted

The replication settings are set to replicate to allPrimary servers (except those listed) and the list has a guid thatdoes not match with anything in the zDevice or zZenObject tables,which means there is no device or object matching thatguid. This is what causes the exception. So, changingthe settings (Workaround Options, Option B), causes the list toclear out the db and allow replication to work.

So, if the error is related to primary servers, change theprimary server replication settings, save / apply, and then set itback to the other value and save / apply. If it’s satellite,changing the satellite replication settings to the other radiobutton and save / apply and then set it back and save /apply. This should clear up the issue by removingthe orphaned db entry.

Note that the include or exclude for individual servers mayget lost, and need to be configured again.
Full stack trace:
22 Jun 2011 14:42:49============== Exception (begin) ===========================

22 Jun 2011 14:42:49 Exception occured

com.novell.zenworks.datamodel.exceptions.InternalDataModelException:com.novell.zenworks.datamodel.exceptions.InternalDataModelException:org.hibernate.exception.ConstraintViolationException: could notinsert collection:[com.novell.zenworks.datamodel.objects.assignablecontent.AssignableContentObject.ContentServers#2228684c74fe7304ca7e19c83aef687a]

atcom.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession._create(HibernateBasicSession.java:1253)

atcom.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.create(HibernateBasicSession.java:97)

atcom.novell.zenworks.datamodel.session.hibernate.HibernateAdministratorSession.create(HibernateAdministratorSession.java:1339)

atcom.novell.zenworks.datamodel.services.BasicAdminImpl.create(BasicAdminImpl.java:104)

atcom.novell.zenworks.datamodel.services.assignablecontent.AssignableContentObjectAdminImpl.create(AssignableContentObjectAdminImpl.java:63)

atcom.novell.zenworks.datamodel.services.actions.ActionAdminImpl.create(ActionAdminImpl.java:61)

atcom.novell.zenworks.datamodel.services.policies.PolicyAdminImpl.create(PolicyAdminImpl.java:80)

atcom.novell.zenworks.admin.pages.policies.wizards.newPolicy.PolicyBean.execute(PolicyBean.java:597)

atcom.novell.zenworks.admin.pages.policies.wizards.newPolicy.Controller.onFinish(Controller.java:295)

atcom.novell.zenworks.fw.web.layout.WizardController.onWizardEvent(WizardController.java:262)

atcom.novell.zenworks.fw.web.internal.layout.Wizard.verifyActionWithController(Wizard.java:693)

atcom.novell.zenworks.fw.web.internal.layout.Wizard.finishButton_Click(Wizard.java:448)

at sun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

atcom.novell.web.controls.WebControl.fireEvent(WebControl.java:1977)

atcom.novell.web.controls.WebControl.fireEvent(WebControl.java:1952)

atcom.novell.web.controls.Button.raisePostBackEvent(Button.java:475)

atcom.novell.web.controls.Page.raisePostBackEvent(Page.java:885)

atcom.novell.web.controls.Page.raisePostBackEvents(Page.java:872)

atcom.novell.web.controls.Page.internalProcessRequest(Page.java:584)

atcom.novell.web.controls.Page.processRequest(Page.java:528)

atcom.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:586)

atcom.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)

atorg.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:178)

atorg.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)

atorg.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)

atorg.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)

atorg.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)

atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

atorg.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)

atorg.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)

atorg.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)

atorg.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)

atcom.novell.web.NJWCServlet.serviceImpl(NJWCServlet.java:97)

atcom.novell.zenworks.fw.web.internal.ZENworksServlet.service(ZENworksServlet.java:84)

atjavax.servlet.http.HttpServlet.service(HttpServlet.java:803)

atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

atcom.patchlink.sapphire.web.pages.vulnerability.session.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:75)

atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)

atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)

atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)

atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

atcom.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1196)

atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)

atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)

atorg.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

atorg.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

atorg.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

atorg.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)

at java.lang.Thread.run(Thread.java:595)

Caused by:com.novell.zenworks.datamodel.exceptions.InternalDataModelException:org.hibernate.exception.ConstraintViolationException: could notinsert collection:[com.novell.zenworks.datamodel.objects.assignablecontent.AssignableContentObject.ContentServers#2228684c74fe7304ca7e19c83aef687a]

atcom.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:436)

atcom.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:421)

atcom.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:177)

atcom.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:356)

atcom.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession._create(HibernateBasicSession.java:1243)

… 59 more

Caused by: org.hibernate.exception.ConstraintViolationException:could not insert collection:[com.novell.zenworks.datamodel.objects.assignablecontent.AssignableContentObject.ContentServers#2228684c74fe7304ca7e19c83aef687a]

atorg.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)

atorg.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

atorg.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1058)

atorg.hibernate.action.CollectionRecreateAction.execute(CollectionRecreateAction.java:26)

atorg.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)

atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)

atorg.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:143)

atorg.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)

atorg.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

atorg.hibernate.impl.SessionImpl.flush(SessionImpl.java:988)

atorg.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:337)

atorg.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)

atcom.novell.zenworks.datamodel.session.hibernate.HibernateTransactionImpl._commit(HibernateTransactionImpl.java:42)

atcom.novell.zenworks.datamodel.session.hibernate.AbstractHibernateTransactionImpl.commit(AbstractHibernateTransactionImpl.java:46)

atcom.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:345)

… 60 more

Caused by: java.sql.SQLException: The INSERT statement conflictedwith the FOREIGN KEY constraint “fk_zACOContentS_ContentServers”.The conflict occurred in database “Zenworks”, table “dbo.zDevice”,column ‘ZUID’.

atnet.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)

atnet.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)

atnet.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)

atnet.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)

atnet.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)

atnet.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)

atnet.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)

atcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

atorg.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)

atorg.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1039)

… 72 more

Related:

Leave a Reply