I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:
515: A database error has occurred. Please contact your system administrator
Too bad I am the system administrator on that machine…
Anyway, after some searching it came out the MDS stored procedure udpEntityStagingAllBatchesByModelGet throws a bit of a temper tantrum if one of the batch tags used in the staging process of a leaf member is NULL. You can check this in the table mdm.tblStgBatch.
Simple delete the offending batches and you’re good to go!
DELETE FROM mdm.tblStgBatch WHERE BatchTag IS NULL;
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…