Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
kell
Helper I
Helper I

FRESH DATA FROM DATABRICKS

Hi everyone,

 

I would like to refresh data, the source from 1 sandbox DataBricks (not created by me but I have permission rights) but this message occurs:

OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File ***: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File ***: An error had occurred while attempting to download the result file.The error is: [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate.. Since the connection has been configured to consider all result file download as retriable errors, we will attempt to retry the download.'..
 
The source is:
= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com", "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])
 
I try to add  [EnableQueryResultDownload="0"] as solved previous topic but did not work
= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com",[EnableQueryResultDownload="0"] , "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])
 
Please help
Thank you in advance!
1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

Hi @kell ,
Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
To solve this problem, you can try the following steps:
First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
You can refer to the following documents for more information
ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super Us...


Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

2 REPLIES 2
kell
Helper I
Helper I

thanks team

v-heq-msft
Community Support
Community Support

Hi @kell ,
Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
To solve this problem, you can try the following steps:
First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
You can refer to the following documents for more information
ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super Us...


Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors