# CTG problem with TAG Pens

**URL:** <https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291>\
**Category:** Ignition\
**Created:** [April 22, 2013, 8:33am UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291 "2013-04-22T08:33:34Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![l.blasco](https://avatars.discourse-cdn.com/v4/letter/l/35a633/32.png) [@l.blasco](https://forum.inductiveautomation.com/u/l.blasco)\
**Post date:** [April 22, 2013, 8:33am UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291/1 "2013-04-22T08:33:34Z")

</div>

Hi everyone,

I have this situation:

when I work with DataBase Pens there is no problem, but when I work with Tag pens, the CTG seems to get blocked for a while, appearing the error shown in the attached picture.

why is happening this? How can this be solved?

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/348bd803599ec13e12e70eb4625f821e2b3f4b0b.png)

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [April 22, 2013, 9:57pm UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291/2 "2013-04-22T21:57:32Z")

</div>

Just a guess, it’s taking to long to return the data.

The default timeout is 60 seconds. I’ve had this behavior when the query takes longer. How much data is in the database?

---

<div class="post-metadata">

**Author:** ![l.blasco](https://avatars.discourse-cdn.com/v4/letter/l/35a633/32.png) [@l.blasco](https://forum.inductiveautomation.com/u/l.blasco)\
**Post date:** [April 23, 2013, 8:30am UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291/3 "2013-04-23T08:30:02Z")

</div>

[quote=“Robert”]Just a guess, it’s taking to long to return the data.  
The default timeout is 60 seconds. I’ve this behavior when the query takes longer. How much data is in the database?[/quote]It doesn’t seem to take more than 60 seconds…

But it all indicates that is about the amount of data, because I have tried it in my computer with very few data, and works perfectly while, the one from the client suffer from the error I explained in the first post.

Does anyone have another explanation?

Thank you for everything! ![:thumb_left:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e26afb081ddde6df016df6ee49159cf56aaca688.gif ":thumb\_left:")

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [April 24, 2013, 3:18am UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291/4 "2013-04-24T03:18:53Z")

</div>

I got around it by partitioning the data so that there was about 20,000,000 rows per table. Changed the timeout to 5 min.Then told the customer not to look at more then two partitions at a time or wait several minutes for the trend to show up.

Wish I could remember where that timeout was again ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:")

If you look on the status page on the gateway, you can see the query and how long it’s taking.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [May 21, 2013, 9:16pm UTC](https://forum.inductiveautomation.com/t/ctg-problem-with-tag-pens/6291/5 "2013-05-21T21:16:52Z")

</div>

Client read timeout - in the Designer under Configuration \> Properties \> Client \> Timing