Java Exception Missing value for query parameters {param_name} even though it's provided?

Ignition
1

Am I missing something obvious? I've provided a value for max_count (i've tried both 100 and "100") but keep seeing this error...
DB: PostgreSQL

image
image1023×461 31.6 KB

2

Type coercion? Data type says string, the expression you have is providing an int. I would expect that to work, but maybe?

3

See here. I've also tried toStr(100) and referencing a parameter as well (with toStr wrapped around it). I'm a bit confused...

1 Like
4

Save the project? Relaunch the designer?

5

Relaunched, same thing :frowning: It works in the Named Query editor in the test tab

6

Check the raw view JSON? Swap the named query on use to another, commit the binding, swap it back and set it back up?

You're giving me flashbacks to my days in support, Nick :laughing:

7

Haha "try this!" "nope" "what about this!" "hmm, sort of but nah" " :thinking:"

Oh weird. When I bind any of the 2 parameters to something other than a static value, it fails with the same error. When I set them to integers, it works... Let me keep playing with it

Edit:
Ok, my bad... I was binding the machine_id parameter to a session prop whose value is None :confused: Whoopsie

8

Well, that error message sucks if that was truly the root cause, so that's still something for us to fix.

2 Likes