topic Re: SASPy and SAS OnDemand for Academics - Connection Issue in SAS Programming

SASPy and SAS OnDemand for Academics - Connection Issue

pkm_edu — Thu, 26 Jan 2023 19:28:31 GMT

I used the code snippets from https://github.com/sassoftware/saspy/issues/518#issuecomment-1402644864.

My _authinfo: oda user ******i@****** password ***************

import saspy
sas_session = saspy.SASsession()
sas_session

Using SAS Config named: oda
We failed in getConnection
The application could not log on to the server "odaws04-usw2.oda.sas.com:8591". No server is available at that port on that machine.

SAS process has terminated unexpectedly. RC from wait was: 4294967290
SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

sascfg_personal.py.

SAS_config_names=['oda']
oda = {'java' : 'C:\Program Files (x86)\Common Files\Oracle\Java\javapath\java.exe',
#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'
}

Issue: The above code snippets do not work in my office laptop (shown below), although they work fine in my personal laptop.

Any help with a resolution of the issue would be greatly appreciated.

Re: SASPy and SAS OnDemand for Academics - Connection Issue

HarrySnart — Fri, 27 Jan 2023 11:31:05 GMT

Hi @pkm_edu , if the connection works on your personal laptop but not corporate device its likely to be due to a VPN/network issue in your corporate network. You may need to raise this with your internal IT team to get the SAS environmnet added to the safe domains. Thanks, Harry

Re: SASPy and SAS OnDemand for Academics - Connection Issue

sastpw — Fri, 27 Jan 2023 14:37:59 GMT

The error message shows it tried each of the 4 nodes but couldn't connect. In the doc, it shows there is a second US region with 2 different servers. Have you tried those? I'm assuming the US region is the correct one for you? https://support.sas.com/ondemand/saspy.html

#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'],
#US Home Region 2
#'iomhost' : ['odaws01-usw2-2.oda.sas.com','odaws02-usw2-2.oda.sas.com'],

Also note that ODA recently upgraded to SAS 9.4M7, and that release requires the 3 encryption jars in the IOM Client, which SASPy uses to communicate with SAS workspace servers. So you'll need to add those to the saspy deployment. The instructions for that are 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

Hopefully that's all you need, but let me know.

Thanks,

Tom

Re: SASPy and SAS OnDemand for Academics - Connection Issue

pkm_edu — Sat, 28 Jan 2023 04:55:07 GMT

I have revised sascfg_personal.py with the iomhost for Region 2 as suggested by sastpw. I am still getting the connection error.

