Environment
Novell ZENworks 10 Configuration Management
Internal Sybase Database
Microsoft Windows 2003 server
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
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.