Load Data Warehouse - Incremental job times out intermittently
Article ID: 201208
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
- Drop the current DWH db in PROD
- Restore the DB from the base file from $clarity/database/backups
- Run Full Load DWH. Run Incremental
Rebuilding the database from a blank template fixed the issue with intermittent timeout
Feedback
Yes
No
Powered by
