ZENworks 2017 Upgrade fails to upgrade embedded database on SLES 12 SP1

  • Document ID:7022438
  • Creation Date:06-Dec-2017
  • Modified Date:28-Dec-2017
    • Micro Focus Products:
      ZENworks Configuration Management
    • SUSE Products:
      SUSE Linux Enterprise Server

Environment

ZENworks Configuration Management 2017 System Update
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

Resolution

  1. Login to a terminal
  2. 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/
  3. Rerun the ZENworks 2017 Upgrade