Home Dashboard Directory Help
Search

SP1 domain based attribute with change tracking enabled causes SYSERR245 by GregGalloway


Status: 

Closed
 as Fixed Help for as Fixed


6
0
Sign in
to vote
Type: Bug
ID: 771245
Opened: 11/15/2012 7:27:45 AM
Access Restriction: Public
2
Workaround(s)
view
2
User(s) can reproduce this bug

Description

After applying SQL2012 SP1, if you have a MDS model which contains a domain based attribute with change tracking enabled, when you try to load data via the staging table, you get the error:

SYSERR245|Conversion failed when converting the nvarchar value 'YourValueHere' to data type int.
Details
Sign in to post a comment.
Posted by EthernetIP on 11/5/2013 at 1:20 PM
Ok, Just applied the updated, and it did NOT fix the issue.
Disabling Tracking on the Domain-Based Entity did, but that is not an option.
Posted by Microsoft on 1/30/2013 at 3:57 PM
Please see KB article
http://support.microsoft.com/kb/2790947
with link to download the update. Thank you for reporting or voting on the issue and your patience while we get the fix out.
Posted by Allxone on 12/4/2012 at 10:04 AM
I'm very disappointed by not having a temporary workaround. I had some troubles due to this bug and disabling Change Tracking is not an option for me. Looking at sp mdm.udpEntityStagingCreateLeafStoredProcedure I can see it is really a simple to solve bug, basically based on completely skipping the testing phase. Really strange it is included in a so called "highly tested service pack", probably MDS does not deserve so much attention by SQL Server testers.

Stefano
Posted by Microsoft on 11/27/2012 at 8:36 AM
Hi Greg,

Thanks for the feedback. We’re closing this issue as “Fixed” as we have identified the problem and will address it in the next post-SP1 cumulative update for SQL Server 2012.

Matthew
Sign in to post a workaround.
Posted by Sarang.Manohar on 4/8/2013 at 5:12 AM
Instead of changing the WHERE condition both the attributes may be converted to nvarchar to keep the overall condition intact.
Posted by GregGalloway on 11/15/2012 at 7:29 AM
Disable change tracking on all domain based attributes.
File Name Submitted By Submitted On File Size  
ChangeTrackingDbaBug.zip 11/15/2012 24 KB