Hello,

I am unable to download the 10.3.0a update through the System Update tab. I am also unable to do a manual import of the update. There are no other system updates downloaded. I have tried to delete the update with command "zman sudu 5010030000327d48854ff3bcc4b8f60a --force". I have tried importing with "zman sui "path to system update file"" but this does nothing. Everytime I try to either import or download I immediately get an Error for the Status. I have checked the loader-messages.log file and I see some errors while trying to download update.

[DEBUG] [7/26/10 5:28:01 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to DOWNLOADING with message: null] [] []
[DEBUG] [7/26/10 5:28:01 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (5010030000327d48854ff3bcc4b8f60a) status to DOWNLOADING] [] []
[DEBUG] [7/26/10 5:28:01 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Status for update (5010030000327d48854ff3bcc4b8f60a): DOWNLOADING] [] []
[DEBUG] [7/26/10 5:28:01 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Calling executeMethod...] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: status = 200] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Last-Modified: Thu] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Last-Modified: 01 Apr 2010 22:08:26 GMT] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Accept-Ranges: bytes] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Date: Mon] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Date: 26 Jul 2010 22:28:02 GMT] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Server: Apache/2.2.3 (Linux/SUSE)] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: ETag: "25fa9e-24ecfc-483341a158a80"] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Cache-Control: no-cache] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Cache-Control: must-revalidate] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Cache-Control: max-age] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Content-Type: application/octet-stream] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Content-Length: 2419964] [] []
[DEBUG] [7/26/10 5:28:02 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Via: 1.1 ICS_SERVER (iChain 2.3.410)] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINER: Download of https://you.novell.com/zenworks/syst...ons-10.3.0.jar complete (2419964 bytes).] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to update command 035d5504249476d1d180bd67a90c3c80] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Checksum value for file: /var/opt/novell/zenworks/content-repo/system-update/5010030000327d48854ff3bcc4b8f60a/pre-global-actions-10.3.0.jar checksum: 6f13bfa4479017c95613a427408af9474fb5fcae2be3fc7768 6824d6786a1425] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to ERROR with message: SystemUpdate.error.importingfiles] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Status for update (5010030000327d48854ff3bcc4b8f60a): DOWNLOADING] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (5010030000327d48854ff3bcc4b8f60a) status to ERROR] [] []
[DEBUG] [7/26/10 5:28:03 PM] [] [Loader.SystemUpdateModule] [] [FINE: Error downloading update] [com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.ConstraintViolationExcepti on: could not delete: [[com.novell.zenworks.datamodel.objects.content.Cont ent#0ee35cc45dd84053f355368acad6245e]]
at com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.newStandardDataModelException(Abst ractDatabaseTypeHelper.java:436)
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.Ab stractHibernateSessionImpl.simpleDelete(AbstractHi bernateSessionImpl.java:430)
at com.novell.zenworks.datamodel.utils.AdminImplUtil. delete(AdminImplUtil.java:132)
at com.novell.zenworks.datamodel.services.content.Con tentAdminImpl.delete(ContentAdminImpl.java:1537)
at com.novell.zenworks.systemupdate.SystemUpdateDownl oader.importContent(SystemUpdateDownloader.java:31 5)
at com.novell.zenworks.systemupdate.SystemUpdateDownl oader.downloadUpdate(SystemUpdateDownloader.java:1 43)
at com.novell.zenworks.loader.modules.queue.handlers. DownloadUpdateHandler.processAction(DownloadUpdate Handler.java:125)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.ConstraintViolationExcepti on: could not delete: [[com.novell.zenworks.datamodel.objects.content.Cont ent#0ee35cc45dd84053f355368acad6245e]]
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.delete(AbstractEntityPersister.java:2384)
at org.hibernate.persister.entity.AbstractEntityPersi ster.delete(AbstractEntityPersister.java:2516)
at org.hibernate.action.EntityDeleteAction.execute(En tityDeleteAction.java:73)
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:144)
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.simpleDelete(AbstractHi bernateSessionImpl.java:419)
... 10 more
Caused by: java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "fk_zContentTypeTags_id". The conflict occurred in database "ZCM10-PSJA_ZONE", table "dbo.zContentTypeTags", column 'id'.
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.jdbc.NonBatchingBatcher.addToBatch(N onBatchingBatcher.java:23)
at org.hibernate.persister.entity.AbstractEntityPersi ster.delete(AbstractEntityPersister.java:2363)
... 23 more
] []


Please help, not sure how to proceed or what to try from here.