AnsweredAssumed Answered

Data Warehouse Completes, but is Incomplete

Question asked by Robert Ensinger on Aug 15, 2017
Latest reply on Oct 27, 2017 by Dale_Stockman

Hi folks.

    We've noticed for a couple weeks now that our Data Warehouse is occasionally missing data, specifically from the DWH_INV_ASSIGN_PERIOD_FACTS table. In the example below there are no rows for a whole project.

 

I can't determine a pattern yet. I do observe that our hourly Incremental Updates that usually take between 30 & 40 minutes are showing between 5 & 10 minutes as 'Complete'. We are 14.3 Fixpack 9 MSSQL 2012.

 

I've begun digging here in the forums. Any insight from others is greatly appreciated.

Outcomes