Error doesn't tell what table: "Error mapping index key..."

kdmoyers

(1st day using redgate data compare)
I'm comparing two versions of a database (only a few minutes apart) of some 2500 tables.

I get this error: Error mapping index key - try using clustered index as comparison key
The More Details window shows exactly the same thing.

Notice, it does not say what table it's complaining about.

It automatically rejects several hundred tables, so it's only comparing 1500 tables.  
Still, that's a lot of hunt-and-peck to discover which table it has a problem with!

Any advice?

kdmoyers

(I should add that I'm using 15.0.9.23488 Professional, and that this comparison was between a live database and a backup of that database made a few minutes earlier.)

Kurt_M

Hi @kdmoyers

You may need to consult the log file to determine where it's actually failing. I would recommend setting the logging to verbose, replicate the error, then inspect the log file to see if it lists which table its failing on. Information on that can be found here:

https://documentation.red-gate.com/sdc/troubleshooting/logging-and-log-files

You may wish to try the latest version of SQL Data Compare as well, as 15.0.9 is a few versions behind now:
https://download.red-gate.com/checkforupdates/SQLDataCompare/SQLDataCompare_15.2.0.24040.exe

If you need assistance, please upload the log file to here, or send it through to support@red-gate.com. 

kdmoyers

OK, upgraded to 5.2 and set logging to verbose, ran again, same error.  
I attached the log file.   It seems to show that my database has a couple views that don't parse, but it does not seem to be too troubled by that.  But there are several other |Error lines that I don't understand.
Can you assist with determining what I need to fix to get this going?
Thanks!!

kdmoyers

(I checked those views, they actually do parse and execute just fine.  Not sure what it is complaining about there.)