Hi Experts,
I have successfully deployed SAS Viya container image using Docker. I have issues when I am trying to write data to PostgreSQL DB. Please find below code and the error I am facing.
Any pointers to resolve this will help!
libname pgtest odbc noprompt="Driver=/opt/sas/viya/home/lib64/psqlodbcw.so;Database=sastest;UID=sasadmin;PWD=test123;Server=xx.xx.xx.xx";
data pgtest.testdata;
set sashelp.cars;
run;
1 %studio_hide_wrapper;
82 libname pgtest odbc
82 ! noprompt=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
82 ! ;
NOTE: Libref PGTEST was successfully assigned as follows:
Engine: ODBC
Physical Name:
83
84 data pgtest.testdata;
85 set sashelp.cars;
86 run;
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [DATASTEP]
Segmentation Violation
Traceback of the Exception:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [DATASTEP]
Segmentation Violation
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set PGTEST.TESTDATA may be incomplete. When this step was stopped there were 0 observations and 15 variables.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [DATASTEP]
Segmentation Violation
