Forum Discussion
MicrosoftFailure during copy from blob to sql db using ADF
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
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!
