How to cancel action in roadmap - Sync In Progress. This scenario is temporarily locked for editing
search cancel

How to cancel action in roadmap - Sync In Progress. This scenario is temporarily locked for editing

book

Article ID: 261560

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

You started a Sync action for one Roadmap ). but the process has been running for over 4 hours, you don't see the errors in the logs and you don't know how to cancel this process.

 

Environment

Release : 16.1.1

Resolution

To cancel the job, go to your Scheduled Jobs and look for any jobs for 'RDM_ITEMS_SYNC'.

Cancel the one that has been running for too long.

Retry the Roadmap Sync after.

Additional Information

Run query:

select * from cmn_sch_jobs
where name = 'RDM_ITEMS_SYNC'

To review what job instances need to be removed.

1. Run

SELECT JOBS.ID FROM CMN_SCH_JOB_DEFINITIONS DEF,
          CMN_SCH_JOBS JOBS,
          CMN_ATTRIBUTE_VALUE_SETS VAL_SET,
          CMN_BUSINESS_OBJECTS CBO,
          CMN_ATTRIBUTE_VALUES ATTR_VAL,
          CMN_ATTRIBUTES ATTR
          WHERE DEF.ID = JOBS.JOB_DEFINITION_ID
          AND DEF.JOB_CODE IN ( 'RDM_ITEMS_IMPORT','RDM_ITEMS_SYNC' )
          AND JOBS.STATUS_CODE IN ('PROCESSING', 'SCHEDULED', 'NOT_SCHEDULED', 'PAUSED', 'BPM_PENDING', 'WAITING')
          AND JOBS.ID = VAL_SET.BUSINESS_OBJECT_INSTANCE_ID
          AND VAL_SET.ID = ATTR_VAL.ATTRIBUTE_SET_ID
          AND ATTR_VAL.ATTRIBUTE_ID = ATTR.ID
          AND CBO.TABLE_NAME='CMN_SCH_JOB_DEFINITIONS'
          AND CBO.ID=VAL_SET.BUSINESS_OBJECT_ID  AND ATTR.COLUMN_NAME LIKE 'scenario_id'

The query above will return the ID of the job that should be removed

3. Go to Home > Reports and Jobs > Jobs

4. Go to Scheduled Jobs

5. Filter by 'Job Type' = Roadmap Items Sync
or Filter by 'Name' = 'RDM_ITEMS_SYNC'
and filter by the Job ID obtained above.

6. For the 'Job ID', select and cancel the job instance.  It can show up as 'Not Scheduled'.

7. Delete the 'cancelled' job instance.

The roadmap should now be fine.

As a workaround, make a copy of the problem roadmap if the above is not able to be taken for the immediate time.