ZCM 11.2 Server install error rebuilding remote Sybase database: "Unable to rebuild database"

  • 7006408
  • 04-May-2012
  • 04-Mar-2014


Novell ZENworks Configuration Management 11.2 Installation - Server


Primary server with remote Sybase database upgrade OEM xml log error:
' "Unable to rebuild database. Code : 1 Output : This database supports
encrypted tables. You must use one of the -et or -er options. SQL Anywhere
Unload Utility Version Connecting and initializing" using setup.sh


This is fixed in version 11.3 - see KB 7014213 "ZENworks Configuration Management 11.3 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7014213
If this was the only error in the install logs, and all else appears OK with the update, use the workaround:
1.  Steps to be taken care before rebuilding the db manually, or through configure utility:
Manually stop all the ZENworks services (including the Database service) on all the primary servers ( https://www.novell.com/documentation/zenworks11/pdfdoc/zen11_installation/zen11_installation.pdf, 'For detailed information on how to stop and start the ZENworks Services, see “ZENworks Server” in the ZENworks 11 SP2 Primary Server and Satellite Reference.')
Launch novell-zenworks-configure -c Start and select stop to stop the zenworks services on the local primary server.
2.  Then run the rebuild manually by executing a command similar to the following (this will work on Embedded/OEM Sybase):
UID -> user   (verify with commandline: zman dgc, should be zenadmin for Embedded / OEM Sybase)
PWD -> user's password  (obtain with commandline: zman dgc)
DBF -> Path to the database file
/opt/novell/zenworks/share/sybase/bin32s/dbunload -c  "UID=<user>;PWD=<password>;DBF=/var/opt/novell/zenworks/database/zenworks_mani_zone.db" -ar -ap 4096 -ii -et