Environment
Novell ZENworks Configuration Management 11.3 ZENworks Control Center - ZCC
Novell ZENworks Configuration Management 11.3 Patch Management
Novell ZENworks Configuration Management 11.3 Content
Situation
Unable to cache zpm patches failed with red icon.
Unable to build a bundle with content. ERROR: The wizard cannot continue for the following reason(s): Unable to complete your request for the following reason: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: ...
ERROR: From Loader-messages.log ...No primary key value for foreign key 'fk_zACOContentS_ContentServers' in table 'zACOContentServers'
Unable to build a bundle with content. ERROR: The wizard cannot continue for the following reason(s): Unable to complete your request for the following reason: com.novell.zenworks.datamodel.exceptions.InternalDataModelException:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.ConstraintViolationException: ...
ERROR: From Loader-messages.log ...No primary key value for foreign key 'fk_zACOContentS_ContentServers' in table 'zACOContentServers'
Resolution
From ZCC | Configuration | Content | Primary server Replication and or Satellite Server Replication
Set server to Exclude, Click Apply Set back to proper server to Include, Click Apply
This should reset the zsystemsetting table in the DB to a proper value instead of a bad missing server guid.
Cause
com.novell.zenworks.content.primary.servers
pointing to a orphaned server object, from the zsystemsetting
table.