Environment
Novell ZENworks 10 Configuration Management
Situation
When installing ZCM 10.1, if the database
requires a case-sensitive collation, an error is seen in the ZENworks_Install_[install
date].xml file in
the ZENworks logs directory (%ZENWORKS_HOME%\logs on
Windows, /var/opt/novell/log/zenworks
on Linux) that references assetmanagement-50-create-triggers.sql
Resolution
This is fixed in version 10.2 - see KB 7003225 "ZENworks 10
Configuration Management with SP2 (10.2)" which can be found at https://www.novell.com/support
Workaround:
If it is necessary to install ZCM 10.1 instead of 10.2, a prerequisite will be to amend one of the files as shown below.
Install/Disk1/InstData/sql/sql-server/assetmanagement-50-create-triggers.sql must be changed:
RemoteWorkstationOid should be RemoteWorkstationOID
WorkstationOid should be WorkstationOID
Workaround:
If it is necessary to install ZCM 10.1 instead of 10.2, a prerequisite will be to amend one of the files as shown below.
Install/Disk1/InstData/sql/sql-server/assetmanagement-50-create-triggers.sql must be changed:
RemoteWorkstationOid should be RemoteWorkstationOID
WorkstationOid should be WorkstationOID