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

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

Environment

Novell ZENworks Configuration Management 11.2 Installation - Server

Situation

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 12.0.0.2624 Connecting and initializing" using setup.sh
-O
'

Resolution

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.')
 
or
 
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

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