Environment
Novell
ZENworks 7.2 Linux Management - ZLM7.2
Situation
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.
Resolution
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.
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
BEGIN;
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";
COMMIT;
BEGIN;
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";
COMMIT;
The above
will change the "subject" column to text (can hold unlimited
characters, earlier 255).
characters, earlier 255).
4. Now
execute the follwoing command from the same postgres prompt.
postgres>"psql \u2011d zenworks \u2011f /tmp/zen_queue_fix.sql"
postgres>"psql \u2011d zenworks \u2011f /tmp/zen_queue_fix.sql"
This should
fix the issue.