Unable to delete primary server ZCC with SQL database

  • Document ID:7008438
  • Creation Date:22-Apr-2011
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      ZENworks Configuration Management

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.