Client Automation - Error ocurred executing a DSM Webservice method. Reason: Distribution does not exist

Products

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

Issue/Introduction

In PMEngine.log on Enterprise Server, error like this appears a lot of times (about every minute) :

Example for patch CA - Win 7 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1604.00 :

 

2021-04-12 16:04:19,838 [DistributedPatchTask] ERROR [com.ca.pmengine.eventmanager] - Error ocurred executing a DSM Webservice method. Reason:  Distribution does not exist
2021-04-12 16:04:19,838 [DistributedPatchTask] DEBUG [com.ca.pmengine.infrastructure] - releaseSession(): returning session to pool
2021-04-12 16:04:19,838 [DistributedPatchTask] ERROR [com.ca.pmengine.decision] - Error processing Distributing Patch CA - Win 7 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1604.00 {2f32801a-d88d-4dcb-ae1b-5c229aa01d5f}

Environment

Client Automation - All versions.

Cause

A Patch is in Distributing status but the SD Job distribution container does not exist anymore in DSM Explorer.

Resolution

Execute following SQL Query on mdb database :

usd mdb

update ca_install_package
set status=13
where status=9
and ipkg_name='CA - Win 7 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1604.00'

 

Replace 'CA - Win 7 Post SP1 64Bit x64 OS Only - FULL Security Rollup v1604.00' by the patch name with problem.