I have this script on 20 different buttons in the project:
‘’‘results = system.db.runQuery( “SELECT * FROM MachineA” )
results = system.dataset.toDataSet(results)
spreadsheet = system.dataset.datasetToExcel( 1 , [results])
filePath = “C:\output\results.xls”
system. file .writeFile(filePath, spreadsheet)’’’
And so far I did not face any issue.
Trying to create some more buttons for next group of machines, I got “Java.Lang,OutOfMemoryError: Java heap space”.
Increasing the Client Initial/Maximum memory did not help me. Any ideas how to solve this issue?