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 ...
FAQ: How does zenon support multicore processors, multithreading and 64-bit operating systems?
Read the attached PDF (available in English and German) to get explanations about zenon on 64-bit environments, multicore processors and multithreading.
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 ...
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, ...