Scada-LTS icon indicating copy to clipboard operation
Scada-LTS copied to clipboard

Fixed OutOfMemoryError for SQL Data Source

Open Limraj opened this issue 1 year ago • 0 comments

Description Lack of limits for queries in SQL Data Source is a direct path to application failure. You should limit the number of records get from the database.

To Reproduce To speed up this error, you can artificially limit the heap memory size to 1G (I had it set to 4G) using the -Xmx1G parameter and generate a large number of values, then create a SQL Data Source with a query like: select * from pointValues;

Screenshots image image image

Spec:

  • Scada-LTS Version: v2.7.6.1 (Probably +v2.6.18)

Limraj avatar Feb 28 '24 19:02 Limraj