# Trouble using database pen on easy chart

**URL:** <https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905>\
**Category:** Ignition\
**Tags:** ignition78, database\
**Created:** [July 27, 2017, 2:37pm UTC](https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905 "2017-07-27T14:37:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.biggers](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@michael.biggers](https://forum.inductiveautomation.com/u/michael.biggers)\
**Post date:** [July 27, 2017, 2:37pm UTC](https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905/1 "2017-07-27T14:37:05Z")

</div>

So, I’m trying to display some historical data from an SQL table in an Easy Chart. I want to use a Timestamp column and a Number column, both of which I know exist and can verify the existence of, from a table in an Oracle SQL database, but the Designer tells me when I run diagnostics that those columns do not, in fact, exist. Pictured below.

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/0fcc1a7c96c739bebaf86ca7c3101875e4a5dc54.JPG)

I’m wondering why I’m getting this error, because to me at least, it doesn’t make any sense. Is it maybe a weird bug message that means something else? Am I missing something? Any help would be greatly appreciated.  
Thanks,  
Michael

---

<div class="post-metadata">

**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:** [July 27, 2017, 3:06pm UTC](https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905/2 "2017-07-27T15:06:43Z")

</div>

Try putting the columns into Ignition in lower case, or wrapping them in delimiters, eg `'max_value'`.

---

<div class="post-metadata">

**Author:** ![michael.biggers](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@michael.biggers](https://forum.inductiveautomation.com/u/michael.biggers)\
**Post date:** [July 27, 2017, 3:11pm UTC](https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905/3 "2017-07-27T15:11:26Z")

</div>

I tried both ideas, and every combination of case and delimiters. They all gave the same error as before, though. Is there something else I might be missing?

---

<div class="post-metadata">

**Author:** ![michael.biggers](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@michael.biggers](https://forum.inductiveautomation.com/u/michael.biggers)\
**Post date:** [July 27, 2017, 4:22pm UTC](https://forum.inductiveautomation.com/t/trouble-using-database-pen-on-easy-chart/14905/4 "2017-07-27T16:22:03Z")

</div>

Well, the problem recently solved itself. I’m not sure what happened, but after fiddling with changing things in the where clause (to get different sets of rows) for a while, it just started working fine, including with the same exact settings I was using before. I really can’t say I know why it worked out, because nothing is different currently, but it worked itself out. So I guess I’m not having the problem anymore. Thanks for the help, though!