I'm facing a this issue randomly that "Error getting sample data.".
even my ignition app max heap was 4096
ExecutionException: java.lang.OutOfMemoryError: Java heap space caused by OutOfMemoryError: Java heap space
in the report I have used 6 named query inside all store prodcure and 1 basic sql query
due to this issue the report was not loaded.
You will probably need to increase your gateway memory in the ignition.conf file, not the client memory. Reports run at the gateway level.
1 Like
yeah , Even it's 16384 mb is there
`# Initial Java Heap Size (in MB)
wrapper.java.initmemory=1024
Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=16384`
The error says your out of memory. You may need to up the heap space.
Also, set the initial to the same as the max. That way java doesn't have to compete with the OS to get that memory
Are the queries returning any blob data? Or just row data? Is it quite a bit of data?
not a big data , row data only countable but there is 3 pages in that single report with multiple table simple ,crossed ..
What does your normal memory usage look like? It could be that you have just a heavily loaded gateway and the report is pushing it over.
Is all the data just queries or are there scripting data sources in the report?
1 Like