# Root Container Error but no Message

**URL:** <https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [April 2, 2019, 11:33pm UTC](https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806 "2019-04-02T23:33:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [April 2, 2019, 11:33pm UTC](https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806/1 "2019-04-02T23:33:43Z")

</div>

I have a sql property binding error on my Root Container with no message.  
I have gone through everything associated with the Root Container and i can not find it.  
No errors while in Designer this (see below) only shows up on the client screen.

![RootContainer%20Error_No%20MSG](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/6bf2d179db13530034dfac4f87615c9a219db95b.png)

I have already converted all my queries to Names Queries.  
What should I be looking for? My software is ver. 7.9.4

---

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [April 3, 2019, 1:00am UTC](https://forum.inductiveautomation.com/t/root-container-error-but-no-message/23806/2 "2019-04-03T01:00:13Z")

</div>

I figured this one out. My Named query was using a custom property that gets its value from the selected cell on a table component. My property binding was this -

```
try({Root Container.Table.data}[{Root Container.Table.selectedRow}, 1], 0)

```

When nothing was selected the 0 was throwing an error when no rows / cells were selected.  
I changed it to a generic value and now it works

```
{Root Container.Table.data}[{Root Container.Table.selectedRow}, 1], 200)

```

Now I would like to learn how to include a "Fall Back" into Named Queries.  
See this post -

> [@Named Query - SELECT COALESCE issue](http://forum.inductiveautomation.com/t/named-query-how-to-create-a-fall-back/23808):
>
> For a SQL Query Binding I have used the following successfully. SELECT COALESCE(Disch, 0) FROM table WHERE t\_stamp BETWEEN startTime and EndTime I cannot get this to work inside a Named Query. What am I doing wrong?
