zenon Export function (AML) for exporting SQL and option export data incrementally does not work proper.

zenon Export function (AML) for exporting SQL and option export data incrementally does not work proper.

Summary

Export of the AML into the SQL-Database with the option set "export data incrementally" is not possible. When exporting the first time - the columns are created according to the zenon 7.60 format. The whole Ring buffer is written into the table. After the second export, the table keeps the same, no change or update of comes, goes or quits.

Description

Export of the AML into the SQL-Database with the option set "export data incrementally" is not possible. When exporting the first time - the columns are created according to the zenon 7.60 format. The whole Ring buffer is written into the table. After the second export, the table keeps the same, no change or update of comes, goes or quits.

Solution

Now, it is working proper. An issue was addressed to the UPDATE SQL-query is created correctly.

Issue Number: 39190
Fixed on Date: 13.11.2017
Versions: 7.60 0 BUILD 42944

    • Related Articles

    • Checklist: Data Missing in Service Engine

      Time estimate: 60 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Checklist usage: #. [Quick hints] ...

    • Checklist: Smart Client does not work

      Time estimate: 20 minutes Please go through all the points in the following checklist. If necessary, confirm with IT Department any information you cannot verify before contacting your local COPA-DATA Representative. Checklist usage: #. [Quick hints] ...

    • zenon logic: Unexpected complex data in expression

      In zenon version 8.20, it was possible to initiate and assign the function block in one line. This was not IEC compliant, therefore feature was removed in zenon 10. Now the error message "Unexpected complex data in expression" is logged when using ...

    • Creating Tables for AML/CEL continous SQL export and external storage does not work on SQL Server versions older than 2019

      Summary Tables for continuous export and external storage cannot be created on SQL Server prior to version 2019. This error has been fixed. Description If continuous SQL export or external storage in a SQL database is configured in the Engineering ...

    • BATCH CONTROL - Function authorization for export of recipes

      Summary Batch Control now has a new function authorization for exporting recipes. Description The export of recipes in Batch Control also allows access to the device's file system. This can now be restricted. For this purpose, the setting "Batch ...