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, 16.4.0,16.4.1

Cause

DE178255 and DE186379 

Resolution

Fixed in

• Clarity 16.4.2
  
  
• Clarity 16.3.3 Patch 4 (16.3.3.4)

Workaround: 

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