11.2.0 server install fails on ZCM 11.2.3a with MS SQL database

  • 7013472
  • 17-Oct-2013
  • 29-May-2014

Environment

Novell ZENworks Configuration Management 11.2 Installation - Server

Situation

An additional 11.2.0 primary server install fails in a ZCM 11.2.3a zone with MS SQL database.
The install will complete with the following error:
ConstraintViolationException: could not insert:
[com.novell.zenworks.datamodel.objects.zoneconfig.ZENServer]

java.sql.SQLException: Cannot insert the value NULL into column
'OutputThrottleRate', table 'ZCM_Main.dbo.zZENServer'; column does not allow
nulls. INSERT fails.
A device object will be created as a managed server. But there will be no object in the server hierarchy.

Resolution

Insert the new server into the zzenserver table properly without the 'outputthrottlerate' column by using the following statement in SQL.

insert into zzenserver values(0x<GUID of newly installed server>, 'Primary' , NULL, 80, 443, 389, 0, 1, 0)

Then the upgrade to the server should apply successfully.

Cause

11.2.3a DB schema has zzenserver table with a column outputthrottlerate, with default value set to 0

When a 11.2 server is installed in a zone, a new entry for the server is inserted as part of install in DB zzenserver table, but 11.2 schema doesn't have the column outputthrottlerate and henceforth insertion fails with constraint violation exception. 

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