Red Gate forums :: View topic - Task cannot be completed - Mapping
Return to www.red-gate.com RSS Feed Available

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

Task cannot be completed - Mapping

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
scotteb@mindspring.com



Joined: 13 Aug 2008
Posts: 7
Location: Texas, USA

PostPosted: Sun Apr 28, 2013 11:48 pm    Post subject: Task cannot be completed - Mapping Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Mon Apr 29, 2013 10:46 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
scotteb@mindspring.com



Joined: 13 Aug 2008
Posts: 7
Location: Texas, USA

PostPosted: Mon Apr 29, 2013 1:10 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Tue May 07, 2013 4:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
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