Hi there.
We have deployed some simple WebServices, using WSF, in order to be able to reach content thought external applications. (i know that WSF is out of support but the deployment took place some time ago and the client does not want, at the moment, to move to D6.5). The main service call that is used it the one that returns a document from the repository. It is implemented using DQL on an indexed field.
The problem is, that out of the blue, the service call takes a huge amount of time to be processed, leading to timeouts. We have configured Tomcat 5.5.25 so that we have the access log in order to begin to track down what is going on. The behaviour that appears is as follows:
(Time for processing in ms ~ HTTP return code ~ WS Call)
15 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
813 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
79 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
375 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
31 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
188 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
31 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
16 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
31 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
46 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
16 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
63 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
15 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
128893 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
41063 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
126423 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
124361 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
59423 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
43235 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
6250 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
6031 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
35376 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
36031 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
172 ~ 500 ~ POST /ws/services/DocsExchange HTTP/1.1
16 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
31 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
47 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
15 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
62 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
42876 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
28266 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
43391 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
43610 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
29563 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
15 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
78 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
54032 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
140 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
16 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
141 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
16 ~ 200 ~ POST /ws/services/DocbaseCredentials HTTP/1.1
218 ~ 200 ~ POST /ws/services/DocsExchange HTTP/1.1
As you can see, the normal operation of the WebService appears as pairs of calls to the DocbaseCredentials (returns the ticket) and to the DocsExchange (returns the document). Out of the blue, the time needed to process the request peaks without any logical reason, and then returns back to normal operation (sometimes restart of Tomcat service is needed to resume to this state). Sometimes, not only the DocsExchange call but the DocbaseCredentials call takes a lot of time to be processed (done the documentation way).
Any clues on this particular behaviour? Any clues on where to look for problems to give us some clue?
The repository at the same time seems to be working ok (running simple dql through DA, or accessing it through a custom WDK application).
CS 5.3 SP5 - SQL Server 2000 - Windows2003 - Tomcat 5.5.25
Thanks in advance
Vangelis
