We are installing SAS/Access to Redshift and try to connect to Redshift database,the installation is complete , however we are getting the below error while trying to execute the statement . (Version of SAS - 9.4M5 , linux machine)
LIBNAME A4 redshift PRESERVE_COL_NAMES=YES PRESERVE_TAB_NAMES=YES dsn=redaccess SCHEMA=aaaaa USER=xxxxx password=yyyyy;
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [OBJECT_E]
Segmentation Violation
Traceback of the Exception:
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sas(+0x1666ce) [0x55f4bf5fc6ce]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sas(+0x4e7df) [0x55f4bf4e47df]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2b8a79526a44]
/usr/lib64/libpthread.so.0(+0xf5d0) [0x2b8a781c95d0]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasiorst(pgcon+0x594e) [0x2b8acb387e7e]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxdbi(dbicon+0xa03) [0x2b8acb655cd3]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxdbi(yhelasg+0x959) [0x2b8acb62dc19]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasyh(yyhlasn+0x203) [0x2b8a7fd59d53]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasyh(yhlasn2+0x594) [0x2b8a7fd52374]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(ytlibf+0x3d6) [0x2b8a89895ab6]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yasany+0x198e) [0x2b8a898783ee]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yasany2+0xcb) [0x2b8a8987690b]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yttknx+0x1402) [0x2b8a89899332]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yalexec+0x5e9) [0x2b8a898bbba9]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yalinln+0x2f5) [0x2b8a898bf2d5]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxshel(yalproc+0x18e) [0x2b8a898b944e]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sasxobj(sasxobj+0x370) [0x2b8ab972d7d0]
/sascommon/SAS/SASHome/SASFoundation/9.4/sasexe/sas(vvtentr+0x18a) [0x55f4bf4e433a]
/usr/lib64/libpthread.so.0(+0x7dd5) [0x2b8a781c1dd5]
/usr/lib64/libc.so.6(clone+0x6d) [0x2b8a78c10ead]
SAS WTABORT (OBJECT_EXECUTIVE) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
The required LD_LIBRARY_PATH is set and odbc.ini is set.
This works in the lower environment as expected.
