Unable to execute Libname instruction with Operating system services scheduler on SMC

rami_braham — Wed, 13 Feb 2019 16:57:00 GMT

Hi experts,

USING SAS 9.4 plateform i have a SAS DIS job that reads data from ORACLE DB threw an ODBC Connection. the jobs works just fine. once deployed i created a flow in SAS Management console to schedule the execution.

i'm unable to execute Libname instruction using Operating system services scheduler on SAS MANAGEMENT CONSOLE below the message error in the log file:

Note: Credential obtained from SAS metadata server

Error CLI error trying to establish connection: [unixODBC]Driver Manager] can't open lib ' /opt/oracle/instantclient_12_1/lisqora.so.12.1: file not found.

Besides SAS DIS i tested the Libname instruction Using SAS EG. i can run the exact Libname instruction below the note:

Note: Credetial obtained from SAS metadata server.

Note: Libref XXX was sucessfully assigned as follows:

Engine: ODBC:

Physica Name: XXXX

any suggestions on what can be the problem.

Thanks a lot.

Rami

Re: Unable to execute Libname instruction with Operating system services scheduler on SMC

Patrick — Wed, 13 Feb 2019 20:23:55 GMT

@rami_braham

Looks like the system account under which the scheduler executes the deployed job doesn't have the necessary OS level privileges to access /opt/oracle/instantclient_12_1/lisqora.so.12.1

Also worth testing:

Run a piece of code which issues a proc options; and a Unix ENV statement and compare in the log if the environment is sufficiently the same when using DIS/EG or running code in batch via scheduler. I'm just thinking the issue could also arise if LD_LIBRARY_PATH is not set correctly when running via scheduler. https://community.oracle.com/thread/2594875

topic Unable to execute Libname instruction with Operating system services scheduler on SMC in SAS Data Management

Unable to execute Libname instruction with Operating system services scheduler on SMC

Re: Unable to execute Libname instruction with Operating system services scheduler on SMC