# Unable to show tags in power chart **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [April 30, 2025, 2:36pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732 "2025-04-30T14:36:19Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [April 30, 2025, 2:36pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/1 "2025-04-30T14:36:19Z")
I think it may be a SQL issue but unsure how to troubleshoot. My OPC tags weren't working so I went back to as simple as possible. A memory tag in the root tag provider folder and it still gives me an error in the power chart of "No Trend Data Source (Bad\_NotFound) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/9/99bd3fb7de6c9be5a89f38bc1aade2812bda0bd1.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/064154e9aac5d453f7b3e48353429ad6aaafeeac.png) My database is connected and showing valid. As well when the power chart is live in perspective it's showing queries. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/b/ebd9e441600851abccad5f990da8b30a676b4bbf.png) However I am getting errors in my logs. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f6c44298d50d3b96f1dfa6b67283e496ad0042f3.png) What I have noticed is: 1. In the power chart after I added the tag, if I select edit the path is all lower case, but part of my server name is capitals, if I edit the path to include those capitals the power chart error slightly changes and removes the (Bad\_NotFound) part but it still says No Trend Data Source available. 2. In SQLExpress I see tables created from the historian, the drv table looks correct but I wonder if the scinfo and other tables are actually working properly? sqlth\_drv ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/7/17133bb8efd52723f8ebe0644c1d1ef2a28ef153.png) sqlth\_scinfo ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/5/75580e4dd8508dc613540b2a4cb0b2273bf1280f.png) sqlth\_sce is empty sqlt\_data\_1\_2025\_04 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/6/06c0eee18d19ea90c0f2ebd0dbca8bf41032c671.png) ---
**Author:** ![RodrigoR](https://avatars.discourse-cdn.com/v4/letter/r/d78d45/32.png) [@RodrigoR](https://forum.inductiveautomation.com/u/RodrigoR)\ **Post date:** [April 30, 2025, 3:25pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/2 "2025-04-30T15:25:48Z")
> [@Nol](#): > > I think it may be a SQL issue but unsure how to troubleshoot. My OPC tags weren't working so I went back to as simple as possible. A memory tag in the root tag provider folder and it still gives me an error in the power chart of "No Trend Data Source (Bad\_NotFound) Run a SQL query directly on the database to verify if any data is being stored for the time range selected on the Power Chart. If you just created the tag or enabled history, the selected time range in the Power Chart might not include any data yet. Try expanding the range to make sure. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [April 30, 2025, 4:30pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/3 "2025-04-30T16:30:54Z")
So I see the tag created within sqlth\_te as soon as I add it and enable history. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/00a162a7ddbf18cefb220e8f54bba3c3f4f81069.png) However in sqlt\_data\_1\_2025\_04 I am not seeing any data appear with the query below. Even after changing the value a few times and waiting an hour. So it appears it's not writing the history in. ```python SELECT TOP 100 * FROM [test].[dbo].[sqlth_1_data] WHERE tagid = 985; ``` Returns nothing. Edit: I did separately create a transaction group that records this tag and noticed that does correctly write into the group\_table. And if I add a DB\_table\_historian into my history providers I can pull that into the power chart and it works. But my understanding is that I should be able to pull the tag without going with a transaction group? Or am I wrong thinking in that. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [April 30, 2025, 4:43pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/4 "2025-04-30T16:43:41Z")
> [@Nol](#): > > But my understanding is that I should be able to pull the tag without going with a transaction group? Correct. The sqlth\_sce table should definitely not be empty. I would also expect to see more in sqlth\_scinfo. I would recommend that you call into support so they can look over your shoulder. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [April 30, 2025, 5:02pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/5 "2025-04-30T17:02:02Z")
So I found the data, I didn't realize the tagid changed when I switched the tag history from on change to periodic and back when testing. The data is writing correctly into sqlt\_data\_1\_2025\_04 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/b/1b2348ee08268d17d917067c3a126e2c12d87df7.png) I also found the data is writing into sqlt\_data\_1\_2025\_04 and not into sqlth\_1\_data if that matters? I did disable/enable partitioning setting in the tag history provider at one point during testing so I'm assuming the second table was created from that. Do I need to remove sqlth\_1\_data? Or it shouldn't matter? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [April 30, 2025, 5:09pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/6 "2025-04-30T17:09:45Z")
> [@Nol](#): > > Or it shouldn't matter? It should not matter. Any changes that you make to the tag, can and often do result in a new Tag ID. However, that shouldn't matter as the history system looks up the ID by tag path. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [April 30, 2025, 5:09pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/7 "2025-04-30T17:09:55Z")
> [@lrose](#): > > Correct. > > The sqlth\_sce table should definitely not be empty. I would also expect to see more in sqlth\_scinfo. > > I would recommend that you call into support so they can look over your shoulder. I changed the sample mode from On Change to Tag Group and put the Default historical group. Doing so did create corresponding entries in sqlth\_scinfo and sqlth\_sce now. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7f56466134a5357cf2b94498f527182788e99411.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/947fc1e1e6c19eedb456cc4fd4277ba80cf7bb32.png) ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [April 30, 2025, 9:54pm UTC](https://forum.inductiveautomation.com/t/unable-to-show-tags-in-power-chart/105732/8 "2025-04-30T21:54:00Z")
Huge props to Ignition support was able to resolve it quickly with them. The issue was the drv table was missing an entry and sceinfo changed. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a3841a97bbd8d70320046f5f340ed50fd441cc49.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/5/05d05a0027b56e11150f7ab51a4e142006057ffd.png)