Time out issue

[John]

Hello,

I am trying to sync an access database table using datasets from a
remote to our server. It has been giving us a time out lately. I setup a
trace on the webservice and got a status code 500. Any ideas on where to
proceed from here on how to resolve the issue? Thanks in advance.

John

--trace below--

Request Details

Request Details
Session Id: Request Type: POST
Time of Request: 9/24/2003 5:02:06 PM Status Code: 500
Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)
Control Tree
Control Id Type Render Size Bytes (including children) Viewstate Size Bytes
(excluding children)
Headers Collection
Name Value
Content-Length 782108
Content-Type text/xml; charset=utf-8
Authorization Negotiate
TlRMTVNTUAADAAAAGAAYAGAAAAAYABgAeAAAAAAAAABAAAAAFAAUAEAAAAAMAAwAVAAAABAAEACQ
AAAANYKI4EkARQBhAHMAcABfAFUAUwBlAFIASABIADMALQAxADcA8JhNlnGhg9EAAAAAAAAAAAAA
AAAAAAAAD15xh+WxNUAsFLJCGyCx3YeQDSnn1bSmU9jloxhY/CHY6fcVuOCAgw==
Expect 100-continue
Host localhost
User-Agent Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client
Protocol 1.0.3705.288)
SOAPAction "http://localhost/service/service.asmx/Iseqsheet"
Server Variables
Name Value
ALL_HTTP HTTP_CONTENT_LENGTH:782108 HTTP_CONTENT_TYPE:text/xml;
charset=utf-8 HTTP_AUTHORIZATION:Negotiate
TlRMTVNTUAADAAAAGAAYAGAAAAAYABgAeAAAAAAAAABAAAAAFAAUAEAAAAAMAAwAVAAAABAAEACQ
AAAANYKI4EkARQBhAHMAcABfAFUAUwBlAFIASABIADMALQAxADcA8JhNlnGhg9EAAAAAAAAAAAAA
AAAAAAAAD15xh+WxNUAsFLJCGyCx3YeQDSnn1bSmU9jloxhY/CHY6fcVuOCAgw==
HTTP_EXPECT:100-continue HTTP_HOST:localhost HTTP_USER_AGENT:Mozilla/4.0
(compatible; MSIE 6.0; MS Web Services Client Protocol 1.0.3705.288)
HTTP_SOAPACTION:"http://localhost/service/service.asmx/Iseqsheet"
ALL_RAW Content-Length: 782108 Content-Type: text/xml; charset=utf-8
Authorization: Negotiate
TlRMTVNTUAADAAAAGAAYAGAAAAAYABgAeAAAAAAAAABAAAAAFAAUAEAAAAAMAAwAVAAAABAAEACQ
AAAANYKI4EkARQBhAHMAcABfAFUAUwBlAFIASABIADMALQAxADcA8JhNlnGhg9EAAAAAAAAAAAAA
AAAAAAAAD15xh+WxNUAsFLJCGyCx3YeQDSnn1bSmU9jloxhY/CHY6fcVuOCAgw== Expect:
100-continue Host: localhost User-Agent: Mozilla/4.0 (compatible; MSIE 6.0;
MS Web Services Client Protocol 1.0.3705.288) SOAPAction:
"http://localhost/service/service.asmx/Iseqsheet"
APPL_MD_PATH /LM/W3SVC/3/Root/service
APPL_PHYSICAL_PATH e:\inetpub\service\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH 782108
CONTENT_TYPE text/xml; charset=utf-8
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID 3
INSTANCE_META_PATH /LM/W3SVC/3
LOCAL_ADDR
PATH_INFO /service/service.asmx
PATH_TRANSLATED e:\inetpub\service\service.asmx
QUERY_STRING
REMOTE_ADDR
REMOTE_HOST
REMOTE_PORT 1075
REQUEST_METHOD POST
SCRIPT_NAME /service/service.asmx
SERVER_NAME localhost
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/5.0
URL /service/service.asmx
HTTP_CONTENT_LENGTH 782108
HTTP_CONTENT_TYPE text/xml; charset=utf-8
HTTP_AUTHORIZATION Negotiate
TlRMTVNTUAADAAAAGAAYAGAAAAAYABgAeAAAAAAAAABAAAAAFAAUAEAAAAAMAAwAVAAAABAAEACQ
AAAANYKI4EkARQBhAHMAcABfAFUAUwBlAFIASABIADMALQAxADcA8JhNlnGhg9EAAAAAAAAAAAAA
AAAAAAAAD15xh+WxNUAsFLJCGyCx3YeQDSnn1bSmU9jloxhY/CHY6fcVuOCAgw==
HTTP_EXPECT 100-continue
HTTP_HOST localhost
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client
Protocol 1.0.3705.288)
HTTP_SOAPACTION "http://localhost/service/service.asmx/Iseqsheet"

 

