Index was beyond the scope of the array
amobbs
Posts: 3
Hi,
I am running SQL Data Compare 9.1 and have been experiencing an issue with a single table during data comparison. I keep getting an error message when it starts comparing the data in the table that reads "index was beyond the scope of the array".
I have attempted the following:
1. I have downloaded the trial of the latest version to see if that solves it, but it doesn't.
2. I have enabled verbose logging but the log file shows no information with regards to the error.
3. I have compared the schema and structure using SQL Compare and made sure that both databases are identical - still no fix.
4. I have enabled and disabled various combinations of options before trying to compare that single table to no avail.
If anyone knows what might cause a single table to throw this error I would really appreciate the help in resolving it.
Thanks.
P.S. I am comparing a local database to a backup of a live server database. I have recreated the backup multiple times to no avail.
I am running SQL Data Compare 9.1 and have been experiencing an issue with a single table during data comparison. I keep getting an error message when it starts comparing the data in the table that reads "index was beyond the scope of the array".
I have attempted the following:
1. I have downloaded the trial of the latest version to see if that solves it, but it doesn't.
2. I have enabled verbose logging but the log file shows no information with regards to the error.
3. I have compared the schema and structure using SQL Compare and made sure that both databases are identical - still no fix.
4. I have enabled and disabled various combinations of options before trying to compare that single table to no avail.
If anyone knows what might cause a single table to throw this error I would really appreciate the help in resolving it.
Thanks.
P.S. I am comparing a local database to a backup of a live server database. I have recreated the backup multiple times to no avail.
Comments
Unfortunately when you get these types of errors (object reference not set, index out of the bounds of the array), it's not possible to say what the root cause of these are without hard-core debugging.
You may want to try starting a new project from scratch using the File->new menu item.
Hopefully that will prevent this from happening.
Otherwise let me know and we'll have to go in deeper.
I downloaded a trial of dbForge from DevArt and it has compared the table without throwing an error, except I see that one line is missing from the comparison they provided and I am not sure why. I am looking into this further to see whether that one line might be the issue, but I am pretty convinced this isn't a schema problem.