Creation of Job Container Failing

Products

• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

After Migration of DM, then SS, from ITCM 14.0 GA to ITCM 14.0.SP2 (14.0.2) Staging of SW packages is no longer possible.
Trying to stage a SW package From DM to a Scalability Servers results in error message that the Job Container could not be created.
Error in Windows Event Log is as follows (translated from German): Jobcontainer ***** failed (ca://usd/system).
Exception:
Name = VersionError
Comment = read: usd_actproc Location = T@:ps\entityc.cxx:486
C@:ps\collection.cxx:287 T@:ps\collection.cxx:306
C@:FoldJob\jobcont.cxx:7340
T@:FoldJob\jobcont.cxx:7343
C@:FoldJob\jobcont.cxx:7386 

Environment

ITCM 14 SP2 upgraded from 14 GA
However, this may happen for other versions also.

Cause

There is a data corruption within the MDB

Resolution

Run the following queries on MDB to cleanup the corruption AFTER you have a current and valid backup of MDB

--------------------------------------------------------------------------------------------------------------
Use MDB
update usd_applic
set activity=0x00000000000000000000000000000000
where activity <> 0x00000000000000000000000000000000
and activity not in (select objectid from usd_activity)

delete from usd_applic where actproc not in ( select objectid from usd_actproc)
delete from usd_applic where target not in ( select objectid from usd_v_target)
---------------------------------------------------------------------------------------------------------------

Please make sure you have a valid MDB backup before executing the above queries.