Error deploying patches after Oracle migration

  • Document ID:7003047
  • Creation Date:19-Apr-2009
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Configuration Management

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]]

Status

Reported to Engineering