FilterService Timeout Error

Last post 11-21-2008, 9:45 AM by saba_rathnam. 6 replies.
Sort Posts: Previous Next
  •  11-19-2008, 8:25 AM 27342

    FilterService Timeout Error

    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;

    }

  •  11-20-2008, 7:14 AM 27362 in reply to 27342

    Re: FilterService Timeout Error

    How many seconds are you seeing before it times out?

     

  •  11-20-2008, 10:10 AM 27365 in reply to 27362

    Re: FilterService Timeout Error

    Peter

    It is alwasy 30 seconds.

    S.Saba

  •  11-20-2008, 12:22 PM 27368 in reply to 27365

    Re: FilterService Timeout Error

    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 Files\K2.net 2003\K2WS\WorkspaceService 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.
  •  11-21-2008, 5:28 AM 27378 in reply to 27368

    Re: FilterService Timeout Error

    Peter

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

    S.Saba

  •  11-21-2008, 8:02 AM 27384 in reply to 27378

    Re: FilterService Timeout Error

    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.

  •  11-21-2008, 9:45 AM 27387 in reply to 27384

    Re: FilterService Timeout Error

    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

View as RSS news feed in XML