11.4 System update fails with Sybase database

  • 7016829
  • 09-Sep-2015
  • 17-Mar-2016

Environment

Novell ZENworks Configuration Management 11.4

Situation

ERROR (from ZENworks_Upgrade_*.log):

FINER: Setting schema version in DB.
FINER: DatabaseUpgradeConfigureAction: getConnection
FINER: Upgrading database schema.
FINER: DatabaseUpgradeConfigureAction: getConnection
FINE: Exception while connecting to database
SEVERE: Exception while upgrading database schema.
com.novell.zenworks.configure.ConfigureException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

at com.novell.zenworks.configure.util.DatabaseUpgradeUtils.getConnection(DatabaseUpgradeUtils.java:191)
at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.configure(ExecutePreGlobalConfigureAction.java:190)
at com.novell.zenworks.configure.actions.ExecutePreGlobalConfigureAction.main(ExecutePreGlobalConfigureAction.java:225)
Caused by: java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(ErrorMessage.java:552)
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:856)
at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3702)
at com.sybase.jdbc3.tds.Tds.handleIOE(Tds.java:3647)
at com.sybase.jdbc3.tds.Tds.login(Tds.java:456)
at com.sybase.jdbc3.jdbc.SybConnection.tryLogin(SybConnection.java:247)

Resolution

Note:  This error happens on retries after an original failed system update.  So while troubleshooting, look at the original system update logs to find and correct the root cause for the first failure before proceeding.

Workaround:  

Rerun the 11.4 system update wizard.  During the system update, after the database is being rebuilt, before seeing this message "Upgrading Database Schema": start manually the sybase audit database:

Windows:  services.msc Novell ZENworks Embedded Datastore for Auditing
Linux:  sybase-audit-asa start

Or for Windows, make a bat in advance that will be run as soon as the database rebuild occurs:

:TOP
net start "Novell ZENworks Embedded Datastore for Auditing"
GOTO :TOP

After restarting the Upgrade Wizard , wait for the database rebuild process to complete in the Wizard .

At this point services will not be running, but soon after rebuild services are loaded, but only ZENworks database service becomes Active. 

Monitor the status of both services and when the update shows a  message like "Upgrading Database Schema", notice Sybase Audit DB service is not Running.
  
Note :  While this message appears the ZCM schema will be upgraded first and it will give the Administrator some time to start Audit DB service. 

At this time the Administrator must ensure that Audit DB service is soon started manually , which ensures that schema changes for Audit does not fail during System Update.

Status

Reported to Engineering

Feedback service temporarily unavailable. For content questions or problems, please contact Support.