Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Situation
After performing migration from internal Sybase server to Oracle, hang and eventual timeout in ZCC when deploying patch remediation to device.
ERROR (in loader-messages.log):
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Lumension Exception:] [!!!!! Lumension Exception:] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Patch_Subscription_Service terminated] [!!!!! Patch_Subscription_Service
terminated] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in method: runPatchService] [!!!!! Error occured in method:
runPatchService] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in module: zpd] [!!!!! Error occured in module: zpd] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Exception: org.hibernate.exception.ConstraintViolationException: could not
insert: [[com.patchlink.sapphire.datamodel.PackageFile]]
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Lumension Exception:] [!!!!! Lumension Exception:] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Patch_Subscription_Service terminated] [!!!!! Patch_Subscription_Service
terminated] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in method: runPatchService] [!!!!! Error occured in method:
runPatchService] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in module: zpd] [!!!!! Error occured in module: zpd] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Exception: org.hibernate.exception.ConstraintViolationException: could not
insert: [[com.patchlink.sapphire.datamodel.PackageFile]]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Lumension Exception:] [!!!!! Lumension Exception:] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Patch_Subscription_Service terminated] [!!!!! Patch_Subscription_Service
terminated] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in method: runPatchService] [!!!!! Error occured in method:
runPatchService] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in module: zpd] [!!!!! Error occured in module: zpd] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Exception: org.hibernate.exception.ConstraintViolationException: could not
insert: [[com.patchlink.sapphire.datamodel.PackageFile]]
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!]
[!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Lumension Exception:] [!!!!! Lumension Exception:] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Patch_Subscription_Service terminated] [!!!!! Patch_Subscription_Service
terminated] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in method: runPatchService] [!!!!! Error occured in method:
runPatchService] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!! Error
occured in module: zpd] [!!!!! Error occured in module: zpd] [] []
[DEBUG] [4/7/09 7:00:05 AM] [] [Loader.Patch_Subscription_Service] [!!!!!
Exception: org.hibernate.exception.ConstraintViolationException: could not
insert: [[com.patchlink.sapphire.datamodel.PackageFile]]