Historian: SQL evacuation fails with certain archive files

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 reported. However, this does not work if it is the last value.

This error has been fixed. Archive files containing "NaN" entries are successfully evacuated. Invalid lines are skipped and all data - except the "NaN" entries - is sent to the database.

To benefit from this fix:

  • Update your zenon Software Platform to the latest build of zenon 11 or higher.


Item ID: 279565
Version: 12.00 Build: 220199
Version: 11.00 Build: 219314

    • Related Articles

    • FAQ: Historian configuration general recommendations

      1. Recommendation on hardware: Storage Memory CPU - SSD (Solid-State Drive). - Disk space capacity as detailed in the attached Excel sheet outputs. - RAM required to load the archive data is about 4 times greater the size of the respective ARX files. ...

    • 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 ...

    • 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 ...

    • Archive Evacuation for RDA Archive not working for *.arx archives.

      Summary Historian RDA Archive doesn't evacuate intern archive format *.arx archives DescriptionHistorian RDA Archive doesn't evacuate intern archive format *.arx archives Solution Evacuation for RDA archive working. Issue Number: 37195 Fixed on Date: ...

    • 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 ...