CAS Connection returns error

[FBOMMA]

SAS VIYA Version : 3.5
R version 3.2.3 (2015-12-10)
swat_1.6.3.9000
CentOS release 6.7

library('swat')
library('dplyr')
library('jsonlite')
library('httr')

Sys.setenv(CASCLIENTDEBUG=1)
options(cas.print.messages = TRUE)

Sys.setenv(CAS_CLIENT_SSL_CA_LIST="/home/xxx/SAS/xxx.pem")
conn <- CAS('server.domain', 5570, username="myuser@mydomain.fr", password="xxx")
[1] "NOTE: Client is using userid=myuser@mydomain.fr, password=***"
[1] "NOTE: Client is using the userpass identity provider"
[1] "NOTE: Sent challenge length 132"
[1] "NOTE: Received response length 72"
[1] "NOTE: User myuser@mydomain.fr connected to CAS using user/pass."
NOTE: Connecting to CAS and generating CAS action functions for loaded
action sets...

Error in [.data.frame(table, c(setdiff(names(table), col.names), col.names)) :
undefined columns selected

sessionInfo()
R version 3.2.3 (2015-12-10)
Platform: x86_64-redhat-linux-gnu (64-bit)
Running under: CentOS release 6.7 (Final)

locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8
[5] LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8 LC_PAPER=en_US.UTF-8 LC_NAME=C
[9] LC_ADDRESS=C LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C

attached base packages:
[1] stats graphics grDevices utils datasets methods base

other attached packages:
[1] httr_1.4.0 jsonlite_1.6 dplyr_0.8.3 swat_1.6.3.9000

loaded via a namespace (and not attached):
[1] Rcpp_1.0.3 crayon_1.3.4 assertthat_0.2.1 R6_2.4.0 magrittr_1.5 pillar_1.4.2 rlang_0.4.2
[8] curl_3.3 rstudioapi_0.10 tools_3.2.3 glue_1.3.1 purrr_0.3.2 pkgconfig_2.0.2 tidyselect_0.2.5
[15] tibble_2.1.3

[frayos]

Hello, for SAS reference,
this issue was suggested to be opened in track : 7613432080
as we believe the issue seems to be on the R side and not SAS / CAS.

Thanks !
Younes

[tomweber-sas]

@frayos I haven't been able to reproduce this, after installing the latest version, which you are running. I do see where that error appears to be happening in the code, and that code's been in there for some time now. Can you run the following, just to get some diagnostic output to see how far along in the process this is when the error happens?

Just add the options code below to your same test, just before the CAS() connection invocation. I'm expecting the same error, as the only thing that is really different here should be the trace.action=TRUE. But, this will easily give us an idea of where/when the error is happening; is there some action loaded in your environment I don't have and it has something unusual w/ it's columns, or how the results for it are coming back, which are causing this error? Is it on the very first one, and maybe there's some mismatch? ... Seeing the output will give a little better clue.

getOption('cas.gen.function.sig')
getOption('cas.trace.actions')
options(cas.gen.function.sig=FALSE)
options(cas.trace.actions=TRUE)


conn <- CAS('server.domain', 5570, username="myuser@mydomain.fr", password="xxx")
cas.builtins.about(conn)

Also, does it work if you connect with the HTTP method instead of the Binary protocol?

Thanks,
Tom

[FBOMMA]

Command executed :

library('swat')
library('dplyr')
library('jsonlite')
library('httr')
Sys.setenv(CASCLIENTDEBUG=1)
Sys.setenv(CAS_CLIENT_SSL_CA_LIST="/home/60minsupport/SAS/sasviyadatascience.pem")
options(cas.print.messages = TRUE)
getOption('cas.gen.function.sig')
getOption('cas.trace.actions')
options(cas.gen.function.sig=FALSE)
options(cas.trace.actions=TRUE)
conn <- CAS('server.domain', 5570, username="myuser@mydomain.fr", password="xxx")
cas.builtins.about(conn)

Result
[1] "NOTE: Client is using userid=s012552@societe.mma.fr, password=***"
[1] "NOTE: Client is using the userpass identity provider"
[1] "NOTE: Sent challenge length 132"
[1] "NOTE: Received response length 72"
[1] "NOTE: User S012552@societe.mma.fr connected to CAS using user/pass."
NOTE: Connecting to CAS and generating CAS action functions for loaded
action sets...
[1] "[builtins.reflect]"
[1] " action = "builtins.reflect" (string)"
[1] " _messagelevel = "error" (string)"
[1] "[builtins.about]"
[1] " _messagelevel = "error" (string)"
Error in [.data.frame(table, c(setdiff(names(table), col.names), col.names)) :
undefined columns selected

cas.builtins.about(conn)
Error: could not find function "cas.builtins.about"

The hhtp method doesn't work at all :
conn <- CAS("lx40461.posix.covea.priv", 8777, protocol='https', user='s012552@societe.mma.fr', password='xxxx')
Error in curl::curl_fetch_memory(url, handle = handle) :
Timeout was reached: Operation timed out after 10001 milliseconds with 0 out of 0 bytes received

I have tried this command on the R server : curl -k -vvv https://myserver:8777/
I works fine :

• Trying 10.231.1.231...
• TCP_NODELAY set
• Connected to lx40461.posix.covea.priv (10.231.1.231) port 8777 (#0)
• Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@strength
• successfully set certificate verify locations:
• CAfile: /etc/pki/tls/certs/ca-bundle.crt
  CApath: none
• TLSv1.2 (OUT), TLS handshake, Client hello (1):
• TLSv1.2 (IN), TLS handshake, Server hello (2):
• TLSv1.2 (IN), TLS handshake, Certificate (11):
• TLSv1.2 (IN), TLS handshake, Server key exchange (12):
• TLSv1.2 (IN), TLS handshake, Server finished (14):
• TLSv1.2 (OUT), TLS handshake, Client key exchange (16):
• TLSv1.2 (OUT), TLS change cipher, Client hello (1):
• TLSv1.2 (OUT), TLS handshake, Finished (20):
• TLSv1.2 (IN), TLS change cipher, Client hello (1):
• TLSv1.2 (IN), TLS handshake, Finished (20):
• SSL connection using TLSv1.2 / ECDHE-RSA-AES256-GCM-SHA384
• Server certificate:
• subject: CN=lx40461.posix.covea.priv
• start date: Sep 3 09:59:32 2021 GMT
• expire date: Jul 27 14:00:02 2028 GMT
• issuer: CN=SAS VIYA Intermediate CA* SSL certificate verify result: unable to get local issuer certificate (20), c ontinuing anyway.

GET / HTTP/1.1
Host: lx40461.posix.covea.priv:8777
User-Agent: curl/7.58.0
Accept: /

< HTTP/1.1 301 Moved Permanently
< Connection: keep-alive
< Date: Thu, 07 Oct 2021 08:26:00 GMT
< Public: GET, PUT, HEAD, POST, DELETE, TRACE, OPTIONS, PATCH
< Server: SAS HTTPD 10
< Origin: https://lx40456.posix.covea.priv:8777
< Cache-Control: private
< Content-Length: 0
< Location: /cas-shared-default-http/healthCheck
<

• Connection #0 to host lx40461.posix.covea.priv left intact

[tomweber-sas]

Thanks, that shows that it's just getting started trying to get the actions that are loaded to create them as functions, and it's failing to get the output from CAS into a data frame to then process; creating the functions. I don't know what would cause this, going to have to get a SWAT person to diagnose this. But that output is very helpful in seeing where/when this happened. And, I don't know about the http either. Need someone to identify how/why that doesn't connect. I'll try to route this to someone here to help.

Thanks!
Tom