The ZPM agent is stuck in QChain status

  • 3661419
  • 17-Mar-2008
  • 30-Apr-2012

Environment

Novell ZENworks Patch Management 6.4 - ZPM6.4

Situation

The workstations and servers would not reboot after a chained deployment, even though force reboot was applied. The devices will not accept other deployments until they were manually rebooted. In the depolyment options page the suppress chain reboot option was unchecked.

Resolution

Run each line separately in a new query against the PLUS database. Note - these queries will only work on Patch Management 6.4.
  1. DELETE FROM UP_PACKAGES WHERE ACCOUNTID ='00000000-0000-0000-0000-000000000001'
  2. EXEC SPSYS_CREATESYSTASKS
  3. exec spsys_datacleanup