# Database problems

**URL:** <https://forum.inductiveautomation.com/t/database-problems/4431>\
**Category:** Ignition\
**Created:** [May 8, 2012, 8:36pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431 "2012-05-08T20:36:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [May 8, 2012, 8:36pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431/1 "2012-05-08T20:36:57Z")

</div>

Gateway is pegging my CPU with nothing in the designer at all… Why is it?

Monitoring a historical string tag. The actual historian database is on the right. A table is being used to display the tag history. It seems that no matter what sort of setting I use in the table binding, I can never get the display to match what is actually in the database. Tag scan class is 350ms. Basically all I want is to see a list of changes that the tag has been through in the last 5 minutes.

![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/f/2f0984456f8dd47c5beb0a68b72c3d6cf62ef2aa.jpeg)

![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/f/2f0984456f8dd47c5beb0a68b72c3d6cf62ef2aa.jpeg)

---

<div class="post-metadata">

**Author:** ![miketob](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/miketob/32/5936_2.png) [@miketob](https://forum.inductiveautomation.com/u/miketob)\
**Post date:** [May 8, 2012, 10:23pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431/2 "2012-05-08T22:23:21Z")

</div>

Perhaps this might help you:  
[viewtopic.php?f=72&t=7336](http://www.inductiveautomation.com/forum/viewtopic.php?f=72&t=7336)

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [May 8, 2012, 11:51pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431/3 "2012-05-08T23:51:54Z")

</div>

That is definitely strange. I don’t have an immediate answer (a quick sanity check here worked fine), but here are a few things I’m curious about:

1. On the process tab, do you see the CPU on “java.exe” or over on the database?
2. How many entries do you have in the sqlth\_sce table?
3. Does the cpu ever go down?

If possible, the easiest thing would be to call in tomorrow and let us take a look over GoToMeeting. If not possible, try going to Console\>Levels in the gateway, and turn “History.SQLTags” to debug for a little bit (a few minutes, and then set it back to Info). Grab the wrapper.log file from InstallDir/logs, zip it up, and send it to support AT [inductiveautomation.com](http://inductiveautomation.com), or attach it here.

Regards,

---

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [May 9, 2012, 12:46pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431/4 "2012-05-09T12:46:30Z")

</div>

ok, can we set up a goto meeting, can you email us at [mcarangelo@gmail.com](mailto:mcarangelo@gmail.com)  
and perhaps we can get online this morning…  
Thanks,  
AJ

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [May 9, 2012, 3:17pm UTC](https://forum.inductiveautomation.com/t/database-problems/4431/5 "2012-05-09T15:17:18Z")

</div>

Ok, I sent an email, but any time you’re ready, just call in and ask for me.

Regards,