E1 Orchestration causes Java memory error
Hi, my orchestration (9.2.4.4) is failing with this error in the AIS log:
JobQueue.submitSynchOrchestration: Execution Exception in Thread java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: GC overhead limit exceeded
The orchestration consists of two steps:
1) SFTP Connector - opens a file and treats it as CSV
2) Database Connector (Groovy) builds an SQL insert statement based on inputs from previous step and executes it with sqlInst.execute()
Step 2 is set to Iterate Over the record created in step 1.
This appears to work fine with a small file of a dozen rows. For a large file of 100,000 rows, it fails with the error above.