DWH Sync is hanging - Reset DWH Sync

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

DWH Sync is hanging, other DWH jobs such as Load DWH - Full are in Waiting or Scheduled state and data is not getting updated

Environment

Clarity 16.3.3 +

Resolution

• DWH Sync is incompatible with Load DWH, so when DWH Sync is hanging, Load DWH will be in Waiting state and will not be running as per design. 
• If DWH Sync is hanging for a long time, it can be reset.

To reset the job, do the below in UI:

Basic Reset for DWH Sync:

1. Go to Clarity Classic - Administration - System Settings
2. Disable DWH Sync by disabling the toggle "Enable Instantaneous Sync", Save
3. Run Load DWH Full job to successful completion
4. Then enable DWH Sync back again

This should work to reset the DWH Sync and get back to process.

If you have still issues after doing the above, engage with your DBA and perform the below expanded steps:

Expanded Steps to Reset DWH Sync:

1. Go to Clarity Classic - Administration - System Settings
2. Disable DWH Sync by disabling the toggle "Enable Instantaneous Sync", Save
3. Remove the process DWH_SYNC_SP on the database
4. Restart BG
5. Run Load DWH Full job to successful completion
6. Then enable DWH Sync back again