Multiple execution of procedure CLARITY_DWH_SYNC_SP() seen in database

Products

• Clarity PPM SaaS
• Clarity FedRAMP
• Clarity PPM On Premise

Issue/Introduction

After enabling Instantaneous Sync under Administration → System Options → Data Warehouse Options, instances have been observed where the stored procedure CLARITY_DWH_SYNC_SP() executes multiple times concurrently in the database.

Steps to Reproduce: 

1. Enable Instantaneous Sync under Administration → System Options → Data Warehouse Options
2. Create a object and attributes and Include in the Data Warehouse
3. Create few thousand instances of the newly created object 

Expected Results: Instant Sync feature should move the data to DWH as expected 

Actual Results: It has been observed that 

• Instantaneous Sync is running slow and it was determined by monitoring the below tables
  • DWH_ODF_SCHEMA_CHANGES  - Tracks Schema Changes to Process
  • DWH_ODF_INST_CHANGES  - Tracks Instance Changes to Process
  • DWH_ODF_INST_CHANGES_STAGING -  Instance Changes Currently Being Processed
  • DWH_ODF_INST_CHANGES_ARCHIVE - Archive of Instance Changes Processed
• Multiple instance of the stored procedure CLARITY_DWH_SYNC_SP() was executing

Environment

Clarity 16.3.3

Cause

DE178255

Resolution

DE178255, in review by Engineering

Workaround: 

• On Premise Customers: Clear the PID running for procedure CLARITY_DWH_SYNC_SP() after monitoring the Instantaneous Sync  as documented in KB