[John]

Michael,

I will take a look at that thanks. I ran a sql trace and it seems to
be dying between the webservice and the sql database(both different servers)
Is there a timeout option that I might need to increase? The query was
trying to return 2996 rows of data.

John

 

[John]

Michael,

I have read those and think it's something we can do however at the
moment I do not believe that is the problem. We setup some traces and below
is the sql trace any ideas? I think it's timing out somewhere with sql.

EventClass Start Time End Time Text Data duration cpu error success
objectid integerdata nestlevel databasename hostname servername loginname
reads writes clientprocessid spid
SQL:StmtCompleted 11:47.9 11:47.9 SELECT connect FROM tstConnect 16 15
1 0 webserver1 dbserver1 test 50 0 0 59
SQL:BatchCompleted 11:47.9 11:47.9 SELECT connect FROM tstConnect 16
15 webserver1 dbserver1 test 50 0 0 59
RPC:Starting 11:47.9 exec sp_reset_connection webserver1
dbserver1 test 0 59
RPC:Completed 11:47.9 11:47.9 exec sp_reset_connection 0 0
webserver1 dbserver1 test 0 0 0 59
RPC:Starting 11:47.9 exec sp_executesql N'SELECT projectid, unit,
bldg, lot, plantype, unitplan, phase, isdeleted, updatedate FROM seqsheets
WHERE updatedate > ''9/12/2003''' webserver1 dbserver1 test 0 59
SP:ExecContextHit 11:47.9 289550664 webserver1 dbserver1 test
0 59
SP:StmtStarting 11:47.9 SELECT projectid, unit, bldg, lot, plantype,
unitplan, phase, isdeleted, updatedate FROM seqsheets WHERE updatedate >
'9/12/2003' 289550664 2 webserver1 dbserver1 test 0 59
Scan:Started 11:47.9 1 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 1 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 1 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 1 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 9 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 9 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 9 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 9 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 9 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 9 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 9 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 9 webserver1 dbserver1 test 0 0 59
Scan:Started 11:47.9 9 webserver1 dbserver1 test 0 59
Scan:Stopped 11:47.9 9 webserver1 dbserver1 test 0 0 59
Audit Object Permission Event 11:47.9 SELECT projectid, unit, bldg,
lot, plantype, unitplan, phase, isdeleted, updatedate FROM seqsheets WHERE
updatedate > '9/12/2003' 1 2 remote webserver1 dbserver1 test 0 59
Degree of Parallelism (7.0 Insert) 11:47.9 0 webserver1
dbserver1 test 0 59
Execution Plan 11:47.9 Execution Tree webserver1 dbserver1
-------------- webserver1 dbserver1
Clustered Index
Scan(OBJECT[remote].[dbo].[seqsheets].[PK_seqsheets]),
WHERE[seqsheets].[updatedate]>'Sep 12 2003 12:00AM'))
webserver1 dbserver1
17 0X00000000 5380 VCNET001 dbserver1 test webserver1 dbserver1 0
59
Show Plan All 11:47.9 5380 webserver1 dbserver1 test 0 59
Show Plan Text 11:47.9 5380 webserver1 dbserver1 test 0 59
Scan:Started 11:47.9 1790629422 webserver1 dbserver1 test 0
59
Scan:Stopped 11:48.0 1790629422 webserver1 dbserver1 test 0
0 59
Show Plan Statistics 11:48.0 5380 webserver1 dbserver1 test
0 59
Scan:Stopped 11:48.0 1790629422 webserver1 dbserver1 test 0
0 59
SP:StmtCompleted 11:47.9 11:48.0 SELECT projectid, unit, bldg, lot,
plantype, unitplan, phase, isdeleted, updatedate FROM seqsheets WHERE
updatedate > '9/12/2003' 47 32 289550664 5384 2 webserver1 dbserver1 test
115 0 0 59
RPC:Completed 11:47.9 11:48.0 exec sp_executesql N'SELECT projectid,
unit, bldg, lot, plantype, unitplan, phase, isdeleted, updatedate FROM
seqsheets WHERE updatedate > ''9/12/2003''' 46 32 webserver1 dbserver1
test 123 0 0 59
Audit Logout 09:24.5 13:53.0 268516 173 1 webserver1 dbserver1
test 2063 0 0 62
Audit Logout 01:34.0 17:03.0 929016 4512 1 webserver1 dbserver1
test 118850 0 0 59
TraceStop 19:26.7

 

[John]

Michael,

I figured it out! It was actually timing out between the application and
the webservice. I increased the timeout of the webservice call and it works.
Thanks for all of the suggestions and help. I appreciate it .

John