Data Grid times out on load

Data Grid for a table times out before loading. If I create a view of the same table and bind the view to the data grid it loads no problem. There are only 4 child tables associated with the table in the view and the foreign keys to those tables are indexed. Any idea what's going on here? I have never had a problem like this with Radzen before.

dotnet: warn: Microsoft.AspNetCore.Components.Server.Circuits.RemoteRenderer[100]
Unhandled exception rendering component: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

dotnet: Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): The wait operation timed out.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryCloseInternal(Boolean closeReader)
at Microsoft.Data.SqlClient.SqlDataReader.Close()
at Microsoft.EntityFrameworkCore.Storage.RelationalDataReader.Close()
at Microsoft.EntityFrameworkCore.Storage.RelationalDataReader.Dispose()
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.Enumerator.Dispose() at System.Linq.Enumerable.Any[TSource](IEnumerable1 source)
at Radzen.Blazor.RadzenDataGrid`1.BuildRenderTree(RenderTreeBuilder __builder)
at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment, Exception& renderFragmentException)
ClientConnectionId:cff0275f-059d-4882-b94d-dcc11111ed38
Error Number:-2,State:0,Class:11

dotnet: fail: Microsoft.AspNetCore.Components.Server.Circuits.CircuitHost[111]
Unhandled exception in circuit 'MtqHT3pwhv0YrhvJaYH3APV2o0-1GAg_JTuvAX6pKq8'.
Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
---> System.ComponentModel.Win32Exception (258): The wait operation timed out.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryCloseInternal(Boolean closeReader)
at Microsoft.Data.SqlClient.SqlDataReader.Close()
at Microsoft.EntityFrameworkCore.Storage.RelationalDataReader.Close()
at Microsoft.EntityFrameworkCore.Storage.RelationalDataReader.Dispose()
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.Enumerator.Dispose() at System.Linq.Enumerable.Any[TSource](IEnumerable1 source)
at Radzen.Blazor.RadzenDataGrid`1.BuildRenderTree(RenderTreeBuilder __builder)
at Microsoft.AspNetCore.Components.Rendering.ComponentState.RenderIntoBatch(RenderBatchBuilder batchBuilder, RenderFragment renderFragment, Exception& renderFragmentException)
ClientConnectionId:cff0275f-059d-4882-b94d-dcc11111ed38
Error Number:-2,State:0,Class:11

dotnet: info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint '/_blazor'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/_blazor?id=2_pZzCNTYoOrI2YbGTyv1w - - - 101 - - 32275.3859ms

Hi @Hansioli,

How many records are retrieved at once? Are you using paging?

paging is setup at 10 records. virtualization turned on and turned off for the grid. doesn't make a difference.

Hi @Hansioli,

Please send us your application along with your database schema at info@radzen.com to try debug locally what's going on.

1 Like

on it's way. I generated SQL scripts for the database.

We've not received anything so far. If your ZIP is too big you might need to use some sharing service like Google Drive.

Its 9mb zipped. is that too big?

Not sure what’s the current state of our mail server however indeed might be too big.

Figured out the issue. When the data grid is set to allow virtualization; the page times out on load. If allowing virtualization is not checked, it works fine. Theoretically, for large datasets, it should be the exact opposite. Any idea what may have changed? My older apps built with Radzen have much larger datasets and work great with allowing virtualization checked. Curious about what changed.