| Author |
Message |
Adamant22
Joined: 05 Aug 2011
Posts: 1
|
 Posted: Fri Aug 05, 2011 10:12 pm Post subject: FieldMapping not valid for MatchingMappings |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6343
Location: Red Gate Software
|
| Posted: Mon Aug 08, 2011 11:38 am Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6343
Location: Red Gate Software
|
| Posted: Mon Aug 08, 2011 5:26 pm Post subject: |
|
|
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
kipb7
Joined: 08 Feb 2011
Posts: 13
|
| Posted: Thu Aug 18, 2011 5:19 pm Post subject: FieldMapping not valid for MatchingMappings. |
|
|
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 |
|
|
tschlarm
Joined: 28 Nov 2006
Posts: 15
|
| Posted: Mon Jul 23, 2012 9:52 pm Post subject: |
|
|
| This error is still present in 10.2.0.315. |
|
| Back to top |
|
|
redkev
Joined: 07 Mar 2013
Posts: 1
Location: Wayne, PA
|
| Posted: Thu Mar 07, 2013 9:31 pm Post subject: Fix Found |
|
|
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 |
|
|
|
