https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85690#M36650 Thanks Manpreet and Eric. I will try doing that. However, what do you think could be the reason for why its a problem from control room and not from the studio?<BR /><BR />------------------------------<BR />Maneesh Vemula<BR />------------------------------<BR /> Tue, 01 Nov 2022 18:48:00 GMT maneesh.vemula1 2022-11-01T18:48:00Z https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85687#M36647 Hi Everyone - I am running the 'Get Collection' action from the Business Object 'BP-SQL Server' and getting the 'System Out of Memory' exception. The weird thing here is that I am not receiving this error while running from the Studio - I'm only getting this error when I am running the process through the control room. The total # of rows are 667288 in the collection. I checked the memory usage in the task manager - when run from the studio, the total memory is reaching around 600MB and it is able to retrieve the data without any issues but while running from the control room, it is going up to 1400MB before throwing the exception. Can someone advise on how to resolve this issue?<BR /><BR />Thanks in advance!​​<BR /><BR />------------------------------<BR />Maneesh Vemula<BR />------------------------------<BR /> Mon, 31 Oct 2022 19:30:00 GMT https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85687#M36647 maneesh.vemula1 2022-10-31T19:30:00Z https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85688#M36648 Hi <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/18945">@maneesh.vemula1</a>,<BR /><BR />Did you try getting the data in chunks or batches rather than directly fetching the entire data set in one go?​<BR /><BR />------------------------------<BR />Manpreet Kaur<BR />Manager<BR />Deloitte<BR />*If you find this post helpful mark it as Best Answer<BR />------------------------------<BR /> Mon, 31 Oct 2022 20:06:00 GMT https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85688#M36648 ManpreetKaur1 2022-10-31T20:06:00Z https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85689#M36649 Hello <a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/18945">@maneesh.vemula1</a>,<BR /><BR /><a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/24659">@ManpreetKaur1</a>'s recommendation is the best approach. Break your query up into chunks (ex. rows 1-100000, rows 100001-200000, etc). The following tutorial discusses using the OFFSET and FETCH clauses in your query:<BR /><BR /><A href="https://learnsql.com/cookbook/how-to-limit-rows-in-a-sql-server-result-set/" target="_blank" rel="noopener">https://learnsql.com/cookbook/how-to-limit-rows-in-a-sql-server-result-set/</A>​​<BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Integrations and Enablement<BR />Blue Prism Digital Exchange<BR />------------------------------<BR /> Mon, 31 Oct 2022 21:43:00 GMT https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85689#M36649 ewilson 2022-10-31T21:43:00Z https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85690#M36650 Thanks Manpreet and Eric. I will try doing that. However, what do you think could be the reason for why its a problem from control room and not from the studio?<BR /><BR />------------------------------<BR />Maneesh Vemula<BR />------------------------------<BR /> Tue, 01 Nov 2022 18:48:00 GMT https://community.blueprism.com/t5/Product-Forum/System-Out-of-Memory-Exception-SQL-Server-Object-Get-Collection/m-p/85690#M36650 maneesh.vemula1 2022-11-01T18:48:00Z