Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1
Novell SUSE Linux Enterprise Server 10 Support Pack 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"
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:
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.
- 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.
- Run the command "dbisql" from the /opt/novell/zenworks/share/sybase/bin32s folder.
- On the Identification tab, supply the user ID and password returned by running zman dgc in step 1.
- On the Database tab, select "Find" to find the Sybase database (should be named zenworks_<your_zone_name>.
- Select OK to login to the Interactive SQL GUI
- 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.