We updated our 10.2 server (was fresh installed as 10.2) to 10.2.1 last night and about 30 machines in our test lab.

We found out that devices where not updating their ip address info in ZCC. We then noticed the "agent" version did not update either. After doing some more digging around any updates that the device would send to the Primary servers was not updating.

Logins, and bundles etc seem to still work.

I found this in the services.log on the primary server when doing a refresh from a device who's ip address had changed.

Basically the it looks like the it won't update the database becuase "'uniq_zDevice_SerialNumber' for table 'zDevice' would not be unique"

Is my database screwed?

[DEBUG] [9/4/09 11:58:52 AM] [] [QuickTask Service] [] [getQuickTasks complete, time: 7ms, object: 11e7ba17f9829840893f757a41ce5d80, thread: 58] [] []
[DEBUG] [9/4/09 11:58:52 AM] [] [RegistrationAdminImpl: InternalDataModel exception while trying to create/update device: H102-16] [] [com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.ConstraintViolationExcepti on: could not update: [[com.novell.zenworks.datamodel.objects.devices.Devi ce#11e7ba17f9829840893f757a41ce5d80]]
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.newStandardDataModelException(Abst ractDatabaseTypeHelper.java:436)
at com.novell.zenworks.datamodel.database.sqlanywhere .SQLAnywhereHelper.newStandardDataModelException(S QLAnywhereHelper.java:282)
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.throwStandardDataModelException(Ab stractDatabaseTypeHelper.java:421)
at com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:177)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.update(HibernateBasicSession.j ava:838)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.update(HibernateBasicSession.j ava:786)
at com.novell.zenworks.datamodel.session.hibernate.Hi bernateAdministratorSession.update(HibernateAdmini stratorSession.java:1371)
at com.novell.zenworks.datamodel.services.BasicAdminI mpl.update(BasicAdminImpl.java:196)
at com.novell.zenworks.datamodel.services.devices.Dev iceAdminImpl.update(DeviceAdminImpl.java:313)
at com.novell.zenworks.datamodel.services.registratio ns.RegistrationAdminImpl.persistDevice(Registratio nAdminImpl.java:931)
at com.novell.zenworks.datamodel.services.registratio ns.RegistrationAdminImpl.register(RegistrationAdmi nImpl.java:2004)
at com.novell.zenworks.webservice.registration.Regist rationWebService.registerDevice(RegistrationWebSer vice.java:934)
at com.novell.zenworks.registration.schema.Registrati on_ServiceTieSkeleton.registerDevice(Registration_ ServiceTieSkeleton.java:65)
at com.novell.zenworks.registration.schema.Registrati on_ServiceSkeleton._invoke(Registration_ServiceSke leton.java:273)
at com.novell.soa.ws.server.ServletSkeleton.invokeEnd Point(ServletSkeleton.java:201)
at com.novell.soa.ws.impl.soap.MessageHandlerInvoker. invokeServerMessageHandlers(MessageHandlerInvoker. java:347)
at com.novell.soa.ws.impl.soap.SOAPHandler.handleServ erRequest(SOAPHandler.java:85)
at com.novell.soa.ws.impl.rpc.ServerDelegateImpl.hand leServerRequest(ServerDelegateImpl.java:92)
at com.novell.soa.ws.server.ServletSkeleton.handleReq uest(ServletSkeleton.java:101)
at com.novell.soa.ws.server.ServletSkeleton.doPost(Se rvletSkeleton.java:300)
at com.novell.zenworks.webservice.registration.Regist rationImpl.doPost(RegistrationImpl.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at com.novell.zenworks.webservice.lib.AuthenticationF ilter.doFilter(AuthenticationFilter.java:164)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at com.novell.zenworks.webservice.lib.StatisticFilter .doFilter(StatisticFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:108)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1122)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not update: [[com.novell.zenworks.datamodel.objects.devices.Devi ce#11e7ba17f9829840893f757a41ce5d80]]
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.update(AbstractEntityPersister.java:2290)
at org.hibernate.persister.entity.AbstractEntityPersi ster.updateOrInsert(AbstractEntityPersister.java:2 180)
at org.hibernate.persister.entity.AbstractEntityPersi ster.update(AbstractEntityPersister.java:2450)
at org.hibernate.action.EntityUpdateAction.execute(En tityUpdateAction.java:91)
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:140)
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 com.novell.zenworks.datamodel.session.hibernate.Hi bernateBasicSession.update(HibernateBasicSession.j ava:819)
... 39 more
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]Index 'uniq_zDevice_SerialNumber' for table 'zDevice' would not be unique
at ianywhere.ml.jdbcodbc.IIPreparedStatement.executeU pdate(Native Method)
at ianywhere.ml.jdbcodbc.IPreparedStatement.executeUp date(IPreparedStatement.java:214)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.persister.entity.AbstractEntityPersi ster.update(AbstractEntityPersister.java:2272)
... 49 more