SqlBulkCopy unusual TimeOut Error

Posted by ChrisHDog on Stack Overflow See other posts from Stack Overflow or by ChrisHDog
Published on 2012-06-26T02:22:28Z Indexed on 2012/06/26 3:16 UTC
Read the original article Hit count: 269

Filed under:

sqlbulkcopy

|

timeoutexception

I have a SqlBulkCopy operation that is taking data from an MS-Access 2007 database (via OleDbConnection) and using SqlBulkCopy to transfer that data to a SQL Server database. This has previously been working and continues to work for one MS-Access database, but not the other.

I get the error message:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

It is hard to believe it is a timeout ast the oledbCommand.CommandTimeout = 0 the sqlBulkCopy.BulkCopyTimeout = 0 and on either side (MS-Access and SQL Server the timeouts have now been set to 0).

Are there other issues/exceptions that the above error message could be hiding? Is there a way to determine what the base cause of a sqlBulkCopy.WriteToServer exception is (there doesn't appear to be any inner exceptions etc...)

© Stack Overflow or respective owner

Related posts about sqlbulkcopy

Using SqlBulkCopy in a multithread scenario with ThreadPool issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I'm facing a dilemma (!). In a first scenario, i implemented a solution that replicates data from one data base to another using SQLBulkCopy synchronously and i had no problem at all. Now, using ThreadPool, i implemented the same in a assynchronously scenario, a thread per table, and all… >>> More
C# SqlBulkCopy and Data Entities

as seen on Stack Overflow - Search for 'Stack Overflow'
Guys, My current project consists of 3 standard layers: data, business, and presentation. I would like to use data entities for all my data access needs. Part of the functionality of the app will that it will need to copy all data within a flat file into a database. The file is not so big so I… >>> More
SqlBulkCopy and Entity Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
My current project consists of 3 standard layers: data, business, and presentation. I would like to use data entities for all my data access needs. Part of the functionality of the app will that it will need to copy all data within a flat file into a database. The file is not so big so I can use… >>> More
How to prevent duplicate records being inserted with SqlBulkCopy when there is no primary key

as seen on Stack Overflow - Search for 'Stack Overflow'
I receive a daily XML file that contains thousands of records, each being a business transaction that I need to store in an internal database for use in reporting and billing. I was under the impression that each day's file contained only unique records, but have discovered that my definition of unique… >>> More
Get an IDataReader from a typed List

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a List<MyObject> with a million elements. (It is actually a SubSonic Collection but it is not loaded from the database). I'm currently using SqlBulkCopy as follows: private string FastInsertCollection(string tableName, DataTable tableData) { string sqlConn = ConfigurationManager… >>> More

Related posts about timeoutexception

TimeoutException in simultaneous calls to WCF services from Silverlight application

as seen on Stack Overflow - Search for 'Stack Overflow'
Analysing log files I've noticed that ~1% of service calls ended with TimeoutException on the Silverlight client side. The services (wcf) are quite simple and do not perform long computations. According the log all calls to the services are always processed in less that 1 sec (even when TimeoutException… >>> More
TimeoutException when WCF Host and Client are in the same process

as seen on Stack Overflow - Search for 'Stack Overflow'
I've ran into a really weird problem. I am building a heavily distributed application where each app instance can either be a Host and/or Client to a WCF-Service (very p2p-like). Everything works fine, as long as the Client and the targeted Host (By which I mean the app, not the Host, since currently… >>> More
How to Fix “Error occurred in deployment step ‘Activate Features’: System.TimeoutException:”

as seen on YBBest - Search for 'YBBest'
Problem: When deploying a SharePoint2013 workflow using Visual Studio, I got the following Error: Error occurred in deployment step ‘Activate Features’: System.TimeoutException: The HTTP request has timed out after 20000 milliseconds. —> System.Net.WebException: The request… >>> More
Deploying an EAR to JBOSS times out (org.rhq.core.pc.inventory.TimeoutException:)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to deploy an ear file to JBOSS AS (defalut server). The application is the mavenised version of examples of SeamInAction book. When I copy the file to $JBOSS_HOME/server/default/deploy, I don't get any exception but the application doesn't respond, after some time trying to access… >>> More
TimoutException occurs over a network but not locally

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program with three WCF services and when I run them locally (i.e: Server and Clients are all on localhost) everything works. However when I test them across a network I get a TimoutException on two services but not the other. I've disabled the firewalls on all the machines involved in the… >>> More