FilterService Timeout Error

  • 19 November 2008
  • 6 replies
  • 0 views

Badge +3

Hi


I am using filterservice to retrive all the folios and i am getting timeout error as follows


"Server was unable to process request. ---> Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."


i have tried increasing the timeout property of the web service and no luck. Do we have any parameter in the xml? Can anyone point to the right way to set the timeout?


below is the code i am using


 thanks


S.Saba


string strFolio = "something";


string strXML = "<?xml version="1.0" encoding="utf-8" ?><Search><Criteria>"+strFolio+"</Criteria>" +


"<Scope><Folio Search="True" />" +


"<Folder Search="False" />" +


"<ProcessName Search="False" />" +


"<ActivityName Search="False" />" +


"<EventName Search="False" />" +


"<ProcessData Search="False" />" +


"<ActivityData Search="False" />" +


"<Originator Search="False" />" +


"<Destination Search="False" />" +


"</Scope>" +


"<Filter><DateFilter Filter="False">" +


"<FromDate></FromDate>" +


"<ToDate></ToDate></DateFilter>" +


"<ProcessFilter Filter="False">" +


"<Folder>STAR</Folder>" +


"<Process>STAR Medical Request</Process></ProcessFilter></Filter>" +


"<Sort>Folio Asc</Sort></Search>";


System.Xml.XmlDocument folioSearch = new System.Xml.XmlDocument();


folioSearch.LoadXml(strXML);


K2Filter.FilterService wsK2 = new K2Filter.FilterService();


wsK2.Url = k2_server + "/K2V3/WorkspaceService/FilterService.asmx";


sK2.Credentials = SetCredential();


wsK2.Timeout = 600000;


System.Data.DataSet ds = null;


try


{


ds = wsK2.Find(folioSearch,

Environment.UserDomainName + """ + Environment.UserName, 1);


dvRes.DataSource = ds.Tables[0];


lblRes.Text = ds.Tables[0].Rows.Count.ToString() +

" Result(s) found";


}


catch (Exception ex)


{


lblRes.Text = ex.Message;


}


6 replies

Badge +13

How many seconds are you seeing before it times out?

 

Badge +3

Peter


It is alwasy 30 seconds.


S.Saba

Badge +13

The 30 seconds seems to be the CommandTimeOut default when the webservice tries to execute the stored procedure.  

I am having the same timeout issue with the Workspace search after 30 seconds, and I believe it uses the same FilterService.   

 The web.config in Program FilesK2.net 2003K2WSWorkspaceService is set to TimeOut of 120 seconds so I don't think it's used for that.

I'll open a call with support to see if there is a configurable value in config or if we can get an update.
Badge +3

Peter


Thanks and do let me know once you get a response for the ticket.


S.Saba

Badge +13

Response was to use Archival program or reduce search scope which does not work for us.

What is the size of your K2Log database and how much SQL Server memory is allocated?

We are going to upsize SQL Server for more memory to see if it'll reduce the query time.

Badge +3

Unfortunately the server side was maintained by another team and i do not have much information immediately. Let you know once i have access to the information.


thanks


S.Saba

Reply