Jul 28 2017 04:02 PM
Hello,
I get this error when using Azure Data Factory for copying from blob to azure SQL DB:-
Database operation failed. Error message from database execution : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed..
I am able to connect to my DB using SSMS and I have enabled firewall to connect to Azure services.
Has anyone faced this error when using ADF / know how to fix it?
Thanks in advance.
Aug 01 2017 11:55 PM
I have this error right now. I can tell you that I have successfully imported other files. It's only this particular file with the issue. The import sits there for a long time so I actually think the connection is timing out. The log says:
Data Read: 1.18 MB Data Written: 0.00 Bytes Rows: 0
The difference between this file and the others is that this is a mutli column file (CSV) whereas other files as a single column
Aug 02 2017 05:56 PM
Hello,
3days ago, I was able to copy data from BLOB CSV to SQL Database by Azure Data Factory COPY PREVIEW without any errors. I tried to do the same datas and process again today and got the same error message with you. It's so simple schema and less data. I think we had better send a support ticket to MS, because we couldn't get the next action from this message...
In addition, ADF COPY from SQL Database to SQL DWH was successful today.
The following is the error messge I got from ADF
Aug 02 2017 07:06 PM
I have the exact same problem ... it was working fine about two days ago and I was happily running pipelines from CSV files on blob to Azure SQL ... then all of a sudden they begin to fail with the following helpful message:
Failed execution
--
Database operation failed. Error message from database execution : ExecuteNonQuery requires an open and available Connection. The connection's current state is closed..
Less
Run ID
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Data read: 2.67 MB
Data written: 53.63 MB
Rows: 70000
--
Skipped row count: 108
--
Execution location: West US
I wonder whether this is only occuring in West US or all data centres.
Is there anyway in which to increase the time the conneciton is held open for, either in the pipeline or SQL?
Thanks
Nov 20 2017 03:52 AM
Hi,
I also had this error. Checking back, the only difference I had between previous successful jobs was a request to log it to a blob storage. When I rerun the pipeline without this it worked for me (or actually gave another cryptic error message "The service has encountered an error processing your request. Please try again. Error code 4815."). So remove the request for logging and I was back where I was before!