saspy not connecting in jupyter lab

[sastpw]

Yes, you should create a new post for your issue here rather than add to an old solved one that isn't really related to your issue.

But, take a look at #6 here: https://sassoftware.github.io/saspy/troubleshooting.html#iom-specific-errors

That's likely to be the problem and solution!

[sastpw]

Also, FWIW, I see you're providing your own classpath in your config file. You shouldn't be doing that, as it could cause problems if it's not all exactly right. See the doc here: https://sassoftware.github.io/saspy/configuration.html#attn-as-of-saspy-version-3-3-3-the-classpath-...

Thanks,

Tom

[pkm_edu]

Hi Tom,

Thanks for your continued support.

I have further revised the content of my sascfg_personal.py as shown below. It is still throwing errors as before.
Any help would be appreciated.

********************** Error *****************************************88
We failed in getConnection
The application could not log on to the server "localhost:0". Integrated Windows authentication failed.
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

# https://sassoftware.github.io/saspy/configuration.html#attn-as-of-saspy-version-3-3-3-the-classpath-...

# I have added C:\\Program Files\\SASHome\\SASFoundation\\9.4\\core\\sasexte to my system PATH as well.
# Are the following two lines of Python code redundant here?

import os
os.environ["PATH"] += ";C:\\Program Files\\SASHome\\SASFoundation\\9.4\\core\\sasext"

# There are three main parts to this configuration file as stated in the abobe link.

# Part 1. SAS_config_names

SAS_config_names=['winlocal']

# Part 2. SAS_config_options are required unless you want to change a default. No such options added to this file.


# Part 3 Configuration definitions
default = {'saspath' : '/opt/sasinside/SASHome/SASFoundation/9.4/bin/sas_u8'
}

winlocal = {'java' : 'C:\\Program Files\\SASHome\\SASPrivateJavaRuntimeEnvironment\\9.4\\jre\\bin\\java.exe',
'encoding' : 'windows-1252'
}

# Is the following code chunk part of Part 3 and required here? If yes, does this code snippet require revision?

winiomwin = {'java' : 'java',
'iomhost' : 'windows.iom.host',
'iomport' : 8591,
'encoding' : 'windows-1252'
}

[gwootton]

The "winiomwin" chuck would be if you were using "winiomwin" instead of "winlocal", so it isn't being used here.

Did you check your hosts file?

[pkm_edu]

Hello,

Sorry for not asking the question in a new post.

1) Could you please send me the link where I should post for this particular topic?
2) Do I need any revisions to my sascfg_personal.py below?
3) Any further thoughts?

Thanks,

Pradip



****************************************************
# Here is the content of my sascfg_personal.py
SAS_config_names=['winlocal']


SAS_config_options = {'lock_down': False,
'verbose' : True
}

SAS_output_options = {'output' : 'html5'}


# Configuration Definitions

default = {'saspath' : '/opt/sasinside/SASHome/SASFoundation/9.4/bin/sas_u8'
}

ssh = {'saspath' : '/opt/sasinside/SASHome/SASFoundation/9.4/bin/sas_en',
'ssh' : '/usr/bin/ssh',
'host' : 'remote.linux.host',
'encoding': 'latin1',
'options' : ["-fullstimer"]
}




# build out a local classpath variable to use below for Windows clients CHANGE THE PATHS TO BE CORRECT FOR YOUR INSTALLATION
cpW = "C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94518__prt__xx__sp0__1\\deploywiz\\sas.svc.connection.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94518__prt__xx__sp0__1\\deploywiz\\log4j.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94518__prt__xx__sp0__1\\deploywiz\\sas.security.sspi.jar"
cpW += ";C:\\Program Files\\SASHome\\SASDeploymentManager\\9.4\\products\\deploywiz__94518__prt__xx__sp0__1\\deploywiz\\sas.core.jar"
cpW += ";C:\\Users\\Pradip.Muhuri\\Anaconda3\\Lib\\site-packages\\saspy\\java\\saspyiom.jar"


winlocal = {'java' : 'C:\\Program Files\\SASHome\\SASPrivateJavaRuntimeEnvironment\\9.4\\jre\\bin\\java.exe',
'encoding' : 'windows-1252',
'classpath' : cpW
}

winiomlinux = {'java' : 'java',
'iomhost' : 'linux.iom.host',
'iomport' : 8591,
'encoding' : 'latin1',
'classpath' : cpW
}

winiomwin = {'java' : 'java',
'iomhost' : 'windows.iom.host',
'iomport' : 8591,
'encoding' : 'windows-1252',
'classpath' : cpW
}

winiomIWA = {'java' : 'java',
'iomhost' : 'windows.iom.host',
'iomport' : 8591,
'encoding' : 'windows-1252',
'classpath' : cpW,
'sspi' : True
}

[sastpw]

No problem, it's just that adding to some old post wont get visibility and is confusing. I think you just click 'Start New Topic' to create one of these posts. There's not a SASPy category here, I think they want that to go into the Programming->Developers area, but it really doesn't matter. FWIW, you can get direct help on SASPy by opening an issue on the SASPy github site. But since I'm here 🙂

Since you only seem to be using local SAS on your PC, the only required content of your sascfg_personal.py file would be:

```

SAS_config_names=['winlocal']

winlocal = {'java' : 'C:\\Program Files\\SASHome\\SASPrivateJavaRuntimeEnvironment\\9.4\\jre\\bin\\java.exe',
'encoding' : 'windows-1252',
}

```

Did you resolve your etc/hosts file, assuming the problem was #6 in the troubleshooting guide for IOM specific errors?