This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 81%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Hello.
I get issue when i try to insert in Azure db a record with a nvarchar line that get 1.300.00 characters. The error log by app insight is :
An exception occurred while iterating over the results of a query for context type 'Library.EntityFramework.Context.GboContext'.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.Ctor(Char[] value, Int32 startIndex, Int32 length)
at Microsoft.Data.SqlClient.TdsParser.TryReadSqlStringValue(SqlBuffer value, Byte type, Int32 length, Encoding encoding, Boolean isPlp, TdsParserStateObject stateObj)
at Microsoft.Data.SqlClient.TdsParser.TryReadSqlValue(SqlBuffer value, SqlMetaDataPriv md, Int32 length, TdsParserStateObject stateObj, SqlCommandColumnEncryptionSetting columnEncryptionOverride, String columnName)
at Microsoft.Data.SqlClient.SqlDataReader.TryReadColumnData()
at Microsoft.Data.SqlClient.SqlDataReader.TryReadColumnInternal(Int32 i, Boolean readHeaderOnly)
at Microsoft.Data.SqlClient.SqlDataReader.GetString(Int32 i)
at lambda_method(Closure , QueryContext , DbDataReader , ResultContext , Int32[] , ResultCoordinator )
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
The error occure when i try to insert the record on the database hosted in Azure, when i try to insert in locale database the record is added without problem.
Did someone had clue about the issue ?
Thx,
Renaud.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Renaud Roland , welcome to Microsoft Q&A forum and thanks for your patience.
This seems you are using entity framework to insert records into Azure SQL Database and it is failing when we add a longer text value for a specific column.
Normally when we try to insert the value which is bigger than the size of column defined, we receive an error message like 'String or binary data would be truncated in table', which is not the error you are getting. Again this is what we understand from the first look at the error but it could be something else as well.
System.OutOfMemoryException should come mostly from the server where we are performing the process of inserting the data into target database which to me looks like entity framework application. Even sometimes if we try to insert huge data using SSMS we can face similar issue when system runs out of memory.
I would request you to check the CPU usage while you run this program and see if there is any spike in it.
To check and repro it from our side, would it be possible for you to share the ddl of the table and code snippet with the value thats giving error?
Hi @Renaud Roland , just wanted to check if you were able to look into the reply and have any follow up queries.
Hello,
The problem was with a bad query that import for each record the line with 1.300.000 char ;)
So we have solved the problem by refactoring the query.