Ask a Question

Power Monitoring Expert - How To Determine Which Sources Have Future Data

Issue:
Sources in a PME system that have improperly set clocks can cause issues due to the erroneous nature of the timestamps. Sources that have been logging future data can cause issues such as the ones explained in FA231422. Deleting the data alone will not fix the issue if the meter itself has not been corrected. On large systems, it can be difficult to determine exactly which source(s) are causing the issue.

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.

The attached query will scan the ION_Data.DataLog2 table and return all sources that have a timestamp greater than the current date and time. This list can then be used to investigate the devices to ensure they are properly configured.