The firewall blocks too many parameters in one call

The firewall blocks too many parameters in one call

Posted by: laura.persyn on 22 November 2021, 8:28 am EST

• 

  laura.persyn

  • Post Options:
  • Link
    Copy

  Posted 22 November 2021, 8:28 am EST

  In Spread.NET 14, in an ASP.NET MVC 5 environment, we found strange behavior when hiding columns, the number of hidden columns seems to vary each time.

  We found the reason for this problem to be that the call has too many parameters, because the spreadcomponent synchronises the full state with the client to the server, which means that one call contains all cells. (Each cell is one parameter)

  Our firewall refuses calls with more than 5000 parameters, this is the max number of parameters it could accept.
  
  We calculated that with our usecase we should be able to go up to 50 rows en 250 columns which results in 12500 parameters.

  Is it possible to split this call into groups of 5000 or less parameters?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 24 November 2021, 7:28 am EST

  Hi,

  We have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SPNET-21775.

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 24 March 2023, 4:57 am EST - Updated 24 March 2023, 5:02 am EST

  Hi,

  Devs investigated the issue and suggested the following 2 workarounds.

  1. You can place Spread control in a form (with method = “post”) to force data sent via form instead. Change code in Layout.cshtml page or page contains Spread (exp: Index.cshtml) as below images.
     
     

  2 you may off generation the hidden data as below setting:

  fpSpread.AllowGenerateHiddenData = false

  regards,
  
  Avinash