Environment
Novell ZENworks Configuration Management 11.2
Novell ZENworks Configuration Management 11.3
Embedded OEM Sybase Database
Linux Primary Server
Microsoft Windows Primary Server
Novell ZENworks Configuration Management 11.3
Embedded OEM Sybase Database
Linux Primary Server
Microsoft Windows Primary Server
Situation
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)
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)
Resolution
- Run this query to verify that the Database role is indeed
missing in the database:
SELECT * FROM zZENServerRoles WHERE Roles = 'Database' - If there is a row returned, contact Novell Support for further assistance. If not, continue with these steps
- Take a reliable backup of the database with the command: zman db
- 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; - Rerun the upgrade to ZENworks 11 SP3 (11.3) with one of the following depending on the platform:
-
- setup.sh
- setup.exe
Cause
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.
The 64-bit version of Sybase never gets installed because the Database role is missing from the database.
Additional Information
Note that the following is NOT seen in the log:
sybase-asa-12.0.1.3924.x86_64.msi installed successfully
sybase-asa-12.0.1.3924.x86_64.msi installed successfully