Windows 2003 Primary Server 10.2 running Patch Management with a remote Oracle 10g Database on SUN system.
If your system was upgraded from prior versions of ZCM 10.2 – It is recommended that you run the following query in the database:
Update zZENObject Set undeletable = 0 Where undeletable = 1 And primarytype = 'Bundle' And subtype = 'Patch Bundle';
After doing so navigate to; %Zenworks_Home%\share\datamodel\oracle\uninstall
Grab “nrm-patchlink-saphire-datamodel-drop.sql” and run it in your zcm database this will drop all your patch management tables.
After running the script go to ZCC(web console) navigate to “Bundles” link and delete the “ZPM” folder. You may need to delete bundles w/in “ZPM” folders first.
Then in %Zenworks_Home% move away to some other location the “ZPM” folder it should be recreated later.
Make sure no license info nor subscription activity shows up in the ZCC.
The last step after taking care of all the steps above go to; %Zenworks_Home%\share\datamodel\oracle\
Grab “nrm-patchlink-saphire-datamodel.sql” and run it in your zcm database. This will recreate all the patch-management tables.
You will need to reenter you license information and restart the subscription process.
It did not affect any other component of ZCC except ZPM.
Editors Note: This is a valid workaround for systems running ZCM 10.2, and will temporarily fix this issue: however, the problem may reoccur, and the only long-term fix is to upgrade to ZCM 10.2.1 or later. Do not use this tip on ZCM 10.2.1 or later.