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.