Hello everybody, I have a problem to generate a CVS file with a scheduled report.
I need generate a report weekly with 45 history tags.
The CPU goes to 80-90% and RAM 3GB goes to 9GB (ignition has been set with 10GB of RAM), then the gateway does not make it and crash.
Report parameters:
Aggregation mode: Closest Value
Return format:Wide
Sample Size: Interval 10 second
How much memory are you giving to Ignition service?
– This can be found in the ignition folder in your ignition.conf file
– initial heap size?
– max heap size?
If your end goal is CSV data, it would probably be a lot better to write to the CSV directly, rather than rely on the report modules ability to save datasets. A gateway timer script, or even a tag event script trigger by a transaction group (giving you precise scheduling) would be a good option to run a single gateway event that queries the history, then saves it to a file.
[quote=“PGriffith”]If your end goal is CSV data, it would probably be a lot better to write to the CSV directly, rather than rely on the report modules ability to save datasets. A gateway timer script, or even a tag event script trigger by a transaction group (giving you precise scheduling) would be a good option to run a single gateway event that queries the history, then saves it to a file.