Error when connecting to ODA from jupyter An exception was thrown during the encryption key exchange

ShuchitaBora — Mon, 13 Feb 2023 20:36:49 GMT

1. Here are my sascfg_personal.py

import saspy
fd = open(saspy.SAScfg)
cfg = fd.read()
fd.close()
print(cfg)

-------------

SAS_config_names=['oda']

oda = {'java' : '/usr/bin/java', #US Home Region 1 'iomhost' : ['odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'], 'iomport' : 8591, 'authkey' : 'oda', 'encoding' : 'utf-8' }

But when i do this then i get error

import saspy
saspy
saspy.list_configs()
saspy.SAScfg
sas = saspy.SASsession()
sas

Using SAS Config named: oda

We failed in getConnection

An exception was thrown during the encryption key exchange. SAS process has terminated unexpectedly.

Pid State= (32503, 64000) SAS Connection failed. No connection established.

Double check your settings in sascfg_personal.py file.

Invalid response from SAS on inital submission. printing the SASLOG as diagnostic

---------------------------------------------------------------------------
SASIOConnectionError                      Traceback (most recent call last)
Cell In[5], line 5
      3 saspy.list_configs()
      4 saspy.SAScfg
----> 5 sas = saspy.SASsession()
      6 sas

File ~/Library/Python/3.9/lib/python/site-packages/saspy/sasbase.py:608, in SASsession.__init__(self, **kwargs)
    605    pass
    607 if failed:
--> 608    raise SASIOConnectionError(res)
    610 if self.pyenc is not None:
    611    if self._io.sascfg.encoding != '':

SASIOConnectionError: Failure establishing SASsession.
 No SAS process attached. SAS process has terminated unexpectedly.

Re: Error when connecting to ODA from jupyter An exception was thrown during the encryption key exch

sastpw — Tue, 14 Feb 2023 19:51:28 GMT

You'll need to add the 3 encryption jars to your saspy deployment. See the instructions here: https://sassoftware.github.io/saspy/configuration.html#attn-as-of-saspy-version-3-3-3-the-classpath-is-no-longer-required-in-your-configuration-file

Re: Error when connecting to ODA from jupyter An exception was thrown during the encryption key exch

sastpw — Fri, 17 Feb 2023 21:40:38 GMT

Were you able to connect? Sorry that was a terse reply, I was on vacation and just typing in on my phone. ODA recently upgraded their SAS deployments to 9.4M7, and M7 had some change in it that requires the encryption jars, which we can't put on github, thus having to make uses add them to the deployments manually. At least for ODA, where users don't have a deployment with the jars in it, you can just download them from the link in that SASPy doc. Hopefully you're up and running?

Thanks,

Tom

topic Error when connecting to ODA from jupyter An exception was thrown during the encryption key exchange in Developers

Error when connecting to ODA from jupyter An exception was thrown during the encryption key exchange

Re: Error when connecting to ODA from jupyter An exception was thrown during the encryption key exch

Re: Error when connecting to ODA from jupyter An exception was thrown during the encryption key exch