Error message: "Failed to save modification. Error returned: 'OLE DB or ODBC error...

[NovaBI]

Hi all,

a user tried to get data from an Azure SQL server db. 

It is a big table, lots of columns and somtimes big precision. 

After 420k of rows, the user receives the following message:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] An error happened while reading the data from the provider: 'Invalid operation. The connection is closed'.'. ('.'. - sic!)

Not sure how to handle that. The same db caused trouble with the SQL driver in Informatica, as the connection times out after some time (around 1h or so).

Could that be the case as well here? 

If so (and even if not...), can someone give me an advise how to handle that issue? 

[v-yanjiang-msft]

Hi @NovaBI ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[NovaBI]

@v-yanjiang-msft I am not sure if the issue was resolved by the solution proposed, dont want to show a solution to other people that might be wrong. But you can close the thread.

[lbendlin]

certainly a possibility.  Specify a different value for the command timeout parameter in your source connection.

[NovaBI]

Thanks for the answer. 

It is still strange, as the user set the command timeout to 180m. It worked then. But the load only takes like 10 to 15 minutes.

On my side, it worked without the command timeout. It is working now, but it still apprears odd to me.