Task cannot be completed - Mapping

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Task cannot be completed - Mapping

Postby scotteb@mindspring.com » Sun Apr 28, 2013 11:48 pm

Using SQL Data Compare 10.2.3.5 on Win8, I opened an existing projected, that synchronized without error on 13 April 2013. A table change today was synchronized with SQL Compare. There are no differences in tables (but some in source db only).

When I attempt to compare, I am presented with a "Task cannot be completed" dialog with a X next to mapping. At the bottom of the dialog is the text "FieldMapping not valid for MatchingMapings.".

Of the twenty tables, all but one show a comparison key is set. The one table is "Not Set" (never has been as I do not wish to compare it). I have looked over the tables on the Mapping tab and all are mapped correctly.

I selected only one table, with one column, and receive same error. BTW, after error dialog closes, all tables are selected for compare - that is bad form; no need to do that if user has made selections. Additionally, any custom mappings I have made revert to use keys. But that is not my complaint.

I'd like to synch these databases, but not sure where to look (wish error message mentioned the able!). I created another project against two different databases on these servers and was able to compare.

Best,
Scott
scotteb@mindspring.com
 
Posts: 7
Joined: Wed Aug 13, 2008 5:02 pm
Location: Texas, USA

Postby Anu Deshpande » Mon Apr 29, 2013 10:46 am

Many thanks for your post and apologies for inconvenience caused.

The 'field mapping not valid for matching mapping' error is normally a result of a corrupt project file workaround for that is to create a new project file which you already done.

Was this project file quite old or was it copied over the network or something?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby scotteb@mindspring.com » Mon Apr 29, 2013 1:10 pm

The project was created and last used on 13 April 2013 on the local computer. I did create a new project and all is well.

In fact, it solved another issue which you should be aware of as I saw reports of it on the forum. When I would load the project, the 'retrieving schema' message would display 100s of times, for 4-5 minutes. The new project loads immediately.

Best,
Scott
scotteb@mindspring.com
 
Posts: 7
Joined: Wed Aug 13, 2008 5:02 pm
Location: Texas, USA

Postby Anu Deshpande » Tue May 07, 2013 4:54 pm

Glad its all working now!

Is there anything else you need my help with?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron