We need to revise the problem with the Dashboard --> Procces Report --> Offline Procceses because we can't watch them.
Sometimes this work correctly but the most part of time the proccesses don't load in this dashboard. We noticed when we restart the NAC service we see some new records getting move to offline processes.
The Purging service of RA is single threaded, so only one instance of the purging process may be executed simultaneously. This service does the following actions:
Release : 6.6
DB Type: Oracle
Component : CA RELEASE AUTOMATION CORE
Steps to follow
1: Please run the below query against the RA DB and it will improve the performance of the purging service and improves online jobs removal operation. The below script will create a DB index.
# FOR ORACLE DECLARE L_INDEXES_COUNT INTEGER; BEGIN SELECT COUNT(*) INTO L_INDEXES_COUNT FROM USER_INDEXES WHERE UPPER(INDEX_NAME) = UPPER('IX_EXEC_FLOWS_JOB_ID'); IF (L_INDEXES_COUNT = 0) THEN EXECUTE IMMEDIATE 'CREATE INDEX IX_EXEC_FLOWS_JOB_ID ON EXEC_FLOWS(JOB_ID)'; END IF; END; /
2: The restart of NAC is not required after index is created.
3: This new index will help purging service to remove copied online execution jobs and this will help to stabilize the online/offline processes report.
4: To check the progress of the offline job movements can be tracked running the following query. The amount returned by this query must go down.
select count(e.id) from EXECUTION_JOBS e where e.major = 'Final'