Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
jtompkins
Creator
Creator

Adding updated rows for Full History objects to dimension

We just upgraded our development environment to 2022.05 SP 15. The "Adding updated rows for Full History objects to dimension" steps in the data mart processing of SCD2 dimensions does not include the VID column in the insert statement, which violates the non-null constraint on the tables, so processing always fails.

How does something like this get overlooked in QA testing?

Labels (1)
2 Replies
sureshkumar
Support
Support

Hello @jtompkins 

You've opened a support ticket for with us and will continue to work in the ticket.

 

Regards,

Suresh

jtompkins
Creator
Creator
Author

Still completely mind-boggling and frustrating how something as obvious as a primary key constraint gets overlooked in a release.