ZLM 7.0 to 7.2 Upgrade fails to complete with no apparent error (but with datamodel errors in log file)

  • 3587852
  • 29-May-2007
  • 30-Apr-2012


Novell ZENworks 7.2 Linux Management - ZLM7.2


ZLM 7.0 to 7.2 server upgrade fails without showing an error. Though the output shows successfully upgraded, the log file (/var/opt/novell/log/zenworks/) does show thrown exceptions while installing datamodel.


Verify that eDir is listening on the expected port (10389) before starting the upgrade. The failure of the ZLM
Upgrade to communicate with eDir did not cause the upgrade to fail, so it appeared to the user that the upgrade
completed successfully, when, in fact the upgrade of the eDir schema had failed. So it is strongly suggested that at the end of the upgrade the user must review the Upgrade Log File to verify that all operations were successful.
If the update failed as described above, the following will fix the problem:
1. On the ZLM server login as postgres by executing command "su postgres"
2. Once you get postgres prompt, execute "vi /tmp/zen_queue_fix.sql"
3. Save the following data into that file
CREATE TABLE "my_temp" AS SELECT * FROM "zen_queue";
DROP TABLE "zen_queue";
CREATE TABLE "zen_queue" (
qid int8 not null,
action varchar(64) not null,
entry_time timestamp not null,
status_time timestamp,
status char(1),
start_time timestamp,
subject text,
params varchar(255),
retval varchar(255),
primary key (qid)
INSERT INTO "zen_queue" SELECT * FROM "my_temp";
DROP TABLE "my_temp";
The above will change the "subject" column to text (can hold unlimited
characters, earlier 255).
4. Now execute the follwoing command from the same postgres prompt.
postgres>"psql \u2011d zenworks \u2011f /tmp/zen_queue_fix.sql"
This should fix the issue.