How to remove Management Profile stale jobs from CCA.

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

How to remove Management Profile stale jobs from CCA?

Background:

Sometimes, the Management Profile job takes too long to finish or for some reason keeps in running state forever

Environment:
CCA 12.8.x
Instructions:

Here are the steps to be followed:

1.   Login into CCA UI and disable the scheduling of Management Profiles for some time, at least till the completion of this test. For quick glance to verify the scheduled Jobs go to the Jobs tab and Filter on the Jobs status which are Scheduled and Running, take a screenshot. Now come to the Management Profiles breadcrumb. Edit the Management profiles and unscheduled them.

 

2.   Login into CCA database and execute the queries 

select * from ACMQ_BLOB_TRIGGERS

select * from ACMQ_TRIGGERS

select * from ACMQ_JOB_DETAILS

 

3.   Identify the stale Jobs which are still available in the tables of step2.

 

4.   To delete the stale jobs you need to stop the CCA Server as well as Grid services first.

 

5.   Execute the delete queries in the following order

delete from ACMQ_BLOB_TRIGGERS where trigger_group like '%Provide the management profile name which you got in select query%'

delete from ACMQ_TRIGGERS where trigger_group like '% Provide the management profile name which you got in select query %'

delete from ACMQ_JOB_DETAILS where job_group like '% Provide the management profile name which you got in select query %'

 

6.   Also verify the below 

select * from acm_grid_operation where operation_state in (1, 2, 4, 6, 8)

 

Operation states

  1. dispatched but not started
  2. running
  3. being cancelled
  4. cancelled
  5. aborted
  6. waiting on dependencies

 

7.   Delete the stale job entries using the query 

delete from acm_grid_operation where operation_state in (1, 2, 4, 5, 6, 8)

Note : If the Database is oracle please commit; after delete query

 

8.   Restart the CCA Server and Grid Services 

 

9.   Now Reschedule the Management profiles of step1

Additional Information:

**Please be cautious when executing the steps