1
Vote

Azure upload timeout

description

Hi,

We are moving our database to SQL Azure, and I am having issues at upload. It times out after some time, which I figured out is due to batch size. I changed the batch size from 10000 to 1000, it works.

Here is the log..
7/25/2013 12:04:59 PM
 --> Uploading data to Log
 --> BCP Command: bcp.exe "Pipelinelog.Log.Log" in "c:\SQLAzureMW\BCPData\Log.Log.dat" -E -n -b 10000 -a 16384 -q -S **********.database.windows.net -U "**********@**********" -P "**********"
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
**************************************************************
************************
7/25/2013 12:33:01 PM --> Sorry, but BCP upload process failed:

Starting copy...
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Text column data incomplete
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Server Native Client 10.0]TCP Provider: An existing connection was forcibly closed by the remote host.
SQLState = 08S01, NativeError = 10054
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Communication link failure
SQLState = 08S01, NativeError = 0


Processing finished at 7/25/2013 12:53:21 PM -- UTC -> 7/25/2013 7:53:21 PM
Total processing time: 0 hours, 48 minutes and 21 seconds

comments

ghuey wrote Jul 25, 2013 at 9:54 PM

Thanks for the info. A couple of questions if you don't mind:

How many rows are in your table?
Did this error happen on any other tables?
Did you just truncate the table and reload the data with a smaller batch size?
Does your table have a Text data type column?

Thanks again,
George