Problems with ZLM schema when upgrading ZLM 7 IR1 to ZLM 7.2 HP2

  • 3445040
  • 02-Nov-2007
  • 30-Apr-2012

Environment

Novell ZENworks 7.2 Linux Management - ZLM7.2
Novell ZENworks 7 Linux Management - ZLM7

Situation

Adding packages to a bundle does not work after upgrading ZLM 7 IR1 to ZLM 7.2 HP2
Fatal Error: Could not recalculate machine updates; nested exception is:
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: An
error occurred while trying to create the object.
Steps to reproduce:1. Disable LDAP clear port 10389 2. Run zlm-upgrade - the upgrade will fail on upgrading the datamodel 3. Re-able clear port4. Run install.sh to complete upgrade. 5. Run zlm-upgrade -b or use zlman bap on a directory with a large number of packages, this should produce the message above.

Resolution

This issue has been fixed in ZLM 7.2 Hot Patch 5, and ZLM 7.2 IR1. To obtain early access to a hot patch with the fix for this problem, Send an email to zen.feedback@novell.com with the subject of "ZLM7.2 Hot Patch". An email reply will be sent with instructions on how to obtain the hot patch.
Below is a workaround (if patch is not applied):
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;

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 ‑d zenworks ‑f /tmp/zen_queue_fix.sql"

This should fix the issue.

5. Exit out of postgres user and try the zlman bap command that was failing.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.