Getting ERROR while Running job through LSF

[MG18]

Hi All ,

Someone had installed SAS environment and now we trying to run job from LSF which giving below mentioned error:-

ERROR: Could not load /sasinst/sas/SASFoundation/9.3/sasexe/sassqsrv (40 images loaded)

ERROR: libodbc.so: cannot open shared object file: No such file or directory

ERROR: The SAS/ACCESS Interface to SQLSRV cannot be loaded. The SASSQSRV code appendage could not be loaded.

ERROR: DLOPEN dynamic load failed for load module sassqsrv

Please help me to find out this issue.

[LinusH]

Do you get the same error when running outside LSF? (in the same environment)

Sounds like something is missing in the installation/configuration, of either SAS-LSF, or ACCESS to SQL Server.

Bets bet is to contact that "someone", and/or review the installation/configuration doc, and contact SAS tech support.

[boemskats · Accepted solution]

Hi MG18,

SAS is unable to load the libodbc.so shared object. You need to point SAS Foundation/linker to the location of the ODBC shared libraries by setting the LD_LIBRARY_PATH environment variable. You do this for SAS Foundation globally by editing sasenv_local in your [sashome]/SASFoundation/9.3/bin directory. 

Refer to the SAS® 9.3 Foundation for UNIX® Environments Configuration Guide, page 53 onwards titled SAS/ACCESS Interface to Microsoft SQL Server - it'll tell you what to do (you may need your administrator to help you). Adding the path of the ODBC client libs is a manual post-installation task which 'someone' probably didn't test 🙂

Nik