I have 2 Edge IIOT gateways that are set up to collect tag history from various local devices at two separate locations. They then are set to sync data to a central gateway that has a trend screen and that is where it is connected to a MSSQL server. When I did an export on a tag over 8 days, it shows two exact entries for a tag (exact) every 5 seconds. I do not have another gateway running that is connected to the same SQL server, so there is no redundancy set up that might cause this issue.
What would cause this?
Can you show how you have the tag history configured on the edge device?
Can you share the method by which you exported the data? You might see duplicates if the query for data is configured to return two values for the same timestamp (min/max aggregation w/ point count matching the historian’s stored data count).
I am just using the generic "Export" function of the Power Chart component in Perpsective.
Here are a couple screen shots of the tag setup and the gateway. It looks to be setup correctly?
How are you adding the tags to the power chart? What is the pens.aggregateMode for the pens on the power table?
1 Like
Forest/Trees. That was the issue. I did not have the Aggregate mode set to Last Value, it was set to MinMax. Hence, the dual values in the export. Thanks for pointing me to that.
1 Like
