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.
Release : 16.1.1
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.
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.