Online vs Original value

Find and share HowTos to various installations / configurations!
3 posts • Page 1 of 1
aorange
Posts:147
Joined: Thu Nov 04, 2010 10:07 am

Online vs Original value

Post by aorange »

A basic question perhaps, but is it possible to have different timestamps on the _original and _online values of a DPE?

I am creating a report that will run on the RDB and there are a few columns with the data-type TIMESTAMP;

- TS
- VALUEDYNTIMESTAMP
- CORRVALUE_DYNTIMESTAMP
- OLVALUE_DYNTIMESTAMP
- OFFVALUE_DYNTIMESTAMP

If I want to query the time that the driver sent to WinCC-OA, am I correct in thinking that I should use TS?

PS. This is not a support question, just looking for advice from this great community :)

Schoetzke
Posts:4
Joined: Fri Oct 29, 2010 4:22 pm

Re: Online vs Original value

Post by Schoetzke »

Yes it is possible. The _original value is the value from the driver. Is this value correct so the Online and Original Value are the same.
If your value is out of the PV Range and you have set a default value, the online value is now the default value.

When you change the default value, the online value will be the new default value and gets a new timestamp.
The Timestamp of the original value is now different from online value timestamp.

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: Online vs Original value

Post by leoknipp »

Hello,

the previous answer is correct. If the _default-config is modified while the conditions to set the _default-value are fulfilled the online-value and its timestamp is modified.
When archiving the values in the Oracle-database using the RDB-manager changing the _default-config has no effect to the values saved in the Oracle-database.


The timestamp information is stored in the TS-column in the Oracle-database when looking at the table EVENTHISTORY_.
At my tests the other "TIMESTAMP"-columns were not filled with values.

Best Regards
Leopold Knipp
Senior Support Specialist

3 posts • Page 1 of 1