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?