Forum


20:00

08/02/2010

I have the following code which gets a JSON result set back from a WCF service for exporting to Excel. Any result sets that are larger than 2000 records appears to just timeout, even though I have specified a lofty timeout period for the request.
.navButtonAdd('#participationPager', {
caption: 'Export',
title: 'Export to Excel',
buttonicon: 'ui-icon-transferthick-e-w',
onClickButton: function() {
$.ajax({
type: 'GET',
url: 'services/TPServices.svc/GetAdvancedSearchTpResults',
data: excelParticipationCriteria,
timeout: 5000000,
success: function(data) {
exportGridDataToExcel("#participationList", data);
}
})
}
I tried putting the following in my web.config, but it did not have any affect:
<system.web.extensions>
<scripting>
<webServices>
<jsonSerialization maxJsonLength="500000"></jsonSerialization>
</webServices>
</scripting>
</system.web.extensions>
</configuration>
Does anyone have any suggestions?
13:16

Moderators
30/10/2007

Hello,
I think that this is not related to jqGrid, but rather to your server side code.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
16:08

08/02/2010

tony said:
Hello,
I think that this is not related to jqGrid, but rather to your server side code.
Regards
Tony
This was my initial assessment as well, however my server side code is definitely returning the results. I believe the JSON string is too large to be parsed. Right now I get an error back from the Ajax call with XMLHttpRequest status code of 12152.
12:49

Moderators
30/10/2007

Hello,
The clear test if this is a jqGrid issue is to try without using jqGrid
$("#mybutton").click(function(){
$.ajax({
....
});
});
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
67 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66