Dear all

We are experiencing all updates going to an "Error" status in ZCM system updates on servers running 10.3.4. This appears to be happening since the 10.3.4 update stalled whilst putting it out to client machines (timing out through the stages, then finally actually seems to have remove the updates from the deploying system updates list) and in my wisdom I removed the update, re-downloaded and then attempted to apply it.


Name | Status
------------------------------+----------
Jun 2012 PRU | Error
May 2012 PRU | Baselined
Jul 2012 PRU | Error
Update for ZCM (10.3.4) | Error
Support Pack 2 for ZCM (10.2) | Baselined
Update for ZCM (10.1.2a) | Baselined
Update for ZCM (10.1.1) | Baselined
Update for ZCM (10.3.0a) | Baselined
Update for ZCM (10.1.3) | Baselined
Update for ZCM (10.3.3) | Baselined



Re-applying the 10.3.4 update gives the following in the loader-messages.log

[DEBUG] [10/07/12 12:57:40] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to STAGE_PENDING with message: null] [] []
[DEBUG] [10/07/12 12:57:40] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (501003040043ffce784116ab1b312b55) status to STAGE_PENDING] [] []
[DEBUG] [10/07/12 12:57:40] [] [Loader.SystemUpdateModule] [] [FINEST: Advancing to next stage for update: 501003040043ffce784116ab1b312b55 currentStagingBehavior: BYPASS_STAGING currentStageUID: null startSchedule: <Schedule xmlns="http://www.novell.com/ZENworks/v1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.novell.com/ZENworks/v1.0"><InterruptSchedule /></Schedule>] [] []
[DEBUG] [10/07/12 12:57:40] [] [Loader.SystemUpdateModule] [] [FINEST: Current Behavior is : BYPASS_STAGING] [] []
[DEBUG] [10/07/12 12:57:41] [] [Loader.SystemUpdateModule] [] [FINE: Unable to run global pre actions] [java.lang.NullPointerException
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3705)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3402)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:2036)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:1968)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.advanceToNextStage(System UpdateAdminImpl2.java:2881)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:118)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
] []
[DEBUG] [10/07/12 12:57:41] [] [Loader.SystemUpdateModule] [] [FINER: An exception was encountered during pre-global actions...attempting to cancel any pending update assignments] [] []
[DEBUG] [10/07/12 12:57:41] [] [Loader.SystemUpdateModule] [] [FINER: getting query string for ALL_DEVICES_DIRECTLY_ASSIGNED when stages exist] [] []
[DEBUG] [10/07/12 12:57:41] [] [Loader.SystemUpdateModule] [] [FINER: query: from Device d where
d.UID in (select Distinct d1.UID from Device d1, Assignment a, SystemUpdateDeviceInfo s where
a.ContentUID = ?
AND d1.UID = s.DeviceUID
AND s.UpdateUID = ?
AND d1.UID = a.ConsumerUID
AND (d1.Retired = 0 OR s.isIgnored = 0)
and s.UpdateStatus in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
or d.UID in (select Distinct d1.UID from Device d1, Assignment a, SystemUpdateDeviceInfo s, Grouping g where
a.ContentUID = ?
AND d1.UID = s.DeviceUID
AND s.UpdateUID = ?
AND (d1.Retired = 0 OR s.isIgnored = 0)
AND (d1.UID = g.memberUID and a.ConsumerUID = g.groupUID) AND g.groupUID NOT IN (select groups from SystemUpdateStage stage inner join stage.GroupList as groups)
and s.UpdateStatus in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))] [] []
[DEBUG] [10/07/12 12:57:44] [] [Loader.SystemUpdateModule] [] [FINER: Error cancelling scheduled updates] [java.lang.NullPointerException
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3705)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3402)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:2036)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:1968)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.advanceToNextStage(System UpdateAdminImpl2.java:2881)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:118)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
] []
[DEBUG] [10/07/12 12:57:44] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to ERROR with message: SystemUpdate.error.preglobalactions] [] []
[DEBUG] [10/07/12 12:57:45] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (501003040043ffce784116ab1b312b55) status to ERROR] [] []


The latest PRU gives the following error in the loader-messages.log

[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: KBMerge process complete] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: PRU action completed successfully] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to GLOBAL_PRE_ACTIONS with message: null] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: Status for update (5d023c0602f248d9aeeb7cca2e351113): GLOBAL_PRE_ACTIONS] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (5d023c0602f248d9aeeb7cca2e351113) status to GLOBAL_PRE_ACTIONS] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINER: No Install commands, skipping to post-global actions] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: Advancing to next stage for update: 5d023c0602f248d9aeeb7cca2e351113 currentStagingBehavior: null currentStageUID: 11111111111111111111111111111111 startSchedule: null] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: All stages complete, going to post actions phase] [] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINE: Unable to run global pre actions] [java.lang.NullPointerException
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3705)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.setAllMembersStatus(Syste mUpdateAdminImpl2.java:3402)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:2036)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:1968)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.assignUpdate(SystemUpdate AdminImpl2.java:1963)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.advanceToNextStage(System UpdateAdminImpl2.java:2746)
at com.novell.zenworks.datamodel.services.systemupdat e.SystemUpdateAdminImpl2.advanceToNextStage(System UpdateAdminImpl2.java:2701)
at com.novell.zenworks.loader.modules.queue.handlers. PreGlobalHandler.processAction(PreGlobalHandler.ja va:136)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.processAction(QueueThreadWorker.ja va:208)
at com.novell.zenworks.loader.modules.queue.runner.Qu eueThreadWorker.run(QueueThreadWorker.java:139)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
] []
[DEBUG] [10/07/12 13:43:39] [] [Loader.SystemUpdateModule] [] [FINEST: Attempting to set update status to ERROR with message: SystemUpdate.error.preglobalactions] [] []
[DEBUG] [10/07/12 13:43:40] [] [Loader.SystemUpdateModule] [] [FINEST: Updated update (5d023c0602f248d9aeeb7cca2e351113) status to ERROR] [] []

To my eye it looks like there is still an update registered as being in process as, if you look at the details of the 10.3.4 system update in the system update overview it shows a deployment history.

Has anyone any suggestions for ways to clear this?

Thanks

Martyn