Data Warehouse VW_REQUEST_STATE_HISTORY only shows changes from full ETL date, DCC 5
Hello, We dropped and recreated our data warehouse to repair a number of issues with corrupt data. All DCC 5.0.2 ETLs works fine now, except our RIDW.VW_REQUEST_STATE_HISTORY only goes back to the date we ran the full ETL last week. There are 346k rows in the RICALM.REQUEST_HISTORY with dates going back to the beginning of CLM, so surely the needed data for state history changes is in there. I've done this before for another client and they maintained work item state history, it just took forever to run the jobs (as expected). That may have been Insight's DM ETL though. Is the view table improperly constructed or is DCC missing some key information? We'd like our historical state information, I'll open a PMR if there isn't something obvious we're missing. |
