Hi Shawn, Thanks for your reply, My system have 2GB Ram, and the database is an sql server database, and we are writing the exceptions to the table itself we are using macros to connect to the database and then write to the exception table. We are using an expression where we are opening and closing the connection and write the details with the help of that we are writing the exceptions records to the database. and this expression node is failing due to the memory issue. Thanks and Regards. Joydip ... View more

Hi Linus, Shawn, Thanks for the update using Fork, but we are still facing a lot of Issue, sometimes a) out of memory. Is there any way to control the memory to be allocated. Secondly all our data jobs are writing the exceptions into a same table so the connection is refused by the server as two threads are trying to update the same table at same point of time and the job fails, is there any alternative way. All suggestions are welcome. Thanks and Regards Joydip ... View more

Hi Linus, The job has 15 data flows all are dependent on the 1st data flow node, which creates one value, but the other 14 are independent of all others. Now it is working like after completion of 1st node, 2nd node starts, then after completion of 2nd the 3rd starts. if we can do it parallel then I think it will be fast. How can we do that, should we require, Fork or Parallel iteration node transforms. Thanks and Regards Joydip ... View more