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: 157700

    • Related Articles

    • zenon Changesets Excel

      Here, you can access a comprehensive list of changes across all maintained versions of the zenon Software Platform as Excel Worksheets. This includes both implemented bug-fixes and new features. Additionally, these lists are available in CSV format ...

    • zenon Changesets CSV

      Here, you can access a comprehensive list of changes across all maintained versions of the zenon Software Platform as Excel Worksheets. This includes both implemented bug-fixes and new features. Additionally, these lists are available in as Excel ...

    • Machine Event Counters Report not working any more in zenon 12

      Description In Report Engine version 12, the reports "Machine Event Counters", "Over Revolutions on Load Shedding" and "Active Power on Load Shedding" no longer work after they have been updated from a previous version. The error states that the ...

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

    • The SE reports an unhandled exception when closed while an evacuation to the Data Store is running

      Summary The Service Engine reports an unhandled exception while evacuating data to Data Storage. This has been fixed. Description The Service Engine reports an unhandled exception if data is being evacuated to Data Storage while the Service Gateway ...