Stumped...Remote Tag Provider & SQL Query Tags

Ignition
1

Not sure if I haven't had enough coffee, or if I just plain don't know...but I'm stumped.

Local Machine with Ignition & SQL Server
Central Server with Ignition & SQL Server

Gateway Network is configured for the Central Gateway to have access to Local Gateway tags, etc.

I have a handful of SQL Query tags that are being provided by the Local Gateway that are using the Local SQL Server for database reference. However, when I am on my Central Gateway project the tags are not valid because the database configuration is not the same between the two gateways.

Am I wrong in thinking that the gateway network should just pass the tag value regardless if the Central Gateway has a connection setup to the Local Database?

The specific error in properties is "Error_TypeConversion"

Thanks

2

You're not wrong, which is making me think the source of the error is not what you think it is.

What are the Ignition versions on both sides? Any further details on the error itself? Stacktraces from the logs?

1 Like
3

Well; it was less of a coffee issue and more of me being an idiot issue.... Table was never setup in the local database. Tags were reporting as "Null" and the numerical indicators were showing "Error_TypeConversion" because of the String value discrepancy.

1 Like