[bug-13183] named query error when in folder

using: b2019031702 on windows 10

Today I noticed if I create a named query in a folder I receive the below error.
If I move the same query to the root of named queries it works.

query used on both NQ: select ‘Hello World’
db connector: MSSQL JDBC 4.2

error:

11:27:28.018 [QueryExecuter 3] WARN DesignerNamedQueryManager - Did not find query NewFolder/test in project resources.
11:27:28.018 [QueryExecuter 3] WARN DesignerNamedQueryManager - Did not find query NewFolder/test in project resources.
11:27:28.072 [AWT-EventQueue-0] ERROR com.inductiveautomation.factorypmi.application.binding.AbstractPropertyAdapter - null
java.lang.Exception: Error running query:
com.inductiveautomation.factorypmi.application.gateway.NQuery@5ff0bdc5@0ms
On: Main Window.Root Container.Power Table.data
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:309)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.inductiveautomation.ignition.client.gateway_interface.GatewayException: Error in named query
at com.inductiveautomation.factorypmi.application.gateway.NQuery.execute(NQuery.java:66)
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$Query.execute(QueryManager.java:657)
at com.inductiveautomation.factorypmi.application.gateway.QueryManager$QueryExecutor.run(QueryManager.java:306)
… 1 common frames omitted

Definitely not good - thanks for the report.

This issue was fixed in the build that was uploaded today (3/20). Please let us know if you continue to see this behavior after upgrading.

1 Like

Working now, thanks!

1 Like