topic Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System in Data Engineering

Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

dng — Thu, 01 Dec 2022 00:39:44 GMT

Hi everyone,

I've been stuck for the past two days on this issue with my Databricks JDBC driver and I'm hoping someone can give me more insight into how to troubleshoot. I am using the Databricks JDBC driver in RStudio and the connection was working fine until two days ago. There was a companywide Windows update and now cloud fetch is failing and I get the following error message:

Error in .jcall(rp, "I", "fetch", stride, block) :

java.sql.SQLException: [Simba][SparkJDBCDriver](500638) The file <blob URL> has not been downloaded successfully and the driver will not retry due to exceeding of the max retry limit 10, you can increase the max retry limit by setting MaxConsecutiveResultFileDownloadRetries.

The driver however is still working with small datasets <1MB. Has anyone ever encountered this issue and how would I fix it? Thank you in advance for your help.

Kind Regards,

Debbie

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

karthik_p — Fri, 02 Dec 2022 04:04:42 GMT

@Debbie Ng can you try to download 2.6.32 and test please

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

dng — Fri, 02 Dec 2022 04:10:15 GMT

@karthik p Where is v2.6.32 available? The Databricks JDBC Driver page only has v2.6.29 as the latest driver. Thank you for your help!

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

karthik_p — Fri, 02 Dec 2022 04:27:48 GMT

@Debbie Ng please check below maven repo Maven Repository: com.databricks » databricks-jdbc (mvnrepository.com)

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

dng — Fri, 02 Dec 2022 14:45:06 GMT

@karthik p No, unfortunately the same issue still occurs with the updated version.

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

Prabakar — Mon, 30 Jan 2023 17:09:08 GMT

@Debbie Ng From your message I see there was a windows update and this failure started. based on the conversation you tried latest version of the driver and still you face the problem. I believe this is something related to the Java version compatibility with the latest update.

Re: Databricks JDBC Driver v2.6.29 Cloud Fetch failing for Windows Operating System

rossd_42 — Wed, 30 Aug 2023 09:54:30 GMT

I have this issue today when I was given a new Oracle Linux VM.

I have an existing VM which works 100% but the new VM does not.

Driver version is the same on both VM'**bleep** and Java version is the same.

Python code that is running the query is the same.

openjdk version "1.8.0_382"

OpenJDK Runtime Environment (build 1.8.0_382-b05)

OpenJDK 64-Bit Server VM (build 25.382-b05, mixed mode)

Driver 2.6.27

Also tried 2.6.25, 29, 32 and 33 - same result

I need help with this please ASAP to meet an urgent business need.