Load Data Warehouse Incremental stuck on dwh_x_plan_act_per_facts (PostgreSQL) and creating high bloat and temp usage on GCP
Expected Results: The job to run successfully and without issues
Actual Results: The job is hanging, runs much slower than usual, and creates excessive bloat, taking too much database temp space
Release : 16.0.1 with PostgreSQL
Component : Clarity Data Warehouse
Workaround: Select "Include only financial Plan of Record" in System Settings if possible / or just run Full Load of Data Warehouse
This is DE64425, reviewed by Engineering - suggested solution: Load DWH Enable Actuals Plan Toggle for Financial Period Plan Facts