timeout issues

[John]

Hello,

I have a program that is syncing data from an access database to a
sql database nightly. The problem is that all of the sudden, program has
been working for months now, that we are getting a timeout error during the
syncing of information for a specific table. The table, call it table A, is
sent to a webservice via a dataset and then the webservice updates sql. How
can I increase the timeout for this specific function? The table has about
6000 rows of data that need to be synced. Thanks in advance.

John

[Herfried K. Wagner [MVP]]

Re: timeout issues

Hello,

"John" <jonashbaugh@ho tmail.com> schrieb:[color=blue]
> I have a program that is syncing data from an access
> database to a sql database nightly. The problem is that all of
> the sudden, program has been working for months now,
> that we are getting a timeout error during the
> syncing of information for a specific table.[/color]

This is a VB.NET language group. Notice that you will have a better chance
to get an answer if you post to the ADO.NET newsgroup in future:

news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups/default.asp?url=/newsgroups/loadframes.asp?icp=msdn&slcid=us&newsgroup=microsoft.public.dotnet.framework.adonet

--
Herfried K. Wagner
MVP · VB Classic, VB.NET

http://www.mvps.org/dotnet

[TJoker .NET [MVP]]

Re: timeout issues

If you are using a SqlCommand object, set its CommandTimeout property.

--
TJoker, MCSD.NET
MVP: Paint, Notepad, Solitaire

*************** *************** **********


"John" <jonashbaugh@ho tmail.com> wrote in message
news:u0keHBrfDH A.1764@TK2MSFTN GP09.phx.gbl...[color=blue]
> Hello,
>
> I have a program that is syncing data from an access database to a
> sql database nightly. The problem is that all of the sudden, program has
> been working for months now, that we are getting a timeout error during[/color]
the[color=blue]
> syncing of information for a specific table. The table, call it table A,[/color]
is[color=blue]
> sent to a webservice via a dataset and then the webservice updates sql.[/color]
How[color=blue]
> can I increase the timeout for this specific function? The table has about
> 6000 rows of data that need to be synced. Thanks in advance.
>
> John
>
>[/color]

[John]

Re: timeout issues

Hello,

We have a problem with an app of ours. The app syncs an access database to a
sql database. The access database resides on a tablet pc that is being
synced via a dsl connection to our t1 using .Net Webservices. Below is part
of the trace. I am unfamiliar with what it means. It gives a time out on the
application when it tries to run this query.

SELECT projectid, unit, bldg, lot, plantype, unitplan, phase, isdeleted,
updatedate FROM seqsheets WHERE updatedate > '9/12/2003'

We have changed the timeout connections between the webservice and the
database to 10 minutes. We have also changed the time between the
application and the webservice to 10 minutes but it still bombs out so I
think it's somewhere in the database. If the application is ran within the
LAN it works fine it is when is coming over the wire. Any help would be
greatly appreciated.

John

~trace~

EventClass Start Time End Time Text Data duration cpu error success
objectid integerdata nestlevel databasename hostname servername loginname
reads writes clientprocessid spid
SQL:StmtComplet ed 11:47.9 11:47.9 SELECT connect FROM tstConnect 16 15
1 0 webserver1 dbserver1 test 50 0 0 59
SQL:BatchComple ted 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_connec tion webserver1
dbserver1 test 0 59
RPC:Completed 11:47.9 11:47.9 exec sp_reset_connec tion 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:ExecContextH it 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:StmtComplete d 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