DWH Instantaneous Sync not processing data
search cancel

DWH Instantaneous Sync not processing data

book

Article ID: 448764

calendar_today

Updated On:

Products

Clarity FedRAMP Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The DWH Instantaneous Sync is not processing any data. When looking at the DWH_ODF_INST_CHANGES table no data is being processed. The table gets populated, but data is not being processed.

Resetting the DWH Sync does not seem to be working either. 

Environment

Clarity 16.4.2

Cause

The DWH Instantaneous Sync job was locked on the PRLOCK table.

Resolution

Follow the steps below to fix the issue.

  1. Go to: http(s)://<server>/niku/nu#action:security.locks
  2. Look for a DWH Synchronizer Lock
  3. Select the lock > Clear Locks
  4. Go to Clarity Classic - Administration - System Settings
  5. Disable DWH Sync by disabling the toggle "Enable Instantaneous Sync", Save
  6. Run Load DWH Full job to successful completion
  7. Then enable DWH Sync back again
Powered by Wolken Software