Hi all,
I'm wondering if anyone else ran into this issue and can help me out.
The tag was online, reading data, and recording it to our database. I'm able to see it when I add it to a chart. When I look at the file, it's all zeros in every spot. Changing the endTime to system.date.now() will include data from the first of the month but before that its all zeros.
It only seems to affect tags in our Edge server's tag history provider. Tags in [default] work fine.
startTime = system.date.getDate(2023, 1, 1) # yyyy, mm, dd
endTime = system.date.getDate(2024, 1, 1)
dataSet = system.tag.queryTagHistory(paths=['[IGN-Edge]Proleit Tracking/Utilities/Nitrogen/Outlet Flow/Value'],
startDate=startTime, endDate=endTime,
intervalMinutes=5, aggregationMode="Maximum", returnFormat='Wide')
spreadsheet = system.dataset.dataSetToExcel(1, [dataSet])
filePath = "C:\\Users\\username\\Documents\\N2_flow_rate_2023.xls"
system.file.writeFile(filePath, spreadsheet)
Potentially related to the issue I'm having is this post I made about a pre-processed partition table that has some corruption. It was a table from 2020 (iirc) and is outside of the date range for this query by a while.
If you have any ideas about fixing this, it would be greatly appreciated! Thanks!