Recaching Measurements
To load the SCADA measurements staging table into the production (run-time) SCADA measurements tables, the following command must be run:
UpdateDDS -recacheMeasurements
When this command is invoked, DDService will merge the scada_measurements_st table into the analog_measurements and digital_measurements tables (adding and removing rows as necessary) and load the updated analog_measurements and digital_measurements tables into memory.
When new measurements are added, all fields in the production measurements table are populated from the staging table.
When existing measurements are updated, all fields are copied from the staging table except the following columns because these columns can contain operator entered data (operator override values for example) - and should not be overwritten. Indeed this is the primary reason for using the staging table - to avoid overwriting these run-time columns: