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

    • Database error 0x80040154: Class not registered.

      Issue: Archive can not be evacuated Log shows error: Database error 0x80040154: Class not registered. Problem: Engineering Studio configured a SQL provider to be used, which does not exist on the Service Engine PC. Solution: Install the configured ...

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