Evacuation via OLE DB Provider for SQL Server results in crashes on latest zenon builds

Evacuation via OLE DB Provider for SQL Server results in crashes on latest zenon builds

Summary

When evacuating archives, zenon crashes in some cases.

Description

When evacuating archives via the OLE DB Provider for SQL Server, crashes of zenon occur.

Cause:

This is caused by using an outdated OLE DB Provider that is not suitable for multi-line insertion.

Solution:

Multi-line insertion is disabled for OLE DB Provider for SQL Server (SQLOLEDB).

To benefit from this fix:

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

Recommendation:

  • Avoid the OLE DB Provider for SQL Server (SQLOLEDB) as well as SQL Server Native Client (SNAC), which are no longer maintained by Microsoft.
  • Use the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) as recommended by Microsoft.

 



Item ID: 259374
Version: 11.00 Build: 115310

    • Related Articles

    • FAQ: What SQL server interfaces are offered by zenon?

      The most common ones are: The zenon Historian The Extended Trend The zenon Report Generator The zenon Report Engine The zenon SQL export functions The zenon SQL Driver and The zenon Process Gateway SQL module All these modules depend on an ODBC / ...

    • Checklist: OPCDA Server

      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. Do NOT use DCOM in combination ...

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

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

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