Data Warehouse jobs broken
Apparently there was an issue with at least certain versions of SCSM 2012 where the end of time as far as the data warehouse was concerned was 11:59 PM on 11/30/20.
I was able to find this discussion which seemingly had a fix in it https://docs.microsoft.com/en-us/answers/questions/182935/scsm-2012-sp1-data-warehouse-jobs-failed-with-erro.html?page=1&pageSize=10&sort=oldest
However, I still have a number of Cireson DB items that are not updated. I don't fully understand the script that was run in step 3. More specifically, it looks like it was using a variable for all of the impacted table names but that did not seem to hit multiple Cireson DB items related to asset management. I am still seeing these items in the logs on my data warehouse management server.
ETL Module Execution failed:
ETL process type: Load
Batch ID: 1234263
Module name: LoadCMDWDataMartCiresonSupportContractRelatesToVendorFact
Message: UNION ALL view 'CMDWDataMart.dbo.CiresonSupportContractRelatesToVendorFactvw' is not updatable because a partitioning column was not found.
In the message the table name varies slightly, as far as I can tell though it is always something similar.
Anyone able to shine some light on what I need to do to get this corrected on these other DB items?