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 '
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
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