Parallel reading of AML and CEL data from SQL locks all SQL operation on the system
Description
In a network environment, an endless progress bar may be shown in the Service Engine Server when clients try to read/access Alarm or Event data from SQL database simultaneously. As multiple clients requests can be pending, clicking on Cancel button in the progress bar displayed in the Server only allows to fetch partial data to the first Client performing the request.
The issue has been addressed and the parallel reading of AML and CEL data from SQL does not lock SQL operations anymore.
To benefit from this fix:
- Update your zenon Software Platform to the latest build of zenon 11 or higher.
Item ID: 289433
Version: 14.00 Build: 314355
Version: 12.00 Build: 365438
Version: 11.00 Build: 383048
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] ...
FAQ: How, where, why and when does zenon Service Engine save data?
zenon Disk Space Handling: The zenon Service Engine, by default, stores process data on the hard disk. This is true for a standalone zenon project, as well as the zenon Service Engine server(s) in the zenon network topology. This data consists of ...
AML CEL continuous export looses data when starting with invalid connection
Summary The initialisation was split up in 2 parts: Reading the dumped data is done before the AML and CEL become active upon startup and while the AML and CEL are paused during reload (dump before reload, read after reload). The main thread which ...
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 ...
Report Engine: it is not possible to display only evacuated AML- or CEL - reports (when using SQL connector)
Summary In the Report Engine, it is not possible to display only evacuated CEL reports when using the SQL Connector. This error has been fixed. Description In the Report Engine, when the SQL connector is configured for CEL only, all CEL queries fail, ...