Export all record error with blob syntax

ASP.NET Maker General Discussion (ASP.NET Maker)
1

Hello,
when trying to export a table in excel or csv I got this url and no export but a blank page:

blob:https://mysite.net/5fc3e9d1-41aa-4ff4-b1b1-13d479d0df0f

if i download few records (eg. 25) everythings works fine.

If I show ALL records and select all for download and press export then I got this situation.

What’s wrong? How can i fix it?

Thanks a lot,

John

2

Enable Debug mode, press F12 → Console / Network to check the errors in both client / server side.

3

Hi Michalel,see logs below.

I changed in Advanced Settings the Form value count limiti from 0 to 10000 and the export now works.

Is that correct?

What about the fact is table grows to 20000 records? Is there a limit in row numbers for excel exporting? Does your application check and control or will raise exception anyway?

Thanks a lot,

John

System.IO.InvalidDataException: Form value count limit 1024 exceeded.at Microsoft.AspNetCore.WebUtilities.FormPipeReader.AppendAndVerify(KeyValueAccumulator& accumulator, String decodedKey, String decodedValue)at Microsoft.AspNetCore.WebUtilities.FormPipeReader.ParseFormValuesFast(ReadOnlySpan`1 span, KeyValueAccumulator& accumulator, Boolean isFinalBlock, Int32& consumed)at Microsoft.AspNetCore.WebUtilities.FormPipeReader.ParseValuesSlow(ReadOnlySequence`1& buffer, KeyValueAccumulator& accumulator, Boolean isFinalBlock)at Microsoft.AspNetCore.WebUtilities.FormPipeReader.ParseFormValues(ReadOnlySequence`1& buffer, KeyValueAccumulator& accumulator, Boolean isFinalBlock)at Microsoft.AspNetCore.WebUtilities.FormPipeReader.ReadFormAsync(CancellationToken cancellationToken)at Microsoft.AspNetCore.Http.Features.FormFeature.InnerReadFormAsync(CancellationToken cancellationToken)at Microsoft.AspNetCore.Http.Features.FormFeature.ReadForm()at ASPNETMaker2024.Models.L2SADM.get_Form() in D:\Data Files\Progetti\SwLink\SE\Web\L2SADM\Models\aspnetfn.cs:line 500at ASPNETMaker2024.Models.L2SADM.Post(String name, StringValues& value) in D:\Data Files\Progetti\SwLink\SE\Web\L2SADM\Models\aspnetfn.cs:line 5731at ASPNETMaker2024.Models.L2SADM.Param[T](String name) in D:\Data Files\Progetti\SwLink\SE\Web\L2SADM\Models\aspnetfn.cs:line 246at ASPNETMaker2024.Models.Link2StaffADM.ResolveLanguage(String langId) in D:\Data Files\Progetti\SwLink\SE\Web\L2SADM\Models\aspnetfn.cs:line 2238at ASPNETMaker2024.Models.Link2StaffADM.PermissionHandler.HandleRequirementAsync(AuthorizationHandlerContext context, PermissionRequirement requirement) in D:\Data Files\Progetti\SwLink\SE\Web\L2SADM\Models\src\PermissionHandler.cs:line 19at Microsoft.AspNetCore.Authorization.AuthorizationHandler`1.HandleAsync(AuthorizationHandlerContext context)at Microsoft.AspNetCore.Authorization.DefaultAuthorizationService.AuthorizeAsync(ClaimsPrincipal user, Object resource, IEnumerable\`1 requirements)at Microsoft.AspNetCore.Authorization.Policy.PolicyEvaluator.AuthorizeAsync(AuthorizationPolicy policy, AuthenticateResult authenticationResult, HttpContext context, Object resource)at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)at Marvin.Cache.Headers.HttpCacheHeadersMiddleware.HandleResponse(HttpContext httpContext)at Marvin.Cache.Headers.HttpCacheHeadersMiddleware.Invoke(HttpContext httpContext, IValidatorValueInvalidator validatorValueInvalidator)at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context)

HEADERS

Accept: \*/\*Connection: keep-aliveHost: localhost:5000User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36Accept-Encoding: gzip, deflate, br, zstdAccept-Language: it-IT,it;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6,nl;q=0.5,sk;q=0.4Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiQWRtaW5pc3RyYXRvciIsIlVzZXJuYW1lIjoiQWRtaW5pc3RyYXRvciIsIlVzZXJJZCI6Ii0xIiwiUGFyZW50VXNlcklkIjoiIiwiVXNlckxldmVsSWQiOiItMSIsImV4cCI6MTc3NTA0OTQwMSwiaXNzIjoiaHR0cDovL2xvY2FsaG9zdCIsImF1ZCI6IioifQ.83fmTrBcwdeRklMl9YC6FKLNFbp0vQ1LN5nREM_fEUwContent-Type: application/x-www-form-urlencoded;charset=UTF-8Cookie: Belfor_Reperibili_LastUrl=%2FCalendarByPassList; .AspNetCore.Antiforgery.4gGG5KAF9sA=CfDJ8AJKULb7m8tPn64cOPxcBoepFg_mPEKdX4eLZNyueMk8CCtC6wBGjtN5iWG63wxIRr5yBMGedW9DM7e1TL_oQMbAViQcXbMqBS-y-Tyw1pMfwDmM_CqZJdtRXWUMXU7v51IZMoh2PLO5Uo1H2BRMOiI; CSRF-TOKEN=CfDJ8Dqa1pLShblGhlzhbLFikOHXJgnRrP8X5FeKy2jZwqC1IoZulnmfMG0Kevx8w6T20FbdPy7NedaP2myr4tt-b_MoimWamzlU81j93IH2Zx7muptlsXAbL6Xdp6KpZg2mKmklwvwZETfzHBBpszIidmo; .AspNetCore.Antiforgery.WymwfAFXECg=CfDJ8AJKULb7m8tPn64cOPxcBoc-VhfXYo88uCSxAGQpG3aCpK1Qsh4FLCs3F2EHfIMLduaZKk4-jcMfl5poVJNDfkMgOgF9nLFP-6ThR8hynRvdz-XNvA6gjabCDJh1SREeNFSz0UyWzQqPf9DBE8OkU9Q; .L2SautomhaADM.Session=CfDJ8AJKULb7m8tPn64cOPxcBoc79wfdygfvPNetOTugEN2RIAg1alPJChj1cynm2XW5s9r92u8jpxj7a0SGh0aC4j1Q3YgCNqqQfA%2FnwgQ1z2F1VyK6Ijq1hEvqjCFWZqP7I1kqaEPWMdBEOkFEtFyjbP231Izs%2BkZu71bEgltKJ1uX; .AspNetCore.Antiforgery.aGNkr_46uKo=CfDJ8AJKULb7m8tPn64cOPxcBofzaRavDIBbi04Lwz16jpcmWrgyUiMtSz80gaHPFJFeb-gnMnG-9di0q-4iRQ5f9ZBcpwG7aKel2oGwZS8ExfD55WewyTBQDaIrpifoiYf_zvNx8IgywdVWT85AMocIxrI; .Link2StaffADM.Session=CfDJ8AJKULb7m8tPn64cOPxcBoef96G5M8qSvpesfbzCszeeOV9HWp3AIIsJESEYOKwrRGvpN%2F2vM7D43046LqOGTEzvRHLE1A46kg0R%2BVkfBrVOgYLnCIzeHpyDB5E3nA7BNB1%2BxngL0EqsP1GMTWoyVFOIias%2FdVN3ZBNBUOEU6nl5; .AspNetCore.Cookies=CfDJ8AJKULb7m8tPn64cOPxcBockkzweYOdX98SLXr_Iech3OOJxDjAeV7pSFtdP682BzYgY5HpdxfFB9OJtc-ePcsfGBGGtLo9C3nhchrcMPUWQYOQmt_HW4iMX2VgwVwSr1d2OuBgW-Y-ki2wv8kM3hmtCdfoPH4_qQti3_BXa8rhfElf4mlQDJaLRBqZdt4XMwQNC5xoxScVnHgGLlAaw8-\_dAQfW4_0qje9cYcdlho6oJZs1wGlJi65d7usOdP6KENOMZwTkAesi-IZ7XF0JRSEPN2lw2O7tFySAg1qmpx5paGe2ouEasAfQKmxho5PCCPc9HsR6xVQ_k5D5OxyoSKdajbHBBiok-1z3EEj6JQM_2F2eL3TmoNF7gS8yr7fr2OG9HCT-iVQIUYS89VnSXgBKU2CqoIzrDoWmAelrkVltJ6BjGAY1RSaJ-hYdEqsE4gOrigin: http://localhost:5000Referer: http://localhost:5000/ChiamateList?recperpage=ALLContent-Length: 105307sec-ch-ua-platform: "Windows"sec-ch-ua: "Chromium";v="146", "Not-A.Brand";v="24", "Google Chrome";v="146"sec-ch-ua-mobile: ?0Sec-Fetch-Site: same-originSec-Fetch-Mode: corsSec-Fetch-Dest: empty
4

By default ASP.NET Core limits the number of form fields it will parse to 1024. When your POST request contains more than 1024 key–value pairs, ASP.NET Core throws the error.

You can add the following line to your Program.cs to increase the limit:

builder.Services.Configure<FormOptions>(options =>
{
    options.ValueCountLimit = int.MaxValue; // or a specific number
});