Error Writing Tag Values Using SQLTags Provider


I’m encountering a problem when trying to write tag values using a SQLTag Provider. I have a Realtime SQLTag Driving Provider running on a Linux server running Ignition 7.2.9. The tag providers are connecting to an Oracle database. I can create tags and write values on the gateway that is the driving provider. However, when trying to write tag values from a second gateway using a SQLTag provider the errors listed below are encountered and the values are not writter.

Is there something I am missing when configuring the Tag Provider?


Error returned by Designer:
Error writing to TestTag.Value: StatusCode[Severity=Bad,Subcode=Bad_InternalError,0x80020000]: Cannot coerce value ‘[0,Good]’ into type: class java.lang.Integer

The error displayed in the Console is:
java.lang.ClassCastException: Cannot coerce value
'[0,Good]' into type: class java.lang.Integer
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(
at com.inductiveautomation.ignition.common.TypeUtilities.toInteger(
at com.inductiveautomation.ignition.common.TypeUtilities.coerce(
at com.inductiveautomation.ignition.gateway.sqltags.providers.DatasourceTagProvider.internalWriteValue(
at com.inductiveautomation.ignition.gateway.sqltags.execution.AbstractTagDriver.write(
at com.inductiveautomation.ignition.gateway.sqltags.SQLTagsManagerImpl.write(
at com.inductiveautomation.ignition.gateway.project.ProjectSettingsCache$ProjectDefaultTagManagerFacade.write(
at com.inductiveautomation.ignition.gateway.servlets.gateway.functions.SQLTags$
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
at java.util.concurrent.ThreadPoolExecutor$

If you can, try upgrading to the latest version, 7.2.11.

It looks like you have a string that is trying to coerce into an integer.

Check to make sure that your second gateway is just a provider and not a driving provider.

If the upgrade doesn’t help, give tech support a call so we can try to help you further.