Unable to delete primary server ZCC with SQL database

  • 7008438
  • 22-Apr-2011
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 2 - 10.2 ZENworks Control Center - ZCC

Situation

Unable to delete primary server ZCC with SQL database
 
ERROR:
 
Object delete failed.:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
org.hibernate.exception.GenericJDBCException: error performing bulk delete

Resolution

Workaround:
 
The workaround for this issue is to delete all references to the server in the zProxy table.
 
select count(*) from zProxy where 0x<serverGUID> in (InvokingServerUID, CredentialServerUID, RequestingObjectUID);
 
If that returns a result then run:
 
delete from zProxy where 0x<serverGUID> in (InvokingServerUID, CredentialServerUID, equestingObjectUID);
 
Then try and delete the server through ZCC.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.