https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70937#M23542 Hi David,  Actually we have 1 lakhs records in excel, we are split to three excels dividing be 40K records as one excel sheet. After we are splitting also we getting Memomry exception while OLDB Vbo as well. we are take 10K each time process may take some time right? that's why we are taking 40K records by using OLDB.  Is they another way to resolve the issue!!!. Pls Suggest.   Regards, Naveen Fri, 28 Dec 2018 11:37:00 GMT NaveenG 2018-12-28T11:37:00Z https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70934#M23539 Hello , In Excel sheet i have 40000 records, by using OLDB i have taking into OLDB Collection. After some records processed (nearly 35000+records) im getting memory issue and Blueprism is getting close. is they any alternative way to achive this I have use sleep stage ,after processing every 10000 records but still no use. Thanks, Naveen  Wed, 26 Dec 2018 09:03:00 GMT https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70934#M23539 NaveenG 2018-12-26T09:03:00Z https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70935#M23540 Hi Naveen, Have you tried pulling the data from excel in batches of 10,000 and then working on it, clearing it out, then get 10,000 more rows, etc.? Respectfully, Dave Fri, 28 Dec 2018 07:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70935#M23540 david.l.morris 2018-12-28T07:37:00Z https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70936#M23541 One more thing... Not sure if what I said was clear or not. What I mean is that the way you described it sounds as though you have all 40k records in a collection at once. And what I'm suggesting is to try not pulling it all in at once. Your business logic may require all 40k at the same time, but hopefully it doesn't. Fri, 28 Dec 2018 07:38:00 GMT https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70936#M23541 david.l.morris 2018-12-28T07:38:00Z https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70937#M23542 Hi David,  Actually we have 1 lakhs records in excel, we are split to three excels dividing be 40K records as one excel sheet. After we are splitting also we getting Memomry exception while OLDB Vbo as well. we are take 10K each time process may take some time right? that's why we are taking 40K records by using OLDB.  Is they another way to resolve the issue!!!. Pls Suggest.   Regards, Naveen Fri, 28 Dec 2018 11:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Low-Memory-Exception/m-p/70937#M23542 NaveenG 2018-12-28T11:37:00Z