How do I manually change the state of a CA Patch Manager patch ?

Document ID : KB000045867
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:    

CA Patch Manager has a bunch of Different States:

  • New
  • Not Applicable
  • Pending User Acceptance
  • Accepted
  • Packaging
  • Packing Failed
  • Distributing
  • Testing
  • Approved                                  

 

Question:

How do I manually change the state of CA Patch Manager patches ?

 

Environment:  

CA Client Automation - All Versions

CA Patch Manager - All Versions

 

Answer:

Here are few SQL commands that can be helpful to move Patches from one State to another

Certain patches you can also Defer and the change to another State.

NOTE: R14 patches can be Accepted no matter what State the Patch is in. 

Update the status of one Patch back to Pending user Acceptance

use mdb 
UPDATE ca_install_package SET status=3
WHERE sw_def_uuid IN (SELECT sw_def_uuid FROM ca_software_def
WHERE name='<PATCH_NAME>')
 

 

TO Check the Status of one patch:

select status from ca_install_package
where sw_def_uuid in (select sw_def_uuid from ca_software_def
where name=’<PATCH_NAME>’)

 

Shows UPM packages that are in “Packaging”:

select * from ca_install_package  WHERE status =7

 

Changes the status of all packages in “Packaging” state to “Pending User Acceptance”

UPDATE ca_install_package SET status=3  WHERE status = 7

 

STATUS_UNKNOWN                                         = 0 Should Never Happen

STATUS_NEW                                                 = 1 Patch Imported by Import Manager

NOT_APPLICABLE                                            = 2 No Instances of the Application it Patches 

STATUS_PENDING_USER_ACCEPTANCE            = 3 Waiting for User to Accept or Defer                                                                                           

STATUS_PENDING_WORKFLOW_ACCEPTANCE   = 4 Waiting for Workflow Approval of Acceptance

STATUS_ACCEPTED                                         = 5 Accepted by workflow or User, pending packaging

STATUS_DEFERRED                                         = 6 Deferred by User

STATUS_PACKAGING                                       = 7 Files Downloading

STATUS_DOWNLOAD_FAILED                          = 8 Download Failed

STATUS_TESTING                                           = 9 Testing has begun

STATUS_PENDING_APPROVAL                          = 10 Waiting for Workflow Approval of Patch

STATUS_APPROVED                                         = 11 Approved by workflow or User

STATUS_INACTIVE                                          = 12 The Release or Patch is Designated Inactive by ACME

STATUS_DISTRIBUTING                                  = 13 The Patch is being Distributed from EM to DM

 

 

Additional Information: