Database doesn't have current values

[sesa433810_brid]

Hi All,

We have a site that using 7.2.3 with Sql Server 2012.

I've noticed that when I query the ION_Data.dbo.DataLog2 table, the data is 9-10 hours behind for all the meters.

Is there a setup, either within the meters (namely PM3255's),  PME Management Console, or ION Setup, where we can define when the data is sent to be logged in the database?

I can query each meter in ION Setup and get real time data. Just can't cross-reference that back to database when it is 9-10 hours behind.

Cheers.

[Tom_Stevenson]

Hi Russell

I am tying in Anirban DHAR​.  It sounds similar to a firmware/driver issue that was addressed some time ago for the 3255, but I suspect that 7.2.3 (very few of these systems out there) does not have that update.  Anirban DHAR​, can you please confirm?

I am quite sure a move to v8.x will resolve this Russell, but Anirban will be able to confirm first.

Tom

[Anirban · Accepted solution]

I believe this is happening because PME always saves all timestamp information in UTC. Is the customer system/server which you are accessing 9-10 behind UTC/GMT?

PME will always time sync a PM3255 device to server local time (PME will time sync a PM5000 series meter to UTC; so it varies from meter to meter depending on meter design). After reading the logs the timestamp will be converted to UTC and then stored in the database.

[sesa433810_brid]

Thank Anirban and Tom,

It was the UTC conversion which threw me out. We are 10.5 hours in from of UTC, so everything is lining up now.

Cheers,

Russ.