Hi Wayne,

That SQLException error is a limitation within Microsoft SQL Server and will come up if you have too many identifiers and constants in your query. MS SQL has a limit of 65,535.

More details: https://support.microsoft.com/en-us/help/913050/error-message-when-you-run-a-query-in-sql-server-2005-internal-error-a

The only way to get around this is to work in smaller batches when it comes to your queries. Looking at that SQL that was within your log, it looks like you're doing a lot of CASE statements, which explains why you're hitting this limit.

Regards,

Jon