# Component Error on Time Series Chart with Query

**URL:** <https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [November 30, 2022, 8:33pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110 "2022-11-30T20:33:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexandre\_Potvin](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@Alexandre\_Potvin](https://forum.inductiveautomation.com/u/Alexandre_Potvin)\
**Post date:** [November 30, 2022, 8:33pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110/1 "2022-11-30T20:33:11Z")

</div>

Hi

I keep getting component error on my Time Serie Chart. The data look good. Maybe is because i am using a a temporary table but the data look ok so i am confused maybe somone can help.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7f1e60a5c15baf1272e7761c74b84d91c3817710.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/c/ec964fa18404cda545fd76aea37d52d077dfc2ee.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/a/aa25c880755f393fc1151059def995e20d3f5dd4.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9f42377f3c18ca4d5688910fa3a8a1e6d2a77777.png)

Thank You

---

<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:** [November 30, 2022, 8:44pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110/2 "2022-11-30T20:44:39Z")

</div>

Try rewriting so the temporary table is a subquery instead. (I don't see anything that wouldn't be valid in a subquery.) Also, you've written your SQL as if a script, but without statement delimiters. SQL scripts happen to work in JDBC with Microsoft's driver, but you still need delimiters. (JDBC doesn't generally support SQL scripts. You should avoid them.)

---

<div class="post-metadata">

**Author:** ![Alexandre\_Potvin](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@Alexandre\_Potvin](https://forum.inductiveautomation.com/u/Alexandre_Potvin)\
**Post date:** [December 1, 2022, 3:16pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110/3 "2022-12-01T15:16:31Z")

</div>

Thank For your quick reponce  
I remove the complicated part and run it in the back ground ground also have tried to improve statement delimiter.

Now i have a very simple query and still have the same issue.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/8/7893299b367c3577348016348d111e5568262b89.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/9/995ed1f1e50cff4188e5b3f9191f9a49c4dd7d81.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/3/63bee680947c56bcf4c66aa31e085b7bdcb2c315.png)

Thank You

---

<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 1, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/component-error-on-time-series-chart-with-query/67110/4 "2022-12-01T15:26:03Z")

</div>

Your timestamps aren't in order. The Time Series chart needs them in order. (A `TOP` clause isn't reliable without ORDER BY anyways.)