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 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 is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior 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:

Leave a Reply

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