SAS_config_names=['oda']
oda = {'java' : 'C:\Program Files (x86)\Common Files\Oracle\Java\javapath\java.exe',
#US Home Region 2
'iomhost' : ['odaws01-usw2-2.oda.sas.com','odaws02-usw2-2.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}

The three encryption jars were already in the IOM client.

C:\Users\pradip.muhuri\Anaconda3\Lib\site-packages\saspy\java\iomclient\sas.rutil.jar
C:\Users\pradip.muhuri\Anaconda3\Lib\site-packages\saspy\java\iomclient\sas.rutil.nls.jar
C:\Users\pradip.muhuri\Anaconda3\Lib\site-packages\saspy\java\iomclient\sastpj.rutil.jar

Using SAS Config named: oda
We failed in getConnection
The application could not log on to the server "odaws02-usw2-2.oda.sas.com:8591". No server is available at that port on that machine.

SAS process has terminated unexpectedly. RC from wait was: 4294967290
SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

Re: SASPy and SAS OnDemand for Academics - Connection Issue

pkm_edu — Sat, 28 Jan 2023 05:13:53 GMT

Thanks, Harry. What server address shall I give to the IT Team to check? SAS ODA works fine from this office computer.

Re: SASPy and SAS OnDemand for Academics - Connection Issue

pkm_edu — Sat, 28 Jan 2023 05:18:46 GMT

Hi Harry. For further information, I use https://odamid-usw2.oda.sas.com/SASStudio/main?locale=en_US&zone=GMT-05%253A00&ticket=ST-14456-cdQY7XIlaNQIDp7Tj33h-cas

to land in https://welcome.oda.sas.com/.

Re: SASPy and SAS OnDemand for Academics - Connection Issue

gouris_98 — Mon, 20 Feb 2023 15:14:08 GMT

tried sascfg_personal.py file with below content once with Region 1 and second time with Region 2

SAS_config_names=['oda']
oda = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
#US Home Region 1
#'iomhost' : ['odamid-usw2-2.oda.sas.com','odaws01-usw2.oda.sas.com','odaws02-usw2.oda.sas.com','odaws03-usw2.oda.sas.com','odaws04-usw2.oda.sas.com'],
#'iomhost' : ['odamid-usw2-2.oda.sas.com'],
#US Home Region 2
'iomhost' : ['odaws01-usw2-2.oda.sas.com','odaws02-usw2-2.oda.sas.com'],
#European Home Region 1
#'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'],
#Asia Pacific Home Region 1
#'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'],
#Asia Pacific Home Region 2
#'iomhost' : ['odaws01-apse1-2.oda.sas.com','odaws02-apse1-2.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'

in _authinfo file i have contents :

oda user *****n.*******@gmail.com password ***********

when i run

sas = saspy.SASsession()

gettin error

Using SAS Config named: oda
We failed in getConnection
The application could not log on to the server "odaws04-usw2.oda.sas.com:8591". The load balancing object spawner timed out.

SAS process has terminated unexpectedly. RC from wait was: 4294967290
SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

Attempted to run program C:\Program Files (x86)\Common Files\Oracle\Java\javapath\java.exe with the following parameters:['C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe', '-classpath', 'C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\saspyiom.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\log4j-1.2-api-2.12.4.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\log4j-api-2.12.4.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\log4j-core-2.12.4.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sas.security.sspi.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sas.core.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sas.svc.connection.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sas.rutil.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sas.rutil.nls.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\iomclient\\sastpj.rutil.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-internal-api.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-omgapi.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\thirdparty\\glassfish-corba-orb.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\thirdparty\\pfl-basic.jar;C:\\Users\\Owner\\miniconda3\\lib\\site-packages\\saspy\\java\\thirdparty\\pfl-tf.jar', 'pyiom.saspy2j', '-host', 'localhost', '-stdinport', '51231', '-stdoutport', '51232', '-stderrport', '51233', '-iomhost', 'odamid-usw2-2.oda.sas.com;odaws01-usw2.oda.sas.com;odaws02-usw2.oda.sas.com;odaws03-usw2.oda.sas.com;odaws04-usw2.oda.sas.com', '-iomport', '8591', '-user', '*********.********@****.com', '-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)
~\AppData\Local\Temp/ipykernel_8728/3770220775.py in <module>
----> 1 sas = saspy.SASsession()

~\miniconda3\lib\site-packages\saspy\sasbase.py in __init__(self, **kwargs)
    606 
    607            if failed:
--> 608               raise SASIOConnectionError(res)
    609 
    610            if self.pyenc is not None:

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

Re: SASPy and SAS OnDemand for Academics - Connection Issue

MayurJadhav — Tue, 21 Feb 2023 16:23:56 GMT

I'm also facing the same issue. Anyone knows the solution?

>>> sas_session = saspy.SASsession()
Using SAS Config named: oda
We failed in getConnection
An exception was thrown during the encryption key exchange.

SAS process has terminated unexpectedly. RC from wait was: 4294967290
SAS Connection failed. No connection established. Double check your settings in sascfg_personal.py file.

sascfg_personal.py

SAS_config_names=['oda']
oda = {'java' : 'C:\\Program Files (x86)\\Common Files\\Oracle\\Java\\javapath\\java.exe',
#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'],
#US Home Region 2
#'iomhost' : ['odaws01-usw2-2.oda.sas.com','odaws02-usw2-2.oda.sas.com'],
#European Home Region 1
#'iomhost' : ['odaws01-euw1.oda.sas.com','odaws02-euw1.oda.sas.com'],
#Asia Pacific Home Region 1
#'iomhost' : ['odaws01-apse1.oda.sas.com','odaws02-apse1.oda.sas.com'],
#Asia Pacific Home Region 2
'iomhost' : ['odaws01-apse1-2.oda.sas.com','odaws02-apse1-2.oda.sas.com'],
'iomport' : 8591,
'authkey' : 'oda',
'encoding' : 'utf-8'
}

Re: SASPy and SAS OnDemand for Academics - Connection Issue

sastpw — Tue, 21 Feb 2023 17:34:26 GMT

That's a different issue. Your error is:

We failed in getConnection
An exception was thrown during the encryption key exchange.

And that's a problem with needing the encryption jars in your saspy deployment, which is a new requirement for ODA since they upgraded to 9.4M7. See the documentation 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: SASPy and SAS OnDemand for Academics - Connection Issue

pkm_edu — Tue, 21 Feb 2023 21:02:50 GMT

Thanks,

Re: SASPy and SAS OnDemand for Academics - Connection Issue

MayurJadhav — Tue, 21 Feb 2023 23:54:03 GMT

Superb! Thanks for the help. 🙂

>>> import saspy
>>> sas=saspy.SASsession()
Using SAS Config named: oda
SAS Connection established. Subprocess id is 12596

>>>