ZCM 11.1 upgrade process says it succeeded when it has failed to upgrade the external database.

ZCM primaries and external Sybase OEM database running on SLES 10.3

When performing an upgrade to ZCM 11.1 the GUI displays a message that the upgrade succeeded when the upgrade failed. The install/upgrade on the primary will fail with an incompatible database version error. In looking at the install log on the database server the database upgrade failed.

The database upgrade log contained the following error:

0000SetEnvironmentConfigureAction complete!11332593962670Unknown DeviceServer Install
0000SaveDBVariablesConfigureAction complete!21332595172269Unknown DeviceServer Install
0000sybase-asa-12.0.0-2624.i586.rpm installed successfully21332595345503Unknown DeviceServer Install
0000Launching dbupgrad11332595345800Unknown DeviceServer Install
0000Unable to upgrade database. Code : 9
 Output : SQL error (-103) -- Invalid user ID or password
SQL Anywhere Upgrade Utility Version 12.0.0.2624
81332595349664Unknown DeviceServer Install
0000UpgradeSybaseDBConfigureAction complete!21332595349671Unknown DeviceServer Install

Workaround:

1- Stop the ZCM services on the primary using 'novell-zenworks-start -c Start'

2- Stop the database services on the db server using '/etc/init.d/./sybase-asa stop'

3- Make a backup of the database and the transaction logs in /opt/novell/zenworks/database/

4- Backup or note the settings in /etc/opt/novell/zenworks/zenworks_database.conf

5- Uninstall the Sybase RPMs from the remote database server.

6- Delete the /etc/opt/novell/zenworks, /var/opt/novell/log/zenworks, and /opt/novell/zenworks directories on the database server

7- Re-install the Sybase OEM database from the 10.3 installation media using './setup.sh -c'

8- Stop the database services using '/etc/init.d/./sybase-asa stop'

9- Restore the database files to the server from the backup, do not restore the transaction log

10- Check permissions on the database using 'stat -c "%a %n" *', they should be set to 600, if not change them using 'chmod 600 /opt/novell/zenworks/database/zenworks_database.db' and 'chmod 600 /opt/novell/zenworks/database/zenworks_database.log'

11- Recreate the transaction log for the database using '/opt/novell/zenworks/share/sybase/bin32s/./dbeng10 -f /opt/novell/zenworks/database/zenworks_database.db'

12- Check the permissions again on the database and the transaction log using 'stat -c "%a %n" *', they should be set to 600, if not change them using 'chmod 600 /opt/novell/zenworks/database/zenworks_database.db' and 'chmod 600 /opt/novell/zenworks/database/zenworks_database.log'

13- Edit /etc/opt/novell/zenworks/zenworks_database.conf and make sure it has the same settings noted in step 4

14- Start the services on the database server using '/etc/init.d/./sybase-asa start'

15- Start the ZCM primary services using 'novell-zenworks-start -c Start'

16- Verify connection to the database by logging into ZCC and browsing for devices and users in the user source, you should see the devices and users in ZCC

17- Run the ZCM 11.1 update on the remote database server using 'setup.sh -O' from the ZCM 11.1 media

18- Check the install log in /var/opt/novell/log/zenworks/ to make sure that the database upgraded properly.

19- Run the ZCM 11.1 install/upgrade on the primary