MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only to models that are deployed or created after SP1 is applied (models deployed or created before SP1 is applied are fine): When executing a staging entity load stored procedure (i.e. udp_[Model]_[EntityName]_Leaf) I get an error:

Msg 50000, Level 16, State 1, Procedure udp_FMD_RefFacilityStatus_Leaf, Line 1431
SYSERR207|Invalid column name ‘uda_314_8158′.

And I see someone has already reported this on Connect: SQL 2012 SP1 schema version 11.1.0.0 Staging Stored Proc for Entity returns SYSERR207|Invalid column name

It seems it also only applies when change tracking is enabled on the Code or Name attribute. ¬†This bug also applies if you start a batch via the MDS web UI (but it won’t display an error, it will just not transfer records into MDS).

The two solutions are:

1) Remove change tracking from Code and Name
2) Modify the staging stored procedure as documented in the above Connect item

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in MDS/MDM, SQLServerPedia Syndication. Bookmark the permalink.

One Response to MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

  1. Guido Arroyo says:

    This bug was fixed in MDS 2012 SP1 CU2. See KB Article: http://support.microsoft.com/kb/2917531/en-us

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>