SAS Viya Container Image - Write data to PostgreSQL DB Failure!

AnandVyas — Fri, 06 Nov 2020 04:49:28 GMT

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

Re: SAS Viya Container Image - Write data to PostgreSQL DB Failure!

JuanS_OCS — Mon, 23 Nov 2020 16:27:21 GMT

Hello @AnandVyas ,

did you have the chance to look at the psql logs? I this the Viya psql database or it is an external one?

I would check also at your odbc driver logs, previous expanding the level of information.

Regards,
Juan

topic SAS Viya Container Image - Write data to PostgreSQL DB Failure! in Administration and Deployment

SAS Viya Container Image - Write data to PostgreSQL DB Failure!

Re: SAS Viya Container Image - Write data to PostgreSQL DB Failure!