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

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 '

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