We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

QueryBuilder large datasource json length

Thread ID:

Created:

Updated:

Platform:

Replies:

143190 Mar 8,2019 09:21 AM UTC May 31,2019 12:52 PM UTC ASP.NET MVC - EJ 2 2
loading
Tags: Query Builder
Nino
Asked On March 8, 2019 09:21 AM UTC

I have a QueryBuilder with a MVC Action datasource and UrlAdaptor. 

When the source contains many rows, the resulting json become too large throwing a MVC exception: "Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property."

I have already tried to increase the value of aspnet:MaxJsonDeserializerMembers in web.config with no results. 

I can't understand why the QueryBuilder needs to download all rows from datasource. Is it for managing the autocomplete? Is it possibile to disable this behavior? 









Silambarasan I [Syncfusion]
Replied On March 12, 2019 07:03 AM UTC

Hi Nino, 
 
# I can't understand why the QueryBuilder needs to download all rows from datasource. Is it for managing the autocomplete? Is it possibile to disable this behavior? 
 
Sorry for the inconvenience. In our EJ2 QueryBuilder, the entire dataSource has been requested at initial rendering for the purpose of handing conditions (i.e. in case of ‘IN’ operator to load all values in UI). And, we suspect that the cause of the reported issue “Error during serialization or deserialization using the JSON JavaScriptSerializer ... maxJsonLength property” might be occurred due to this when handling with more no of records. 
 
 However, we considered this as a defect and logged the defect report for “Issue with loading large dataSource for handling conditions”. The fix for this issue will be included in our Essential Studio 2019 Volume 1 Service Pack 1 release which is expected to be rolled-out in the month of April, 2019. 
 
You can also track the status of this bug through our feedback portal below. 
 
We will update you once released, and we appreciate your patience until then. 
 
Regards, 
Silambarasan 


Vinoth Kumar Sundara Moorthy [Syncfusion]
Replied On May 31, 2019 12:52 PM UTC

Hi Nino, 
 
Good day to you.  
 
We have added the fix for the issue with loading large dataSource for handling conditions in our latest version (17.1.49). Could you please update the latest package to check this fix and get back to us if you need any further assistance on this?  
 
Regards,  
Vinoth Kumar S 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;