Inconsistent behavior between SQL Database and Local Service Engine Storage with CEL filter
Description
When saving the AML or CEL entries,
different entries are displayed depending on the storage type. When saving in a
local service engine, all entries are displayed according to the selected
filter. When storing in an SQL database, current results are partially hidden.
Then results with external timestamp are preferred.
Reason:
- Reading of data from SQL database is done
in a different order than reading of local binary files.
Solution:
- All objects are sorted chronologically.
- When reading AML or CEL entries, if it is found that there are more objects
than allowed in the filter, the objects are sorted by the "coming"
timestamp.
- If entries need to be truncated, it is always the oldest entries
that are removed.
To take advantage of this fix:
- Update to the latest build of zenon 10 or
later.
Item ID: 254905
Version: 11.00 Build: 104641
Version: 10.00 Build: 106141
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: HTML5 WebEngine local variables are mirrored to all clients?
Variables used in the WebEngine are mirrored into all HTML5 Clients. If a HTML5 Client has write access, it can alter variables for the native Service Engine and all connected HTML5 clients even when the calculation of the variable is set to "local". ...
FAQ: Why do backups of Service Engine data sometimes fail when the Service Engine is running? Is it actually possible to create a consistent backup when the Service Engine is not closed?
During normal operation, the zenon Service Engine continuously accesses different runtime files for reading and writing. A backup software that attempts to create a backup of a file that is currently accessed by the Service Engine may receive an ...
Sporadic Runtime crash when exporting CEL to SQL database
Description In zenon 8.20, the Service Engine can sporadically crash when exporting the CEL to an SQL database. This error has been fixed. To benefit from this fix: Update your zenon Software Platform to the latest build of zenon 8,20 or higher. Item ...