question

holmaq-2709 avatar image
0 Votes"
holmaq-2709 asked ChandanaBasani-1835 edited

SSL Certificate error Synapse Analytics

Hi, when trying to read an excel file from ADLS Gen2 with synapse notebook and pandas i recieve the following error:


URLError : <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852)> Traceback (most recent call last): File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/util/decorators.py", line 208, in wrapper return func(args, *kwargs) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/base.py", line 310, in read_excel io = ExcelFile(io, engine=engine) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/base.py", line 819, in init self.reader = self.engines[engine](self.io) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/xlrd.py", line 21, in init super().init(filepath_or_buffer) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/base.py", line 348, in init filepath_or_buffer = BytesIO(urlopen(filepath_or_buffer).read()) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 223, in urlopen return opener.open(url, data, timeout) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 526, in open response = self._open(req, data) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 544, in _open '_open', req) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 504, in _call_chain result = func(*args) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 1392, in https_open context=self._context, check_hostname=self._check_hostname) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 1351, in do_open raise URLError(err) urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852)>



When running the same code locally from my machine, there's no issues. Code: import pandas as pd ReadExcel=pd.read_excel('https://datalake2devjohan.dfs.core.windows.net/testdata/Korttidsplatser.xlsx*?saskey*') print(ReadExcel) I've seen other examples where this is possible. Thank you.

azure-synapse-analyticsdotnet-ml-big-data
· 7
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@holmaq-2709 Thanks for using Microsoft Q&A !!
Looks like a certificate issue in your environment but we are looking into this and get back to you.

0 Votes 0 ·

@holmaq-2709 Following up as I haven't heard back. Can you please help providing the information to investigate it further ?

0 Votes 0 ·

@holmaq-2709 Please let me know if you are still facing this issue and kindly share the requested information for further investigation.

0 Votes 0 ·

@holmaq-2709 I am tracking this internally with the products team and need the requested information to investigate further. Please let me know if you are still having issues and need help on this one. Thanks

0 Votes 0 ·
Show more comments

1 Answer

ChandanaBasani-1835 avatar image
0 Votes"
ChandanaBasani-1835 answered ChandanaBasani-1835 edited

I responded as requested. Sent an email with details to azcommunity[at]microsoft[dot]com

Can you please clarify if this was resolved? Facing the exact same issue.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.