BookmarkSubscribeRSS Feed
AmitSri
Pyrite | Level 9
Hi Alex, Can I have any help on this please. Thanks!!
alexal
SAS Employee

@AmitSri,

 

I do not see any debug messages in the log. Have you reproduced the problem?

AmitSri
Pyrite | Level 9
Yes Alex, I had done that.

Here is the program that I had run.
cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US");

caslib odbclib datasource=(srctype="odbc" username="sas_odbc_user"
password="xxxxxxxxxxxxxxxxxx"
odbc_dsn="VDP_acme_DSN");

proc casutil;
list files incaslib=odbclib;
run;

And getting error as below:
ERROR: The connection to the data source driver failed.
ERROR: No diagnostic records were returned.
ERROR: Function failed.
ERROR: The action stopped due to errors.
AmitSri
Pyrite | Level 9
Is this the one that you are expecting me to share?
cat caslaunch_default_controller_daemon.log
2017-12-13T15:53:41 gspdsv04.aqua.local:0: NOTE: The list of machines in '/opt/sas/viya/home/SASFoundation/../../config/etc/cas/default/cas.hosts' will be ignored because the server is running in SMP mode.
=== CAS gspdsv04.aqua.local:5570 (0) http://gspdsv04.aqua.local:443 ===
[root@gspdsv04 default]# cat caslaunch_default_controller_daemon.err
2017-12-13T19:46:31 gspdsv04.aqua.local:0: ERROR: Could not find the specified session.

Previously I had sent you another log "cas_2017-12-15_gspdsv04_1103.log"
Timmy2383
Lapis Lazuli | Level 10
I thought the NOPROMPT syntax was for Windows environments only? Especially the way you have it here, referring only a driver name an full path (bc in Windows the drivers are automatically registered, but in Unix you need to give the full pah to the odbc driver)

You need to make sure you have set the environment variable for LD_LIBRARY_PATH in sasenv_local if you haven't already
AmitSri
Pyrite | Level 9

Hi Timmy,

Yes, I had already done that. but, still some thing went wrong in the configuration (it looks like).

Could you please check if the way I have defined the paths is correct or not.

under cas.settings:

export ODBCINI=/etc/odbc.ini
export ODBCINSTINI=/etc/odbcinst.ini
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/denodoodbc-09.03.0420/lib/

 

and under sasenv_local:
export ODBCINI=/etc/odbc.ini
export ODBCINSTINI=/etc/odbcinst.ini
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/data/denodoodbc-09.03.0420/lib/

 

Am i missing anything else? Note: I have placed the .ini files at /etc.Thanks!!

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 20 replies
  • 4092 views
  • 3 likes
  • 3 in conversation