# system.tag.queryTagHistory not updating the data and bring duplicate or same value for last result **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [June 7, 2022, 1:38am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434 "2022-06-07T01:38:46Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 1:38am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/1 "2022-06-07T01:38:47Z")
Hi Team, We are using the Ignition 8.1.14 on VM and MSSQL is setup on other VM. Currently there is gateway script which runs at mid night to query the data for that day and email the report to us in xml format. We have notice on couple of instance where the duplicate value is populated for the time of the day. If i look at the values in the power table using history tag by browsing for same day. The values has changed for that period where report is showing us the data as duplicate values. I check the wrapper log file i am unable to pickup any error logs. I also looked at the gateway script log activity and nothing relevant showing there as well. Is there anywhere to check what is going on with the system and how to identify what is causing this issue? ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 2:18am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/2 "2022-06-07T02:18:50Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a4d2ddf3b837403e847fa51d65fe7bbaf37d86d.png) Added the issue highlighted in blue where value is repeated again and again. ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 9:53pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/3 "2022-06-07T21:53:28Z")
Hi team, Is there anyone available to discuss this? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 7, 2022, 10:12pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/4 "2022-06-07T22:12:49Z")
Maybe you need to show us the script and the SQL query in particular. Post it using the `` code formatting button. ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 10:29pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/5 "2022-06-07T22:29:57Z")
| | ############################################################################### | | --- | --- | | | monitorName = SiteWellsReport | | | sampleHeaders = [‘t\_stamp’, ‘value’] | | | # getting data by query tag history | | | # Tag path is list of tags which needs to be quered from historian | | | TagPaths=[’[IGN]farms/flows/well4flow/tot/MeterTotal’,’[IGN]farms/flows/well9flow/tot/MeterTotal’,’[IGN]farms/flows/well12flow/tot/MeterTotal’,’[IGN]farms/flows/well15flow/tot/MeterTotal’,’[IGN]farms/flows/well17flow/tot/MeterTotal’] # Bore well 4A, 9, 12, 15,17 | | | # naming the columns in the table | | | columnName=[‘Timestamp’,‘Well 4A m3’,‘Well 9 m3’,‘Well 12 m3’,‘Well 15 m3’,‘Well 17 m3’] | | | #End time of the query | | | endTime = system.date.now() | | | #Start time of the query | | | startTime = system.date.addHours(endTime, -24) | | | dataSet = system.tag.queryTagHistory(paths=TagPaths, startDate=startTime, endDate=endTime, returnSize=96, aggregationMode=LastValue, returnFormat=‘Wide’, ignoreBadQuality = ‘true’, columnNames=columnName, intervalMinutes =15 ) | | | #print rows returned for record keeping | | | print (‘Get Dataset Rows’) | | | print dataSet | | | print (‘finish Dataset Rows’) | | | #coverting dataset to python dataset | | | pythonDataset = system.dataset.toPyDataSet(dataSet) | | | sampleData = pythonDataset | ```auto type or paste code here ``` ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 10:32pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/6 "2022-06-07T22:32:56Z")
Above is the code and the issue is when the system.tag.queryTagHistory is getting the data. It is not bring the data correctly sometime it is populating the data with duplicate values. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [June 7, 2022, 10:52pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/7 "2022-06-07T22:52:09Z")
You messed up the code formatting. The code goes **inside the triple backticks**. You can fix it by editing your question using the pencil icon. Preview before posting. ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 11:14pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/8 "2022-06-07T23:14:11Z")
Please check if this is any better? ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 7, 2022, 11:30pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/9 "2022-06-07T23:30:59Z")
To put more details: Following screen shot is showing the data for same day in power table. As you can see the data is changing. So i am not sure why system.tag.queryTag History is duplicating the values. I can replicate this issue … and no error comes up on wrapper log file or under gateway script log files. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/5/05fdbe83c944743f840216f362fb2b0c690fd54e.png) ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [June 8, 2022, 12:16am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/10 "2022-06-08T00:16:10Z")
Still not formatted correctly, ill do it for you. ```auto ############################################################################### monitorName = SiteWellsReport sampleHeaders = [‘t_stamp’, ‘value’] # getting data by query tag history # Tag path is list of tags which needs to be quered from historian TagPaths=[’[IGN]farms/flows/well4flow/tot/MeterTotal’,’[IGN]farms/flows/well9flow/tot/MeterTotal’,’[IGN]farms/flows/well12flow/tot/MeterTotal’,’[IGN]farms/flows/well15flow/tot/MeterTotal’,’[IGN]farms/flows/well17flow/tot/MeterTotal’] # Bore well 4A, 9, 12, 15,17 # naming the columns in the table columnName=[‘Timestamp’,‘Well 4A m3’,‘Well 9 m3’,‘Well 12 m3’,‘Well 15 m3’,‘Well 17 m3’] #End time of the query endTime = system.date.now() #Start time of the query startTime = system.date.addHours(endTime, -24) dataSet = system.tag.queryTagHistory(paths=TagPaths, startDate=startTime, endDate=endTime, returnSize=96, aggregationMode=LastValue, returnFormat=‘Wide’, ignoreBadQuality = ‘true’, columnNames=columnName, intervalMinutes =15 ) #print rows returned for record keeping print (‘Get Dataset Rows’) print dataSet print (‘finish Dataset Rows’) #coverting dataset to python dataset pythonDataset = system.dataset.toPyDataSet(dataSet) sampleData = pythonDataset ``` Try removing `aggregationMode=LastValue` ? ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 8, 2022, 1:22am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/11 "2022-06-08T01:22:17Z")
Hi Josborn, I tried removing aggregationmode = lastvalue… it looks like there is lot of decimal places after the decimal point which got introduced and still having the same issue as shown below. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/a/bacbad5bb2123aacedcf1b76f9643077bcc0c442.png) ---
**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:** [June 8, 2022, 1:10pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/12 "2022-06-08T13:10:17Z")
Not certain if this is contributing to what you are seeing or not, but it is definitely not correct. 1. `'true'` is not the boolean value `True`. 2. You're using both `returnSize` and `intervalMinutes`, yes there are 96 - 15min intervals in 24 hours, but you only need to use one of these. Personally I think intervalMinutes is more readable 3. Your `columnName` list has to be a 1-1 match with the tagPaths, since `'Timestamp'` isn't one of the tagPaths that you are providing then it shouldn't be included in the list. Your definition of the columnName list should look like: ```python columnName = ['Well 4A m3','Well 9 m3','Well 12 m3','Well 15 m3','Well 17 m3'] ``` Your call to `system.tag.queryTagHistory()` should look like: ```python dataSet = system.tag.queryTagHistory(paths=TagPaths, startDate=startTime, endDate=endTime, aggregationMode=LastValue, returnFormat='Wide', ignoreBadQuality = True, columnNames=columnName, intervalMinutes =15 ) ``` As an aside, if you want to print a dataset and see the contents, then you can use this helper script provided by @JordanCClark . It is quite handy. > [@View Dataset from script console](https://forum.inductiveautomation.com/t/view-dataset-from-script-console/36704/4): > > Sorry, I'm on vacation, but family is napping, so I get to play. Yes, this is how I relax. Don't judge. EDIT: Added option for printing from Perspective. Sorry, not quite ready for prime time. roll_eyes def printDataSet(datasetIn): from itertools import izip import ast if 'PropertyTreeScriptWrapper$ArrayWrapper' in str(type(datasetIn)): headers = datasetIn[0].keys() data = [] for row in datasetIn: data.append([item.value for item in row.values()]) datasetIn = system.dataset… ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 8, 2022, 7:15pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/13 "2022-06-08T19:15:04Z")
Hi Irose, Thanks for your reply. I have tried correcting the ignorebad value to “True”. this has made no difference. i have tried deleting the return size and only have interval setting. this has made no difference. If i tried to delete the time stamp from the columnNames. It is giving error. But if i look into the dataset Row0 of the dataset is the time stamp. that is by default. So if we are labeling the row 0 as "Well 4A m3 " the data under it is date time stamp. ---
**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:** [June 8, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/14 "2022-06-08T19:40:53Z")
Show the corrected script and also what the error you are getting is. ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 9, 2022, 2:01am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/15 "2022-06-09T02:01:21Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/6/36a41e16ccb6c58413fc2071308666eb6bfec7bd.png) Result is still the same. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/3/3318c38e102d5b15a3f129f839356fda8fd74ffb.png) Script modified to delete the Timestamp: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/a/ea3239fa722fc331cedd021e6a069875106ce578.png) Error after removing the timestamp. as it is used down the script. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/a/3afc116060a44e5945e41728b7bd584bd3d48a48.png) I am seeing unusally send a packet ping and read a packet ping. What is this ? ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 9, 2022, 2:11am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/16 "2022-06-09T02:11:28Z")
This is the data which we are getting in the dataset ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/f/6f5599465643824ac70e28c67db49cfda011b29a.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/4/d4df699c428d3074716e1c82e46889c02bac90a5.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/d/3d9be423de63b6bdbb0b40757da7986900e3bf5a.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/f/af17266be70589759b8e5f0598e4857ccb6d7300.png) ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 9, 2022, 2:23am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/17 "2022-06-09T02:23:05Z")
Is there any issue with gateway itself? I am seeing following records . Is this could be causing factor for it? DEBUG | wrapperp | 2022/06/09 14:20:42 | Send a packet PING : ping 000238f3 INFO | jvm 1 | 2022/06/09 14:20:42 | WrapperManager Debug: Received a packet PING : ping 000238f3 INFO | jvm 1 | 2022/06/09 14:20:42 | WrapperManager Debug: Send a packet PING : ping 000238f3 DEBUG | wrapperp | 2022/06/09 14:20:42 | read a packet PING : ping 000238f3 DEBUG | wrapperp | 2022/06/09 14:20:47 | Send a packet PING : ping 00023925 INFO | jvm 1 | 2022/06/09 14:20:47 | WrapperManager Debug: Received a packet PING : ping 00023925 INFO | jvm 1 | 2022/06/09 14:20:47 | WrapperManager Debug: Send a packet PING : ping 00023925 DEBUG | wrapperp | 2022/06/09 14:20:47 | read a packet PING : ping 00023925 DEBUG | wrapperp | 2022/06/09 14:20:52 | Send a packet PING : ping 00023957 INFO | jvm 1 | 2022/06/09 14:20:52 | WrapperManager Debug: Received a packet PING : ping 00023957 INFO | jvm 1 | 2022/06/09 14:20:52 | WrapperManager Debug: Send a packet PING : ping 00023957 DEBUG | wrapperp | 2022/06/09 14:20:52 | read a packet PING : ping 00023957 DEBUG | wrapper | 2022/06/09 14:20:54 | SERVICE\_CONTROL\_INTERROGATE DEBUG | wrapper | 2022/06/09 14:20:54 | SERVICE\_CONTROL\_INTERROGATE DEBUG | wrapperp | 2022/06/09 14:20:54 | Send a packet SERVICE\_CONTROL\_CODE : 4 DEBUG | wrapperp | 2022/06/09 14:20:54 | Send a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:20:54 | WrapperManager Debug: Received a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:20:54 | WrapperManager Debug: ServiceControlCode from Wrapper with code 4 INFO | jvm 1 | 2022/06/09 14:20:54 | WrapperManager Debug: Received a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:20:54 | WrapperManager Debug: ServiceControlCode from Wrapper with code 4 DEBUG | wrapperp | 2022/06/09 14:20:57 | Send a packet PING : ping 00023989 INFO | jvm 1 | 2022/06/09 14:20:57 | WrapperManager Debug: Received a packet PING : ping 00023989 INFO | jvm 1 | 2022/06/09 14:20:57 | WrapperManager Debug: Send a packet PING : ping 00023989 DEBUG | wrapperp | 2022/06/09 14:20:57 | read a packet PING : ping 00023989 DEBUG | wrapperp | 2022/06/09 14:21:02 | Send a packet PING : ping 000239bb INFO | jvm 1 | 2022/06/09 14:21:02 | WrapperManager Debug: Received a packet PING : ping 000239bb INFO | jvm 1 | 2022/06/09 14:21:02 | WrapperManager Debug: Send a packet PING : ping 000239bb DEBUG | wrapperp | 2022/06/09 14:21:02 | read a packet PING : ping 000239bb DEBUG | wrapperp | 2022/06/09 14:21:07 | Send a packet PING : ping 000239ed INFO | jvm 1 | 2022/06/09 14:21:07 | WrapperManager Debug: Received a packet PING : ping 000239ed INFO | jvm 1 | 2022/06/09 14:21:07 | WrapperManager Debug: Send a packet PING : ping 000239ed DEBUG | wrapperp | 2022/06/09 14:21:07 | read a packet PING : ping 000239ed DEBUG | wrapperp | 2022/06/09 14:21:12 | Send a packet PING : ping 00023a1f INFO | jvm 1 | 2022/06/09 14:21:12 | WrapperManager Debug: Received a packet PING : ping 00023a1f INFO | jvm 1 | 2022/06/09 14:21:12 | WrapperManager Debug: Send a packet PING : ping 00023a1f DEBUG | wrapperp | 2022/06/09 14:21:12 | read a packet PING : ping 00023a1f DEBUG | wrapperp | 2022/06/09 14:21:17 | Send a packet PING : ping 00023a51 INFO | jvm 1 | 2022/06/09 14:21:17 | WrapperManager Debug: Received a packet PING : ping 00023a51 INFO | jvm 1 | 2022/06/09 14:21:17 | WrapperManager Debug: Send a packet PING : ping 00023a51 DEBUG | wrapperp | 2022/06/09 14:21:17 | read a packet PING : ping 00023a51 DEBUG | wrapperp | 2022/06/09 14:21:22 | Send a packet PING : ping 00023a83 INFO | jvm 1 | 2022/06/09 14:21:22 | WrapperManager Debug: Received a packet PING : ping 00023a83 INFO | jvm 1 | 2022/06/09 14:21:22 | WrapperManager Debug: Send a packet PING : ping 00023a83 DEBUG | wrapperp | 2022/06/09 14:21:22 | read a packet PING : ping 00023a83 DEBUG | wrapperp | 2022/06/09 14:21:27 | Send a packet PING : ping 00023ab5 INFO | jvm 1 | 2022/06/09 14:21:27 | WrapperManager Debug: Received a packet PING : ping 00023ab5 INFO | jvm 1 | 2022/06/09 14:21:27 | WrapperManager Debug: Send a packet PING : ping 00023ab5 DEBUG | wrapperp | 2022/06/09 14:21:27 | read a packet PING : ping 00023ab5 DEBUG | wrapperp | 2022/06/09 14:21:32 | Send a packet PING : ping 00023ae7 INFO | jvm 1 | 2022/06/09 14:21:32 | WrapperManager Debug: Received a packet PING : ping 00023ae7 INFO | jvm 1 | 2022/06/09 14:21:32 | WrapperManager Debug: Send a packet PING : ping 00023ae7 DEBUG | wrapperp | 2022/06/09 14:21:32 | read a packet PING : ping 00023ae7 DEBUG | wrapperp | 2022/06/09 14:21:37 | Send a packet PING : ping 00023b19 INFO | jvm 1 | 2022/06/09 14:21:37 | WrapperManager Debug: Received a packet PING : ping 00023b19 INFO | jvm 1 | 2022/06/09 14:21:37 | WrapperManager Debug: Send a packet PING : ping 00023b19 DEBUG | wrapperp | 2022/06/09 14:21:37 | read a packet PING : ping 00023b19 DEBUG | wrapperp | 2022/06/09 14:21:42 | Send a packet PING : ping 00023b4b INFO | jvm 1 | 2022/06/09 14:21:42 | WrapperManager Debug: Received a packet PING : ping 00023b4b INFO | jvm 1 | 2022/06/09 14:21:42 | WrapperManager Debug: Send a packet PING : ping 00023b4b DEBUG | wrapperp | 2022/06/09 14:21:42 | read a packet PING : ping 00023b4b DEBUG | wrapperp | 2022/06/09 14:21:47 | Send a packet PING : ping 00023b7d INFO | jvm 1 | 2022/06/09 14:21:47 | WrapperManager Debug: Received a packet PING : ping 00023b7d INFO | jvm 1 | 2022/06/09 14:21:47 | WrapperManager Debug: Send a packet PING : ping 00023b7d DEBUG | wrapperp | 2022/06/09 14:21:47 | read a packet PING : ping 00023b7d DEBUG | wrapperp | 2022/06/09 14:21:52 | Send a packet PING : ping 00023baf INFO | jvm 1 | 2022/06/09 14:21:52 | WrapperManager Debug: Received a packet PING : ping 00023baf INFO | jvm 1 | 2022/06/09 14:21:52 | WrapperManager Debug: Send a packet PING : ping 00023baf DEBUG | wrapperp | 2022/06/09 14:21:52 | read a packet PING : ping 00023baf DEBUG | wrapper | 2022/06/09 14:21:54 | SERVICE\_CONTROL\_INTERROGATE DEBUG | wrapper | 2022/06/09 14:21:54 | SERVICE\_CONTROL\_INTERROGATE DEBUG | wrapperp | 2022/06/09 14:21:54 | Send a packet SERVICE\_CONTROL\_CODE : 4 DEBUG | wrapperp | 2022/06/09 14:21:54 | Send a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:21:54 | WrapperManager Debug: Received a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:21:54 | WrapperManager Debug: ServiceControlCode from Wrapper with code 4 INFO | jvm 1 | 2022/06/09 14:21:54 | WrapperManager Debug: Received a packet SERVICE\_CONTROL\_CODE : 4 INFO | jvm 1 | 2022/06/09 14:21:54 | WrapperManager Debug: ServiceControlCode from Wrapper with code 4 DEBUG | wrapperp | 2022/06/09 14:21:57 | Send a packet PING : ping 00023be1 INFO | jvm 1 | 2022/06/09 14:21:57 | WrapperManager Debug: Received a packet PING : ping 00023be1 INFO | jvm 1 | 2022/06/09 14:21:57 | WrapperManager Debug: Send a packet PING : ping 00023be1 DEBUG | wrapperp | 2022/06/09 14:21:57 | read a packet PING : ping 00023be1 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/2/92917bbd561b95631e7ace917e3056a742be9b37.png) ---
**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:** [June 9, 2022, 2:43am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/18 "2022-06-09T02:43:52Z")
The error is because elsewhere in the script you’re referencing the column `Timestamp` which doesn’t exist. The timestamp column will now be titled `t_stamp`. Leaving `Timestamp` out of the `columnName` list is correct. If you do include it, since presumably the script is not erroring, then I would guess that you’re dataset is now missing the `Well 17 3m` column header. Like I said I’m not sure it is contributing to the problem you are trying to solve, but it is definitely causing issue that eventually will come to light. You should probably contact support about what you’re seeing perhaps they can look over your shoulder and isolate the issue. ---
**Author:** ![mandeep\_gill](https://avatars.discourse-cdn.com/v4/letter/m/919ad9/32.png) [@mandeep\_gill](https://forum.inductiveautomation.com/u/mandeep_gill)\ **Post date:** [June 9, 2022, 2:56am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/19 "2022-06-09T02:56:12Z")
Sure do you know what is the process of contacting the support team? ---
**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:** [June 9, 2022, 3:01am UTC](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434/20 "2022-06-09T03:01:15Z")
You can find all of the information you need here [https://support.inductiveautomation.com/hc/en-us](https://support.inductiveautomation.com/hc/en-us) [Next page](https://forum.inductiveautomation.com/t/system-tag-querytaghistory-not-updating-the-data-and-bring-duplicate-or-same-value-for-last-result/60434.md?page=2)