Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
A meter was time synched with an incorrect time, resulting in meter logging data with the wrong time for an unknown duration.
ION Enterprise 5.5/6, SPM 7.0.1, PME 7.2 and PME 8
SQL Server Management Studio, ION setup
The meter was time synched with an incorrect time. This resulted in the meter recording data logs with incorrect timestamps. The effected date range was identified by comparing the data obtained directly from the meter using ION Setup and the datalog tables in vista.
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 following procedure can correct logged data with incorrect timestamps in an ION Enterprise/ PME SQL database.
In the following example, all of the logs between 2015-06-01 and 2015-08-01 were logged with a timestamp that was 4 hours ahead of the actual time. Query the database against the period where there is a problem:
First, let’s identify the source ID by running the following query on the ION_Data database
Select ID, Name, Signature from Source
The query will return the following in this example:
ID Name Signature
4 MATT.ION7500RTU PK-0401A206-01
For SPM 7.0.1 and later:
1- Use the SourceID to query the DataLog2 table for the records in the range of the timestamps that are incorrect.
Select ID, TimestampUTC From datalog2 WHERE SourceID=4 and timestamputc>'2015-06-01' and timestamputc<'2015-08-01' order by timestamputc desc
After verifying the incorrect timestamp, update the DataLog2 table by offsetting the TimeStampUTC value to the correct timestamp by running the following query:
Update DataLog2 Set TimestampUTC = DATEADD(hour, -4,timestamputc) from DataLog2 where SourceID=4 and timestamputc>'2015-06-01' and timestamputc<'2015-08-01'
The DateAdd functionality works for the following dateparts:
Once the query is successfully executed, verify that the timestamps have been modified by running the select functionalities
For ION enterprise 6.0 and below:
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!