My patch management update is set to fire off at 2:00am. In my loader-messages.log I have


[DEBUG] [7/28/10 2:09:38 AM] [] [ImportContent] [] [Done processing: abaafc6c0bb1427e2fdda82450ff5485] [] []
[DEBUG] [7/28/10 2:09:40 AM] [] [Loader.PatchSubscriptionService] [] [Error Delete signature with name C122AA6FC4B002B18DD52FE31E7DA934] [] []
[DEBUG] [7/28/10 2:09:40 AM] [] [Loader.PatchSubscriptionService] [] [org.hibernate.exception.ConstraintViolationExcepti on: could not delete: [[com.patchlink.sapphire.datamodel.PatchSignature#12 677]]
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.lumension.PatchManager.deleteP atchSignatureByMD5(PatchManager.java:718)
at com.novell.zenworks.lumension.PatchSubscriptionSer vice.processAction(PatchSubscriptionService.java:3 86)
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:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [[Sybase]][[ODBC Driver]][[SQL Anywhere]]Primary key for row in table 'PATCHSIGNATURE' is referenced by foreign key 'FK38670AEAB227C794' in table 'BaseLineGroupPatchSignature'
at ianywhere.ml.jdbcodbc.IIPreparedStatement.executeU pdate(Native Method)
at ianywhere.ml.jdbcodbc.IPreparedStatement.executeUp date(IPreparedStatement.java:219)
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)
... 17 more
] [] []


There are several more error messages but I suspect they all stem from this first one. Do I have to do DB stuff or if I turn the other way will it .....
Maybe I could press that magic button again? Anyone?

Cheers