Environment
ZENworks Configuration Management 2017 System Update
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)
SUSE Linux Enterprise Server 12 Service Pack 1 (SLES 12 SP1)
Situation
The ZENworks 2017 upgrade fails with database errors
The following may be seen in the err.log:
ERROR:
Upgrading database: ZCM
Unable to upgrade database ZCM. Code : 1
Output : SQL error (-1150) -- The SQL scripts DLL cannot be loaded
SQL Anywhere Upgrade Utility Version 17.0.4.2098
Upgrade failed
...
Upgrading database: Audit
Unable to upgrade database Audit. Code : 9
Output : SQL error (-75) -- Request to start/stop database denied
SQL Anywhere Upgrade Utility Version 17.0.4.2098
...
$UPGRADE_RESULTS$:FAILED
The following could be seen in the ZENworks_Upgrade_<date>_<time>.log.xml:
ERROR:
Unable to upgrade database ZCM. Code : 9
Output : SQL error (-816) -- Specified database file already in use
SQL Anywhere Upgrade Utility Version 17.0.4.2098
...
Unable to upgrade database Audit. Code : 9
Output : SQL error (-816) -- Specified database file already in use
SQL Anywhere Upgrade Utility Version 17.0.4.2098
The following may be seen in the err.log:
ERROR:
Upgrading database: ZCM
Unable to upgrade database ZCM. Code : 1
Output : SQL error (-1150) -- The SQL scripts DLL cannot be loaded
SQL Anywhere Upgrade Utility Version 17.0.4.2098
Upgrade failed
...
Upgrading database: Audit
Unable to upgrade database Audit. Code : 9
Output : SQL error (-75) -- Request to start/stop database denied
SQL Anywhere Upgrade Utility Version 17.0.4.2098
...
$UPGRADE_RESULTS$:FAILED
The following could be seen in the ZENworks_Upgrade_<date>_<time>.log.xml:
ERROR:
Unable to upgrade database ZCM. Code : 9
Output : SQL error (-816) -- Specified database file already in use
SQL Anywhere Upgrade Utility Version 17.0.4.2098
...
Unable to upgrade database Audit. Code : 9
Output : SQL error (-816) -- Specified database file already in use
SQL Anywhere Upgrade Utility Version 17.0.4.2098
Resolution
- Login to a terminal
- Run the following commands:
- cp /opt/novell/zenworks/lib/systemd/system/sybase*-asa.service /tmp/
- cd /usr/lib/systemd/system/
- cp sybase*-asa.service /opt/novell/zenworks/lib/systemd/system/
- Rerun the ZENworks 2017 Upgrade