Client Automation - Some missing patches in Patch Manager

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Patch Manager

Issue/Introduction

Some Patch Manager patches are missing in DSM Web Console.

"Default Software Contents Download" Job is running successfully.

New patches appear in console but some old patches are missing.

Environment

Release : 14.*

Component : Patch Manager

Resolution

Set the last Message Number for ca_download_file in table ca_acme_checkpoint to value set after importation of the baseline content_20160121.baseline

1- Open Microsoft SQL Server Management Studio and execute this :

use mdb

update ca_acme_checkpoint set last_message_number=523996 where message_type_uuid=0x0F7B05FD69242D4C9C21BBBC9A473605

2- Execute again "Default Software Contents Download" Job.

It could also be executed manually with :

Open a command prompt and execute this : 

cd "C:\Program Files (x86)\CA\SC\CIC\bin" 

run.bat 

3- Check in DSM Web Console that missing patches appear.