datatype structure of structures: by update in datatype the E.Studio is blocked because it forces SQL Server to execute updates on all ProcessVariable items

datatype structure of structures: by update in datatype the E.Studio is blocked because it forces SQL Server to execute updates on all ProcessVariable items

Summary

Updating structure data types may block the Engineering Studio for a long period of time. This has been improved.

Description

If structure data types are changed, this can lead to a long blockade of the Engineering Studio. Even if only a few elements have been changed, the Engineering Studio forces the SQL server to update all elements of the complex variables. For example, by change affecting only a few elements, thousands of elements are processed.

 

This behavior has been changed. The processing now takes place only on affected elements and typically causes hardly noticeable delay.

 

To benefit from this fix:

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

 

Tip: When the driver uses "Name based" addressing, choose for variable addressing option "Offset calculation" the "Manual addressing" instead of default "Automatic addressing". This generally reduces the time needed for updates.

 



Item ID: 263514
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 ...

    • FAQ: SQL Server 2019 End of Life and Product Update Recommendations

      This article contains link to external information not maintained by Ing. Punzenberger COPA-DATA Gmbh. Which SQL Server version is included in your installation? In the zenon versions 12, 11, and 10, the installation package included Microsoft SQL ...

    • 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: Distributed Engineering – Engineering Studio cannot connect to the Project Database-Server / Elements cannot be checked-in/out

      Time estimate: 45 minutes Please go through all the items in the following checklist. If necessary, confirm any information you cannot verify with the IT department before contacting your local COPA-DATA representative.  Checklist usage: #. [Quick ...