First Values in Historical

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
5 posts • Page 1 of 1
xavi.aran
Posts:63
Joined: Thu Apr 21, 2011 1:21 pm

First Values in Historical

Post by xavi.aran »

Morning!!
We have a project with RDB historical. When i start RDB Manager, the manager save changes in DB, but there is a method to force RDB Manager to save the values if no previus value are in Database?

If my DP dont change, i don't have any value of this DP in historical....it should be a method to force to write the first time i start RDB to save the initial value of all variables.

Thanks!!

Gertjan van Schijndel
Posts:634
Joined: Mon Aug 02, 2010 10:37 am

Re: First Values in Historical

Post by Gertjan van Schijndel »

When the RDB manager starts it writes all archived values in the DB, which are newer than the last value in the DB.

xavi.aran
Posts:63
Joined: Thu Apr 21, 2011 1:21 pm

Re: First Values in Historical

Post by xavi.aran »

Until now we are testing our application, but now we need to put in production.
We need to delete all historical Database and starts form 0.
If i delete all registers, the only way to force all values saved again is uncheck in the Archive Config (store original value) and later check again.
There is other way to force RDB write all values? I generate a .dpl to force uncheck and a new .dpl to force check by importing by ascii manager.

fmulder
Posts:330
Joined: Wed Feb 03, 2010 9:46 am

Re: First Values in Historical

Post by fmulder »

The values will be archived when there is a change in : the value, the user bits or the statusbits. You could do:

* Change one of the statusbits
* Force a 'general query' (depends on your driver. Look at the _DriverCommon datapoint)

I'd say that the general query is the easiest solution. Means a dpSet onto _DriverCommon_.GQ

Share the fun
Frenk Mulder

Gertjan van Schijndel
Posts:634
Joined: Mon Aug 02, 2010 10:37 am

Re: First Values in Historical

Post by Gertjan van Schijndel »

1) Stop RDB manager/project
2) Delete and recreate RDB schema
3) Start RDB manager/project

5 posts • Page 1 of 1