Architecting, installing and maintaining your SAS environment

Getting ERROR while Running job through LSF

Accepted Solution Solved
Reply
Contributor
Posts: 49
Accepted Solution

Getting ERROR while Running job through LSF

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.

 

 

 


Accepted Solutions
Solution
‎02-07-2017 05:24 AM
Frequent Contributor
Posts: 106

Re: Getting ERROR while Running job through LSF

[ Edited ]

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 Smiley Happy

 

 

Nik

View solution in original post


All Replies
Super User
Posts: 5,437

Re: Getting ERROR while Running job through LSF

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.

Data never sleeps
Solution
‎02-07-2017 05:24 AM
Frequent Contributor
Posts: 106

Re: Getting ERROR while Running job through LSF

[ Edited ]

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 Smiley Happy

 

 

Nik

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 273 views
  • 1 like
  • 3 in conversation