Index Out of Range, with the latest version?

JohnES

All of a sudden I started getting an Index Out of Range error when doing a SQL Compare. Does anyone have any idea how I might be able to get past this?

I just did an update yesterday, to 13.6.7.8464. Before that everything worked fine, and I've never come across this error before. 

Russell D

Its possible there is a problem in the parser, did you send in an error report? Can you share some snapshots?

JohnES

I just encountered this issue again. This time I sent a report, and referenced the title of this thread in the body of the problem description.

Jessica R

Hi @JohnES,

Just updating the forum post here with the progress from the ticket. This issue appears to happen when you have the following:

1. SET ANSI_NULLS ON at the end of a proc (with no preceding GO statement)
2. "Ignore SET QUOTED_IDENTIFIER and SET ANSI_NULLS statements" and "Add WITH ENCRYPTION" are both enabled
3. "Ignore WITH ENCRYPTION" disabled

We are looking into this from our side.

Thanks again for your help, John!

JohnES

You're Welcome Jessica. 

Thank You for your help sorting this out.

Jessica R

Hi @JohnES !

This issue is now resolved in the latest frequent release update, SQL Compare 13.6.8.8602. You can get this from Help>Check for updates (you need to make sure Help>Configure frequent updates is turned on).