NaN values should be suppressed during SQL evacuation

NaN values should be suppressed during SQL evacuation

Summary

NaN values should be suppressed during SQL evacuation, since NaN values cannot be represented in SQL.

Description

NaN values should be suppressed during SQL evacuation, since NaN values cannot be represented in SQL.

Solution

The evacuation method in the Historian module was modified, so NaN values are no longer evacuated when using SQL as target.

Information

Fixed on 02.07.2012, available from 7.00 SP0 Build 2, available from 6.51 SP0 Build 15



Issue Number: 27257
Fixed on Date: 2.7.2012
Versions: 6.51 0 BUILD 15 | 7.00 0 BUILD 2

    • Related Articles

    • Archive configuration for best SQL evacuation performance

      The time required to evacuate data to a database increases linearly with the number of insert SQL statements. In earlier zenon versions, recorded values were evacuated to the target database sequentially using single-insert statements. From zenon 11 ...

    • Historian: SQL evacuation fails with certain archive files

      Description An error occurs in the Historian during the SQL evacuation of archive data. The evacuation fails for certain archive files. This occurs when the last value of a variable is "NaN". In this case, this value is expected to be skipped and ...

    • SQL evacuation failure with double entries in archive file

      Summary The SQL evacuation stops if in the archive file are two identical values. Identical means same NameID same Value same Timestamp same Status. These entries could happen if in the archive configuration the option 'save process image during ...

    • SQL PGW: Values are not written into database tables

      Description SQL Process Gateway version 11 does not display configured variables and values. Cause: The Process Gateway cannot access the configured variable list. This behavior has been fixed. The PGW now displays variables and values correctly. To ...

    • Extended Trend doesn't show curves if aggregation data are evaluated in SQL database.

      Summary In Extended Trens screen switch function are not show aggregation curves MIN, MAX and MW from SQL database after evaluation. DescriptionIn Extended Trens screen switch function are not show aggregation curves MIN, MAX and MW from SQL database ...