Skip to main content
InSource KnowledgeCenter

046071 - Historian Client Query is showing two different results for the same tags

Problem

When running a query for the same tag, the results appear to be erroneous. When Full retrieval of tags returns sub-second intervals. The result that are being returned are invalid and not possible. Software version details: 1. WW Historian 10.0 SP1 Patch 01 (10.0.101) 2. WW Historian Client is 10.0 SP2 (10.0.200) 3. MS Windows Server 2008 R2 SP1 4. MS SQL Server 2008 SP3 Standard Edition (10.0.5500.0)

Product Version: 10.0

ProdSp: SP2

OS: Win 2008 32 bit

Solution

When using a 10s cyclic storage and the time drifts by more than 10s into the future the Historian re-timestamps the data to match its current time. When using a counter with rollover this causes the data to appear erroneous because it appears the counter has been tripped any time there is a value that is lower than the earlier time sequential data.

Close Date: 2013-08-20 09:07:46