Log shows failure in "assetmanagement-50-create-triggers.sql" when installing ZCM 10.1

  • 7003455
  • 05-Jun-2009
  • 30-Apr-2012

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