Scheduled Integration Sync job canceled - Integration is no longer functioning and “Sync Children of Parent” is no longer available for selection inside the job

Products

• Clarity PPM SaaS

Issue/Introduction

In Clarity Dev and Prod, the Synchronize Mapped Information job was cancelled and it will not resume running status (error indicates the job is completed though).

It is not clear on why the job cancellation or how to rectify it.

Running an immediate instance of this job will show completed immediately but does not seem to complete the integration.

Additionally, it appears a field called “Sync Children of Parent” is no longer available for selection inside the job.

Environment

Release : 16.1.0

Cause

The existing and scheduled integration sync jobs (with 'sync children of parent' setting selected) were cancelled upon the upgrade to 16.1.0.

Prior to the upgrade to 16.1.0, scheduled integration sync jobs (with 'sync children of parent' setting selected) were performing as expected.

The 'sync children of parent' setting was moved to the main Integration Mappings list view page (from the individual job definition page in Classic)

Resolution

This is an expected Upgrade Impact where scheduled (via Classic) integration sync jobs (with 'sync children of parent' setting selected) will be systematically cancelled upon the upgrade to 16.1.0.

 

To confirm cancellation

Run the following query against impacted Clarity schema:

select * from Cmn_Sch_Jobs
where STATUS_CODE = 'CANCELLED'
order by last_updated_date desc

 

If results show scheduled job was canceled by user 'Admin' --> the Clarity 16.1.0 upgrade script recognized a job definition change (meaning the 'sync children of parent' setting was no longer defined the Classic job definition) and the 'Admin' account canceled the associated jobs.

 

Change Impact and Upgrade
Synchronized Mapped Information job Properties Change

 

After the upgrade, the Admin must navigate to each Integration Mapping definition (MUX>Administration>Integrations) and select the 'sync children of parent' option.