# Java Exception Missing value for query parameters {param\_name} even though it's provided? **URL:** \ **Category:** Ignition\ **Created:** [September 1, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669 "2023-09-01T12:47:25Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 1, 2023, 12:47pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/1 "2023-09-01T12:47:25Z")
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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/e/8ed1602b81c72598e3d1850b86139344995ea139.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 1, 2023, 12:51pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/2 "2023-09-01T12:51:09Z")
Type coercion? Data type says string, the expression you have is providing an int. I would expect that to work, but maybe? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 1, 2023, 12:51pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/3 "2023-09-01T12:51:34Z")
> [@nminchin](#): > > i've tried both `100` and `"100"` See here. I've also tried `toStr(100)` and referencing a parameter as well (with `toStr` wrapped around it). I'm a bit confused... ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 1, 2023, 12:53pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/4 "2023-09-01T12:53:34Z")
Save the project? Relaunch the designer? ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 1, 2023, 12:55pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/5 "2023-09-01T12:55:14Z")
Relaunched, same thing ☹ It works in the Named Query editor in the test tab ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 1, 2023, 12:57pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/6 "2023-09-01T12:57:01Z")
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 😆 ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [September 1, 2023, 1:02pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/7 "2023-09-01T13:02:29Z")
> [@paul-griffith](#): > > You're giving me flashbacks to my days in support, Nick 😆 Haha "try this!" "nope" "what about this!" "hmm, sort of but nah" " 🤔" 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` 😕 Whoopsie ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 1, 2023, 1:22pm UTC](https://forum.inductiveautomation.com/t/java-exception-missing-value-for-query-parameters-param-name-even-though-its-provided/78669/8 "2023-09-01T13:22:00Z")
Well, that error message sucks if that was truly the root cause, so that's still something for us to fix.