Time out issue

Discussion in 'ASP .Net Web Services' started by John, Sep 25, 2003.

  1. John

    John Guest

    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, Sep 25, 2003
    #1
    1. Advertising

  2. John

    John Guest

    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


    "Michael Pearson" <> wrote in message
    news:...
    > John, what you might want to do is thread this out so that it does not

    time
    > out.
    >
    > Basically, when someone calls the webmethod, kick off a thread and pass

    that
    > thread the dataset.
    > The thread will take as long as it needs to do the update, and then die.
    >
    > Here's a few links that might help:
    > http://www.fawcette.com/vsm/2002_11/magazine/features/chester/
    >

    http://www.dotnetjunkies.com/howTo/...B0E0-814B-4A7C-9686-E88A71D243E6&ForumID=4231
    >
    > http://www.sitepoint.com/article/1017/3
    > Michael
    >
    >
    > "John" <> wrote in message
    > news:...
    > > 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"
    > >
    > >

    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003
    >
    >
     
    John, Sep 26, 2003
    #2
    1. Advertising

  3. John

    John Guest

    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

    "Michael Pearson" <> wrote in message
    news:...
    > John, what you might want to do is thread this out so that it does not

    time
    > out.
    >
    > Basically, when someone calls the webmethod, kick off a thread and pass

    that
    > thread the dataset.
    > The thread will take as long as it needs to do the update, and then die.
    >
    > Here's a few links that might help:
    > http://www.fawcette.com/vsm/2002_11/magazine/features/chester/
    >

    http://www.dotnetjunkies.com/howTo/...B0E0-814B-4A7C-9686-E88A71D243E6&ForumID=4231
    >
    > http://www.sitepoint.com/article/1017/3
    > Michael
    >
    >
    > "John" <> wrote in message
    > news:...
    > > 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"
    > >
    > >

    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003
    >
    >
     
    John, Sep 26, 2003
    #3
  4. John

    John Guest

    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

    "Michael Pearson" <> wrote in message
    news:%...
    > Well 3000 rows is not a "lot" in my book, but if you are getting SQL
    > timeouts, then you need to do one of two things:
    > 1. Optimise your query. Hit the Forums at SQLTeam.com I post there. We
    > can help
    >
    > 2. Increase your CommandTimeout on your Command object in the webservice.
    >
    > Can you post the actual error message??
    >
    > Michael
    > "John" <> wrote in message
    > news:%...
    > > 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
    > >
    > >
    > > "Michael Pearson" <> wrote in

    > message
    > > news:...
    > > > John, what you might want to do is thread this out so that it does not

    > > time
    > > > out.
    > > >
    > > > Basically, when someone calls the webmethod, kick off a thread and

    pass
    > > that
    > > > thread the dataset.
    > > > The thread will take as long as it needs to do the update, and then

    die.
    > > >
    > > > Here's a few links that might help:
    > > > http://www.fawcette.com/vsm/2002_11/magazine/features/chester/
    > > >

    > >

    >

    http://www.dotnetjunkies.com/howTo/...B0E0-814B-4A7C-9686-E88A71D243E6&ForumID=4231
    > > >
    > > > http://www.sitepoint.com/article/1017/3
    > > > Michael
    > > >
    > > >
    > > > "John" <> wrote in message
    > > > news:...
    > > > > 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"
    > > > >
    > > > >
    > > >
    > > >
    > > > ---
    > > > Outgoing mail is certified Virus Free.
    > > > Checked by AVG anti-virus system (http://www.grisoft.com).
    > > > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003
    > > >
    > > >

    > >
    > >

    >
    >
    > ---
    > Outgoing mail is certified Virus Free.
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.520 / Virus Database: 318 - Release Date: 9/18/2003
    >
    >
     
    John, Sep 29, 2003
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?cm9kY2hhcg==?=

    time out issue

    =?Utf-8?B?cm9kY2hhcg==?=, Jan 6, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    347
    Marina
    Jan 6, 2005
  2. Dale
    Replies:
    1
    Views:
    7,742
    Scott Allen
    Jun 7, 2005
  3. vasu devan
    Replies:
    0
    Views:
    455
    vasu devan
    Feb 24, 2006
  4. flamesrock
    Replies:
    8
    Views:
    552
    Hendrik van Rooyen
    Nov 24, 2006
  5. J
    Replies:
    2
    Views:
    712
Loading...

Share This Page