SQL Error overlays that don't make sense

Ignition
1

Note: I am using Ignition v7.9

I am getting overlays indicating SQL Error, but there is no apparent reason why this should be happening. The query is correct, and the expected value is being returned. Other similar queries don't have this problem.

When I select the "Overlay Opt-Out" the overlay is removed, then I de-select the "Overlay Opt-Out" and the overlay does not return.

This has worked fine for years with "local" SQL Server databases, the only difference here is that I am connecting to an Azure SQL database for the first time. I can switch to a local database and the overlay issue is gone. Back to Azure and the overlays return. Not sure if the Azure SQL database is a red herring.

Any thoughts on what could be causing this would be appreciated.

Thanks,
Bob

2

Check this thread on legacy query bindings and see if that is what you are experiencing.
Vision client issue - Ignition - Inductive Automation Forum

3

I found the resolution in my case.

It seems it was caused by a dash "-" in the component name which was also being used for the tag name. Replaced the dash with an underscore "_" (which was vaguely familiar) and the issue went away.