Evacuating archives to MySQL does not work

Evacuating archives to MySQL does not work

Description

Evacuating archives to MySQL does not work. An unhandled exception occurs when creating tables.

 

Cause:

The problem is caused by an "unknown error" if CreateCommand fails when called after StartTransaction in the MySQL ODBC driver 8.0.33.0.

 

Solution:

Use MySQL ODBC driver version 8.0.21.0. This works correctly with zenon.



Item ID: 263919
Version: 11.00 Build: 150599
Version: 11.00 Build: 157700

    • Related Articles

    • 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 should support access to MySQL and SQLite

      Summary It should be possible to access MySQL and SQLite databases by usage of function blocks inside zenon Logic. DescriptionIt should be possible to access MySQL and SQLite databases by usage of function blocks inside zenon Logic. Solution New ...

    • Invalid characters in (aggregrated)archives

      Summary The standard mechanism for creating new archive IDs tries to create an ID by modifying the second position of the ID of the parent archive ('0' - 'Z'), i.e. the children of parent archive 'AB' get the Ids 'A0', 'A1', ... Now, if this doesn't ...

    • The Outsourcing of SQL-Archives in MS Azure does not work - ZenonArchiveWorker reports error

      Summary Azure service ZenonArchiveWorker is not starting because it needs .Net 4.6.2 on Azure Windows Server 2012 R2 guest OS Description Azure service ZenonArchiveWorker is not starting because it needs .Net 4.6.2 on Azure Windows Server 2012 R2 ...

    • XML Export/Import of "exported archives" – zenon Export archives function loses settings

      Summary If the Export archives function has a setting to export the archive in dBase, SQL or XML format and these functions are exported as XML, and then imported again, the exported format is set to CSV. DescriptionIf the Export archives function ...