If SQL-evacuated data for more than 20 variables from an archive is read back for ETM, data for all variables in the given is read back which leads to very high loading times for archives with many variables and data
Description
When SQL evacuated
data for Extended Trend is read back, this can take very long
times if data for more than 20 variables
is retrieved. This is because in this case the data is retrieved for all
variables in the archive.
This limit has been increased to 100 variables.
This means that when 1
to 100 variables are retrieved, only data
for exactly these variables are read back. The loading time is thus very short.
From 101 variables, the data for all variables
in the archive are retrieved. The loading time can thus be significantly higher
again.
To benefit from this fix:
- Update your zenon Software Platform to the latest build of zenon 11 or
higher.
Item ID: 265914
Version: 12.00 Build: 159727
Version: 11.00 Build: 157700
Related Articles
After updating to zenon 7.20 I dont see newly SQL evacuated historian data anymore in the trend (ETM), Report Generator, Report Viewer and Archive Revision, only the former evacuated values are displayed.
Summary When having a 7.11 project and evacuating archives to SQL database, then converting project to 7.20 and start the runtime, in the ETM only the data of 7.11 is shown and the .ARX data before evacuation, but NOT the evacuated data of 7.20 ...
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] ...
Archive configuration for best SQL evacuation performance
The time required to evacuate data to a database increases linearly with the number of insert SQL statements. In earlier zenon versions, recorded values were evacuated to the target database sequentially using single-insert statements. From zenon 11 ...
Evacuation of Archives to Data Storage fails for big archive capsules
Summary Payloads for archive data are split now when sent to the data storage. The max number of values per request can be set via project.ini under section "ServiceNet" with the key "MaxValueCountForDataStorage" (default value is 30,000). ...
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 ...