search cancel

Load Data Warehouse - Incremental job times out intermittently

book

Article ID: 201208

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Our Load Data Warehouse - Incremental job is not stable. Sometimes it works fine, sometimes it times out.

The Full Load is running well. We are on MSSQL 

Environment

Release : 15.8.1

Component : CA PPM DATA WAREHOUSE

Resolution

  1. Drop the current DWH db in PROD
  2. Restore the DB from the base file from $clarity/database/backups
  3. Run Full Load DWH.  Run Incremental

Rebuilding the database from a blank template fixed the issue with intermittent timeout