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

[ShuchitaBora]

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.

Attempted to run program /usr/bin/java with the following parameters:['/usr/bin/java', '-classpath', '/Users/.bora/Library/Python/3.9/lib/python/site-packages/saspy/java/saspyiom.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/log4j-1.2-api-2.12.4.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/log4j-api-2.12.4.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/log4j-core-2.12.4.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sas.security.sspi.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sas.core.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sas.svc.connection.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sas.rutil.jar:/Users/xxxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sas.rutil.nls.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/iomclient/sastpj.rutil.jar:/Users/xxxx/Library/Python/3.9/lib/python/site-packages/saspy/java/thirdparty/glassfish-corba-intern...:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/thirdparty/glassfish-corba-omgapi....:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/thirdparty/glassfish-corba-orb.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/thirdparty/pfl-basic.jar:/Users/xxx/Library/Python/3.9/lib/python/site-packages/saspy/java/thirdparty/pfl-tf.jar', 'pyiom.saspy2j', '-host', 'localhost', '-stdinport', '63342', '-stdoutport', '63343', '-stderrport', '63344', '-iomhost', 'odaws01-usw2.oda.sas.com;odaws02-usw2.oda.sas.com;odaws03-usw2.oda.sas.com;odaws04-usw2.oda.sas.com', '-iomport', '8591', '-user', 'sbora9@gatech.edu', '-lrecl', '1048576', ''] No SAS process attached. SAS process has terminated unexpectedly.

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.

[sastpw]

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-...

[sastpw · Accepted solution]

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