Hello,

We just upgrade from ZCM 10.3.x to 11.0. I now like to create an job to upgrade de agents also. But when I try to click the finisch button in Step 5 under "Create System Update Deployment" in ZCC it tels me de following:

"The wizard cannot continue for the following reason(s):
Unable to complete your request, check ZCC logs at C:\Program Files (x86)\Novell\ZENworks\logs\zcc.log for further information"

When I look in de logfile it says de following:


11 aug 2011 15:39:00 ============== Exception (begin) ===========================
11 aug 2011 15:39:00 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [com.novell.zenworks.datamodel.objects.queue.QueueA ction]
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.newStandardDataModelException(Abst ractDatabaseTypeHelper.java:444)
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.throwStandardDataModelException(Ab stractDatabaseTypeHelper.java:429)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleSave(AbstractHibe rnateSessionImpl.java:356)
at com.novell.zenworks.datamodel.services.queue.Queue AdminImpl.add(QueueAdminImpl.java:385)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setUpdateAuthorized(Syste mUpdateAdminImpl2.java:1335)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setUpdateAuthorized(Syste mUpdateAdminImpl2.java:1287)
at com.novell.zenworks.admin.pages.configuration.wiza rds.deployUpdate.Controller.onFinish(Controller.ja va:77)
at com.novell.zenworks.fw.web.layout.WizardController .onWizardEvent(WizardController.java:262)
at com.novell.zenworks.fw.web.internal.layout.Wizard. verifyActionWithController(Wizard.java:693)
at com.novell.zenworks.fw.web.internal.layout.Wizard. finishButton_Click(Wizard.java:448)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.novell.web.controls.WebControl.fireEvent(WebCo ntrol.java:1977)
at com.novell.web.controls.WebControl.fireEvent(WebCo ntrol.java:1952)
at com.novell.web.controls.Button.raisePostBackEvent( Button.java:475)
at com.novell.web.controls.Page.raisePostBackEvent(Pa ge.java:1039)
at com.novell.web.controls.Page.raisePostBackEvents(P age.java:1026)
at com.novell.web.controls.Page.internalProcessReques t(Page.java:720)
at com.novell.web.controls.Page.processRequest(Page.j ava:664)
at com.novell.zenworks.fw.web.internal.layout.Index.p rocessRequest(Index.java:613)
at com.novell.web.internal.controls.PageTag.doEndTag( PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp .java:181)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.pro cessRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doF orward(ApplicationDispatcher.java:342)
at org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher.java:302)
at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet .java:97)
at com.novell.zenworks.fw.web.internal.ZENworksServle t.service(ZENworksServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at com.patchlink.sapphire.web.pages.vulnerability.ses sion.HibernateSessionFilter.doFilter(HibernateSess ionFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:109)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1278)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run( JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [com.novell.zenworks.datamodel.objects.queue.QueueA ction]
at org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate. performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2044)
at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2481)
at org.hibernate.action.EntityIdentityInsertAction.ex ecute(EntityIdentityInsertAction.java:47)
at org.hibernate.engine.ActionQueue.execute(ActionQue ue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener. performSaveOrReplicate(AbstractSaveEventListener.j ava:290)
at org.hibernate.event.def.AbstractSaveEventListener. performSave(AbstractSaveEventListener.java:180)
at org.hibernate.event.def.AbstractSaveEventListener. saveWithGeneratedId(AbstractSaveEventListener.java :108)
at org.hibernate.event.def.DefaultSaveOrUpdateEventLi stener.saveWithGeneratedOrRequestedId(DefaultSaveO rUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.s aveWithGeneratedOrRequestedId(DefaultSaveEventList ener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventLi stener.entityIsTransient(DefaultSaveOrUpdateEventL istener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.p erformSaveOrUpdate(DefaultSaveEventListener.java:2 7)
at org.hibernate.event.def.DefaultSaveOrUpdateEventLi stener.onSaveOrUpdate(DefaultSaveOrUpdateEventList ener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImp l.java:534)
at org.hibernate.impl.SessionImpl.save(SessionImpl.ja va:522)
at org.hibernate.impl.SessionImpl.save(SessionImpl.ja va:518)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleSave(AbstractHibe rnateSessionImpl.java:344)
... 53 more
Caused by: java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_zQueue_serverUID". The conflict occurred in database "zenworks_driestarcollege", table "dbo.zZENServer", column 'ZUID'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:365)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:628)
at net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:525)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:487)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.ex ecuteUpdate(JtdsPreparedStatement.java:421)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.id.IdentityGenerator$GetGeneratedKey sDelegate.executeAndExtract(IdentityGenerator.java :73)
at org.hibernate.id.insert.AbstractReturningDelegate. performInsert(AbstractReturningDelegate.java:33)
... 69 more
11 aug 2011 15:39:00

Exception Info:
11 aug 2011 15:39:00 Class....... com.novell.zenworks.datamodel.exceptions.InternalD ataModelException
11 aug 2011 15:39:00 Message..... org.hibernate.exception.ConstraintViolationExcepti on: could not insert: [com.novell.zenworks.datamodel.objects.queue.QueueA ction]
11 aug 2011 15:39:00 Logged at... Controller..........112
11 aug 2011 15:39:00 ============== Exception (end) =============================


Does someone knows what is going on?

Ik try an database check with ZDC en dat is correct now.

Thanks for helping us,

Adriaan Noteboom