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
3  3062 
If you are using a SqlCommand object, set its CommandTimeout property.
--
TJoker, MCSD.NET
MVP: Paint, Notepad, Solitaire
*************** *************** **********
"John" <jo*********@ho tmail.com> wrote in message
news:u0******** ******@TK2MSFTN GP09.phx.gbl... 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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: levtoma |
last post by:
Hello,
We have an ADO.NET application using .NET version 1.1.4322 SP1. It is
calling stored procedures in a database that it never written to. The
only thing the stored procedures do is a select statement on a few
tables that are joined. In the last few weeks we have experienced
issues where, two or three of these stored procedures consistently
timeout. When we recompile the stored procedures, the problem goes
away for a period of...
|
by: Dan |
last post by:
All,
I have a Web Service that validates a piece of data. However, the database
that the data comes from is mamouth. So, it may take a long time for the
validation query to complete.
Unforuntatley, I tend to get a timeout message on my client which is not
good. I want the client to wait until it gets a response. Can I adjust the
amount of time that it waits? If so where is that at?
|
by: Andrew Robinson |
last post by:
Is there any way to dynamically set the timeout while using forms based
authentication? I want to change this value depending on the type of user
that logs into my system. I understand that this value lives in the config
file but can I change it in code?
Thanks,
-Andy
|
by: dadocsis |
last post by:
I have a custom VB.net application that runs a query against an SQL
server that takes more than 3 minutes. Right now after 3 minutes it
times out. So far after doing my research I have changed the following:
in web.config:
<system.web>
<httpRuntime executionTimeout="1000" maxRequestLength="2000000"/>
<sessionState
mode="InProc"
|
by: cj |
last post by:
I have a VB2005 windows app that uses a web reference to submit a soap
request to a business partner. I'm not the most knowledgeable on this
topic but what I have works and has worked for months now just fine. My
problem is when issue the command
RespStr=proxy.validate(soapmsg)
if our business partner has some kind of problem on their end it takes
forever for it to timeout and give me an error. How can I adjust the
timeout? I hope...
| | |
by: supercooper |
last post by:
I am downloading images using the script below. Sometimes it will go
for 10 mins, sometimes 2 hours before timing out with the following
error:
Traceback (most recent call last):
File "ftp_20070326_Downloads_cooperc_FetchLibreMapProjectDRGs.py",
line 108, i
n ?
urllib.urlretrieve(fullurl, localfile)
File "C:\Python24\lib\urllib.py", line 89, in urlretrieve
|
by: =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= |
last post by:
I tried:
<sessionState timeout="1">
</sessionState>
bounced IIS, and after 1 minute still had a session.
???
--
thanks - dave
|
by: =?Utf-8?B?ZG91Zw==?= |
last post by:
I support several intranet sites one of which had NO STATE. Even though
content has ASP extensions, it was all rendered HTML. Site had NO session or
application variables being managed. Site had no global.asa. IIS Manager
had site timeout set to 20 minutes.
We had to add an ASP include to pages, and that ASP include contained our
first session variable. Users then started complaining of timeouts and being
redirected to logout pages...
|
by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= |
last post by:
I have a asdp.net app which is form auth.
There is a problem,
The user logins and uses the app, sometimes user will be redirect to the
default login page, why?
Is the session timeout(default 20 mins), but the user is using the app?
Why?
|
by: ayush patel |
last post by:
Hi,
I developed a website using ASP. my client does not want the application to timeout even after 8-9 hours(if they are working). i know that connection timeout is set for timing out when the system is idle. but for the time when user is working on the website how should i set timeout values.
i changed session timeout and asp script timeout from IIS on the server but it does not seem to work. i have also changed values in web.config...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
