problem with making connection between Python and Viya

touwen_k — Mon, 03 May 2021 16:03:50 GMT

Hello,

I am trying for the first time to get connection between python and SAS Viya. But I am getting a lot of errors. Not sure it this issue with certificates. Pls advise

Traceback (most recent call last):
File "C:/Users/KarolinaTouwen/AppData/Local/Programs/Python/Python38/proby/connection.py", line 8, in <module>
conn = swat.CAS(host, port, userid, password, protocol = "https")
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\connection.py", line 345, in __init__
for asname, value in self.retrieve('builtins.help',
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\connection.py", line 1693, in retrieve
results = self._get_results(getnext(self, datamsghandler=datamsghandler),
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\connection.py", line 1772, in _get_results
for key, value in response:
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\response.py", line 333, in __iter__
yield key, cas2py(_sw_result, self.soptions, connection=self._connection)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\transformers.py", line 480, in cas2py
return _sw_value.toPython(_sw_value, soptions,
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\rest\value.py", line 103, in toPython
return _value2python(self._value, soptions, errors, connection, ctb2tabular,
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\rest\value.py", line 40, in _value2python
return ctb2tabular(REST_CASTable(_value), soptions, connection)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\cas\transformers.py", line 379, in ctb2tabular
cdf = cdf.reshape_bygroups(bygroup_columns=optbycol,
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\dataframe.py", line 828, in reshape_bygroups
dframe = self[self.columns]
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\dataframe.py", line 499, in __getitem__
result = super(SASDataFrame, self).__getitem__(*args, **kwargs)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\core\frame.py", line 3036, in __getitem__
data = self._take_with_is_copy(indexer, axis=1)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\core\generic.py", line 3600, in _take_with_is_copy
result = self.take(indices=indices, axis=axis)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\core\generic.py", line 3589, in take
return self._constructor(new_data).__finalize__(self, method="take")
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\swat\dataframe.py", line 418, in __init__
self.attrs = attrs
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\core\generic.py", line 5478, in __setattr__
return object.__setattr__(self, name, value)
File "C:\Users\KarolinaTouwen\AppData\Local\Programs\Python\Python38\lib\site-packages\pandas\core\generic.py", line 246, in attrs
self._attrs = dict(value)
TypeError: 'NoneType' object is not iterable

Re: problem with making connection between Python and Viya

gwootton — Mon, 03 May 2021 16:20:15 GMT

If you think the issue might be with certificates you could try doing a request against the URL directly. For example:

import requests
url = "https://cas.demo.sas.com:8777"
requests.get(url)

I get this error if I don't trust the certificate:

SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate (_ssl.c:1108)

and if I remove verify it succeeds:

requests.get(url,verify=False)

Re: problem with making connection between Python and Viya

touwen_k — Fri, 07 May 2021 08:39:41 GMT

actually problem was the nieuwe feature of pandas, pls see for solution link below

Not compatible with latest Pandas version · Issue #64 · sassoftware/python-swat · GitHub

topic problem with making connection between Python and Viya in SAS Viya

problem with making connection between Python and Viya

Re: problem with making connection between Python and Viya

Re: problem with making connection between Python and Viya