Query binding - query not found (Perspective)

Ignition
1

Hello,

we just had a strange issue. After saving one query binding in perspective broke (the saving did not contain anything related to the binding).

The named query is a simple select query with 2 params. After saving, the result was an error: Named query could not be found (is saved in the same project). In the dropdown the query still appeard, but even after selecting an other query ( that worked) and reselecting the query, it still said: query not found.
Solution was to change the name of the query - save - and change it back and save again. It is good, that it works again, but what could have caused this issue? Due to the fact it was on our live system, it was not great...
We are using version .28
Thanks, Thomas

2

Without knowledge on Named queries I guess it could be some special character on the named query name that interfere with normal program work.

3

Hi Alejandro,
sadly not that easy. There are definitly no special characters in the query (that already worked fine for about 2 years and now also works again with the old name)

1 Like
4

Did you have a query with the same name in a folder as well as at the root? Known bug, already fixed in later versions.

1 Like
5

That brought quite light into the situation.
Can you tell me, in what Version that was fixed under what bullet point i could search in the patchnotes? Actual we are planning to update the Gateway to solve this issue and get all the quality of life features in this project.
Greetings, Thomas

6

8.1.37:

1 Like
7

If you are using auditing, you definitely want to go all the way to v8.1.43, or your audit database will be spammed by tag writes.

1 Like
8

Thanks for the additional information!