asp.net web api - Long running jQuery Ajax call -



asp.net web api - Long running jQuery Ajax call -

i have jquery ajax phone call request summary count web api services. web api process request , calls stored procedure (sql server) passing request parameters. stored procedure takes longer time (more 10 minutes process request. if stored procedure takes more 10 minutes jquery ajax phone call reporting unknown error status code 12002 or 12152(these errors relates connectivity issue) web server receives result stored procedure after 10 minutes. problem occuring on browser ie8.0 , ie9.0, firefox chrome receiving response if wait beyond 10 minutes. there solutions maintain communication live between server , client. have tried changing connection request header ajax "close","open","keep-alive" nil works. pls help me out.

java script code.

$.ajax({ type: "post", url: urlprefix + 'api/querydispatcher/summary', data: s, success: function (data) { window.clearinterval(int); $('#wait').hide(); $('#cancelsummary').hide(); $('#backgroundmodal').hide(); $("#tresulttotals").slidedown('slow'); deserializejson(eval(data)); if (!cancelsummaryrequest) { cancelsummaryrequest = true; $('#downloaddetailedreport').show(); } else { $('#tresulttotals').hide(); } }, $('#wait').hide(); $('#cancelsummary').hide(); $('#backgroundmodal').hide(); error_dialog(request.responsetext); } }); } server side (web api) code. [webinvoke(uritemplate = "summary", method = "post")] public list<queryresult> getsummaryreport_queue(jsonvalue summaryxml) { mycontext db = new mycontext(); datetime starttime = datetime.now; string sumxml = summaryxml["xmljson"].tostring().replace(@"\", "").replace(@"""", ""); //these 2 codes created json @ end of string need trim off. sumxml = sumxml.replace("u000du000a", ""); list<queryresult> results = null; xelement xxml = xelement.parse(sumxml); string reportid = xxml.descendants("reportid").firstordefault().value; string err = ""; seek { results = db.fnreportresult(sumxml).tolist(); } grab (exception e) { err = e.message + " : "+(e.innerexception!=null?e.innerexception.message : ""); throw e; } { ///--- record audit info. double runningtime = datetime.now.subtract(starttime).totalmilliseconds; string parameters = "applicationtype:query_dispatcher" + "||user:" + summaryxml["userid"].tostring().replace(@"\", "").replace(@"""", "") + "||session:" + summaryxml["session"].tostring().replace(@"\", "").replace(@"""", "") + "||running time:" + runningtime.tostring() + "||request type:summary report" + "||report id:" + reportid + "||error:" + err; audit saveaudit = new audit(); saveaudit.writeaudit("query_builder", parameters); //####-recording audit info } homecoming results; }

browsers have built in, internal timeouts may effecting this. see stackoverflow question more info on it: browser timeouts

as others have said, waiting 10 minutes ajax response bad, , browsers time out in default settings - if set ajax timeout absurdly high. uncertainty ever work.

you others have said , run query send users link results. however, solution run query on cron every x minutes , cache results. way, users can view results on demand , not have wait new url or wait prolonged period of time.

jquery asp.net-web-api

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more