Upgrade to ZENworks 11 SP3 (11.3) Fails before rebuilding Embedded Sybase Database

Installing the Audit database on a Linux primary server where ZENworks 11.2 is installed with the following command:
   sh setup.sh -c --zcminstall
Upgrading first ZENworks primary server to version 11 SP3 (11.3)
This primary server may have been replaced with a new server in the past
Embedded Sybase Database is being used on the primary server

The following could be seen in the ZENworks_Upgrade_date_time.log.xml:

Database type has been detected as: Embedded/OEM Sybase SQLAnywhere
the value of isFirstPrimaryStatus:true
Server dont have role : Database
Creating Database

ERROR on Linux:
DB Creation ( /opt/novell/zenworks/share/sybase/bin/dbinit ) tool failed with return code: 127
com.novell.zenworks.configure.ConfigureException: DB Creation ( /opt/novell/zenworks/share/sybase/bin/dbinit ) tool failed with return code: 127
    at com.novell.zenworks.configure.actions.db.AuditDatabaseConfigureAction.configure(AuditDatabaseConfigureAction.java:332)
...
Caused by: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: DB Creation ( /opt/novell/zenworks/share/sybase/bin/dbinit ) tool failed with return code: 127
    at com.novell.zenworks.configure.actions.db.SybaseDatabaseConfigure.createDatabase(SybaseDatabaseConfigure.java:230)

ERROR on Windows:
com.novell.zenworks.sysconfig.LauncherException: Cannot run program "D:\Novell\ZENworks\share\asa\Bin64\dbinit": CreateProcess error=2, The system cannot find the file specified
com.novell.zenworks.configure.ConfigureException: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "D:\Novell\ZENworks\share\asa\Bin64\dbinit": CreateProcess error=2, The system cannot find the file specified
    at com.novell.zenworks.configure.actions.db.AuditDatabaseConfigureAction.configure(AuditDatabaseConfigureAction.java:332)
...
Caused by: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "D:\Novell\ZENworks\share\asa\Bin64\dbinit": CreateProcess error=2, The system cannot find the file specified
    at com.novell.zenworks.configure.actions.db.SybaseDatabaseConfigure.createDatabase(SybaseDatabaseConfigure.java:239)
...
Caused by: com.novell.zenworks.sysconfig.LauncherException: Cannot run program "D:\Novell\ZENworks\share\asa\Bin64\dbinit": CreateProcess error=2, The system cannot find the file specified
    at com.novell.zenworks.sysconfig.NativeLauncher.runCommand(NativeLauncher.java:229)
...
Caused by: java.io.IOException: Cannot run program "D:\Novell\ZENworks\share\asa\Bin64\dbinit": CreateProcess error=2, The system cannot find the file specified
    at java.lang.ProcessBuilder.start(Unknown Source)
...
Caused by: java.io.IOException: CreateProcess error=2, The system cannot find the file specified
    at java.lang.ProcessImpl.create(Native Method)

1. Run this query to verify that the Database role is indeed missing in the database:
   SELECT * FROM zZENServerRoles WHERE Roles = 'Database'
2. If there is a row returned, contact Novell Support for further assistance. If not, continue with these steps
3. Take a reliable backup of the database with the command: zman db
4. Run the following on the database:
   INSERT INTO zZENServerRoles (id, Roles, position) VALUES (0x<first primary server GUID>, 'Database', (SELECT MAX(position) FROM zZENServerRoles WHERE id=0x<first primary server GUID>)+1);
   COMMIT;
5. Rerun the upgrade to ZENworks 11 SP3 (11.3) with one of the following depending on the platform:
6. • setup.sh
   • setup.exe
     

This is caused by the fact that the new Sybase rpm is being marked not to be installed. The Sybase dbinit from the old version is being used to create the Audit database.

The 64-bit version of Sybase never gets installed because the Database role is missing from the database.

Note that the following is NOT seen in the log:

sybase-asa-12.0.1.3924.x86_64.msi installed successfully