Issue with Contacts Synchronization between ITAM and CA SAM.

book

Article ID: 7082

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

In an environment where ITAM and CA SAM are integrated, when we  create contacts in ITAM they are not synchronized  into SAM. Companies and Cost Centers are coming into CA SAM. This was working before and no change have been done.

Cause

The issue was encountered due to huge number of records in arg_job_task table ~13 million.

Environment

ITAM 12.9 integrated with CA SAM

Resolution

We need to remove the table arg_job_task's rows for completed jobs (status='completed').

Run the script below on the mdb:

------------------------
DECLARE @BATCHSIZE INT
SET DEADLOCK_PRIORITY LOW;
SET @BATCHSIZE = 5000

WHILE @BATCHSIZE>0
BEGIN
-- IF @BSTOPATMAXTIME = 1, THEN WE'LL STOP THE WHOLE JOB AT A SET TIME...

DELETE TOP(@BATCHSIZE)
FROM arg_job_task
WHERE status='completed'

SET @[email protected]@ROWCOUNT

END
----------------------------------

Additional Information

The issue is fixed in ITAM 14.1