MS SQL Server : System.OutOfMemoryException: Array dimensions exceeded supported range on dataset

+3 votes

asked Mar 4, 2018 in Databases by praveen (71.8k points)
edited Mar 21, 2018 by pkumar81

I am running ETL CDM Builder to convert about 2TB of data into CDMv5 format, but it is giving an error 'System.OutOfMemoryException: Array dimensions exceeded supported range' at 'Chunks creation' step. How can I fix it?

sql server
array
dimension

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

+2 votes

answered Mar 4, 2018 by pythonuser (73.8k points)
selected Mar 8 by pkumar81

Best answer

If you have configuration file, add the following lines to it. Hopefully, it will fix the issue.

<runtime>
<gcAllowVeryLargeObjects enabled="true" />
</runtime>

MS SQL Server : System.OutOfMemoryException: Array dimensions exceeded supported range on dataset

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.

Related questions

Categories