SCSM 2012 R2 - Data Warehouse error

Question

All 3 of the Load jobs produce multiple errors, all of which have this in common:

"“UNION ALL view [....] is not updatable because a partitioning column was not found.”

I have verified that each table mentioned does in fact have a Primary Key, Foreign Key, and a Check constraint.

I also ran this query, DBCC CHECKCONSTRAINTS, against DMDWDataMart, DWDataMart, DWRepository, and OMDWDataMart, but no errors were returned.

Not sure which 'partitioning column' it's looking for?

Answer 1

Hi @Chris.Pierce ,

maybe this is helpful:
https://learn.microsoft.com/en-us/answers/questions/182935/scsm-2012-sp1-data-warehouse-jobs-failed-with-erro.html

or this one:
https://social.technet.microsoft.com/wiki/contents/articles/51311.scsm-2012-troubleshooting-load-cmdwdatamart-failed-job-module-s-failed-because-a-primary-key-was-not-found.aspx

and another one:
https://community.cireson.com/discussion/5828/data-warehouse-jobs-broken

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten