Red Gate forums :: View topic - FieldMapping not valid for MatchingMappings
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

FieldMapping not valid for MatchingMappings

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Adamant22



Joined: 05 Aug 2011
Posts: 1

PostPosted: Fri Aug 05, 2011 10:12 pm    Post subject: FieldMapping not valid for MatchingMappings Reply with quote

Anyone ever seen this message?
This happens on the Mapping step when comparing the databases.

I ran SQL Compare first and the database structure is the same.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Aug 08, 2011 11:38 am    Post subject: Reply with quote

As far as I know, this exception should not happen in SQL Data Compare because it should prevent you from being able to map columns that can't be compared because of a difference in the datatype.

Usually I see this message coming from SQL Comparison SDK apps. If you are using DataCompare.Engine.dll, I'd suggest throwing in some logic to check the MappingStatus field of every column mapping before you proceed to the comparison phase.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Aug 08, 2011 5:26 pm    Post subject: Reply with quote

The problem turned out to be with Data Compare after all, and the fix was to create a new project. The old project had some outdated schema information after some column datatypes had been changed.

Normally this wouldn't cause a problem so I suspect maybe the project had been created in an older version of Data Compare, but I've got no way of checking that.
Back to top
View user's profile Send private message
kipb7



Joined: 08 Feb 2011
Posts: 13

PostPosted: Thu Aug 18, 2011 5:19 pm    Post subject: FieldMapping not valid for MatchingMappings. Reply with quote

I still get this error in SQL Data Compare 9.0.0.117

In the past, I've just created a new project. It is tiresome to re-discover the various settings I had set for comparing certain database pairs.
Perhaps the product could give a more descriptive message, such as which table or column, or what we can do about it?
Back to top
View user's profile Send private message
tschlarm



Joined: 28 Nov 2006
Posts: 15

PostPosted: Mon Jul 23, 2012 9:52 pm    Post subject: Reply with quote

This error is still present in 10.2.0.315.
Back to top
View user's profile Send private message
redkev



Joined: 07 Mar 2013
Posts: 1
Location: Wayne, PA

PostPosted: Thu Mar 07, 2013 9:31 pm    Post subject: Fix Found Reply with quote

We were receiving the same error and found that it was due to a single table that had changed schema and the comparison file no longer could reconcile the mappings. To fix, you can open the .sdc file in a text editor (I recommend Notepad++) and cut out the bad table nodes. Then you can open the file in RedGate, re-select the table, and re-compare. Hope this helps!

Thanks,
Kevin
Back to top
View user's profile Send private message
icecurtain



Joined: 18 Jan 2010
Posts: 10

PostPosted: Thu Jan 23, 2014 4:53 pm    Post subject: temp fix Reply with quote

I found and easier fix open,don't open by program but by SSMS select source and target the launch data compare it seems to create the project from there OK.

This caused a few hours of frustration.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group