I am using SAS Viya 3.4. I am connecting to Amazon Redshift through an ODBC connection. When I attempt to run a SAS program within SAS Studio on Viya the program does not complete on its own. I have to go to the linux box and kill the compsrv.start.s and kill the PID in order for the program to complete. Has anyone else had an issue such as this? I only get this issue when trying to run it within SAS Studio on SAS VIYA.
Example of PIDS I would kill
rmjones@abcdefghighl:/opt/sas/spre/home/lib64/accessclients
$ ps -U rmjones
PID TTY TIME CMD
9271 pts/1 00:00:00 ps
14611 ? 00:00:00 compsrv_start.s
14631 ? 00:00:13 compsrv
14633 ? 00:00:00 elssrv
52233 pts/0 00:00:00 vim
101719 pts/0 00:00:00 bash
117970 pts/1 00:00:00 bash
I know the program run because, when I run the same program on SAS Studio on SAS 9.4, it runs as it should.
Please help!!
Thanks
Reggie