Environment
Novell ZENworks 7.5 Asset Management - ZAM7.5
Situation
Error Unable to create option set when creating a new options set in the ZAM Manager.
Resolution
Fixed in ZENworks Asset Management 7.5 Interim Release 22 or newer
Interim Releases can be scheduled to run automatically or can be downloaded manually at https://download.novell.com/patch/finder. The Interim releases can be set up within the ZAM Manager for the Task server to check the site on a scheduled basis, and download and apply them automatically. Please refer to the Help Section details of how to set up automatic downloads if desired.
Each interim release is cumulative. If Interim Release 22 is not available due to a newer interim release being placed on the website, be assured that the code needed is in the later release.
Additional Information
Error in the TSCMgrEvent log shows:
Database Persistence Layer Error in DBSQLServerErrorHandler::serverError at 3/24/2010 1:37:48 PM
Database Error
[2.5.3] Error: '[5] [SERVERERROR] Cannot insert the value NULL into column 'ChoiceText', table 'ZENworks.dbo.NC_StrChoiceListItem'; column does not allow nulls. INSERT fails.
[SERVERMESSAGE] The statement has been terminated.'
Database Error
[2.5.3] Error: '[5] [SERVERERROR] Cannot insert the value NULL into column 'ChoiceText', table 'ZENworks.dbo.NC_StrChoiceListItem'; column does not allow nulls. INSERT fails.
[SERVERMESSAGE] The statement has been terminated.'