Upgrade to ZCM 10.1 fails on schema update in multi-server zone

  • 7001107
  • 05-Aug-2008
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management

Internal Sybase Database

Microsoft Windows 2003 server

Situation

Upgrade from ZCM 10.0.3 to ZCM 10.1 fails on schema update in multi-server zone

ERROR: One or more serious errors occurred during the schema update.

ERROR: C:\Program Files\Novell\ZENworks\share\java/bin/java:: OUT: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -210: User 'fk_zGroupings_memberUID' has the row in '???' locked

Errors occur in the %ZENworks_Home%/logs/ZENworks_Install* folder

Resolution

As the instructions for the installation of ZCM 10.1 state, shut down all of the services on all ZENworks servers in the zone, except the database service running on the primary server, and then re-run setup.exe/setup.sh

Additional Information

The SybSQLException above indicates that a connection to the Sybase database that ZENworks uses was still in use by another server in the zone.