# Script Over-running

**URL:** <https://forum.inductiveautomation.com/t/script-over-running/100292>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [December 29, 2024, 3:19pm UTC](https://forum.inductiveautomation.com/t/script-over-running/100292 "2024-12-29T15:19:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christopher\_Brunner](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@Christopher\_Brunner](https://forum.inductiveautomation.com/u/Christopher_Brunner)\
**Post date:** [December 29, 2024, 3:19pm UTC](https://forum.inductiveautomation.com/t/script-over-running/100292/1 "2024-12-29T15:19:05Z")

</div>

I am working in Ignition Vision 8.1 ....

I have a pop-up window with a number of custom properties. The custom properties are linked to fields by way of indirect parameters.

One of the indirect custom properties is an integer. This integer is run through a named query to retrieve a text value for a text label.

On initial opening of the screen, I receive a failure (every time)

```python
java.lang.Exception: Named Query returned no rows on component: Motor Module Diagnostics.Root Container.Error Text.text
	at com.inductiveautomation.factorypmi.application.binding.NamedQueryAdapter.handleQueryReturnedNoRows(NamedQueryAdapter.java:284)
	at com.inductiveautomation.factorypmi.application.gateway.QueryManager$HandleNoRowsTask.run(QueryManager.java:518)
	at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
	at java.base/java.security.AccessController.doPrivileged(Unknown Source)
	at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)

Ignition v8.1.44 (b2024102210)
Java: Azul Systems, Inc. 17.0.12

```

The query is successfully run, and the data is displayed - but I am trying to understand why I get the failure. I think it is because of when the script is being run. I have numeric values for 0, as well as any other integer that may be in custom property. I suspect the scripts are running in a different order than I want - any suggestions?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 29, 2024, 3:27pm UTC](https://forum.inductiveautomation.com/t/script-over-running/100292/2 "2024-12-29T15:27:40Z")

</div>

Is the integer the only parameter used in the NQ? Or if others, are they all available in properties? If so, don't use a scripted named query, but a named query binding instead.

Be aware that properties can have a null initial value, briefly, in some cases, and that can cause no match in a query that uses it.

---

<div class="post-metadata">

**Author:** ![Christopher\_Brunner](https://avatars.discourse-cdn.com/v4/letter/c/e8c25b/32.png) [@Christopher\_Brunner](https://forum.inductiveautomation.com/u/Christopher_Brunner)\
**Post date:** [December 29, 2024, 7:15pm UTC](https://forum.inductiveautomation.com/t/script-over-running/100292/3 "2024-12-29T19:15:33Z")

</div>

The integer is the only parameter in the named query. I have the query bound to the text label - not directly scripted in a screen load. Does this follow your suggestion?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 29, 2024, 11:34pm UTC](https://forum.inductiveautomation.com/t/script-over-running/100292/4 "2024-12-29T23:34:53Z")

</div>

Hmmm. Yes.

Have you set the NQ binding to return a scalar? If so, did you set a fallback value?