zman suva or zman sud commands fail with java exception

  • 7001395
  • 19-Sep-2008
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Novell SUSE Linux Enterprise Server 10 Support Pack 1

Situation

Unable to view system updates or download system updates with zman command

zman suva or zman sud commands fail with java exception

ERROR "An internal error occurred.  Please check the zman log for more
information"

Resolution

Login to the internal Sybase database on the SLES server by following these steps:
 
  1. At a command line terminal run the command "zman dgc", enter the zone Administrator credentials and note the username and password that will be used to access the Sybase database.
  2. Run the command "dbisql" from the /opt/novell/zenworks/share/sybase/bin32s folder.
  3. On the Identification tab, supply the user ID and password returned by running zman dgc in step 1.
  4. On the Database tab, select "Find" to find the Sybase database (should be named zenworks_<your_zone_name>.
  5. Select OK to login to the Interactive SQL GUI
  6. In the SQL Statements field, paste the following:

alter table zSystemUpdateCommand
    add commandOrder int default 0 not null;

alter table "zSystemUpdateEx"
  delete foreign key "fk_zSystemUpdateEx_UID";

alter table zSystemUpdateEx
    rename UID to ZUID;

alter table zSystemUpdateEx
    add constraint fk_zSystemUpdateEx_ZUID
    foreign key (ZUID) references zAssignableContentObject
    on delete cascade;;

The zman suva and zman sud commands should now run without exceptions.

Additional Information

In this instance, the ZCM 10.0.3.2 upgrade to 10.1 was not completely successful because all ZENworks services (except the Novell ZENworks Datastore) were not completely stopped on all servers in the zone.  After stopping all of the services the upgrade to 10.1 was run again, but the install reported that it failed with one or more critical errors.  The installation log files indicated that there were problems updating the zSystemUpdateEx table and that the zGUID column did not exist in the database.