SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

MDS: A Database Error Has Occurred

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

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.


Leave a comment on the original post [blogs.lessthandot.com, opens in a new window]

Loading comments...