Report CSV

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

Thank you very much

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?

What is the date range of the history query?
A full week?

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.

The main functions you’ll need are:
docs.inductiveautomation.com/di … TagHistory
docs.inductiveautomation.com/di … aset.toCSV
docs.inductiveautomation.com/di … .writeFile

[quote=“MMaynardUSG”]What is the date range of the history query?
A full week?[/quote]
No, a full month
There are about 130000 rows

Thank’s

[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.

The main functions you’ll need are:
docs.inductiveautomation.com/di … TagHistory
docs.inductiveautomation.com/di … aset.toCSV
docs.inductiveautomation.com/di … .writeFile[/quote]

Hi, I’m using a reporting module. A dataset doesn’t works.