DSXchange

Hello Friends

We are getting below error in one of our server jobs

Could not load drsoci.so

There has been no change to environment variable on unix level.

Interesting thing is ,this error is coming only in 1 job and it runs well when restarted.

This job is reading from a table and loading the Hash File. No other stages are used

Any idea what could be the issue and the resolution ?

Thanks for your help

Regards
Ulhas

Is the error sporadic or does it just occur sometimes? Is the machine heavily loaded when it happens?

Also, are there any more messages in the log that might give more details on the problem?

There must be at least one other stage (a server job must have at least two). I suspect that the other stage is a DRS stage set to connect to Oracle (hence the drsoci reference in the error message). You have to make sure that the parent directory of drsoci.so is in your shared library search list (LD_LIBRARY_PATH, or LIBPATH or SHLIB_PATH, depending on what kind of UNIX you're using).

Hi

Thanks for your response

This error was not happening previously. We are seeing this issue from last 2 days

I checked the director log

The LD_LIBRARY_PATH value is going wrong when the job is failing

LD_LIBRARY_PATH=:/lib

After restarting the job,the LD_LIBRARY_PATH value goes correct and job runs fine

LD_LIBRARY_PATH=:/opt/oracle/product/11.2.0/client_1/lib

For now,I have compiled the job. Lets see if that solves the issue

Anything else i need to check for this issue ?

Additional info is ,this job is the first one in the sequencer..Once this job runs fine..no other job face the same issue

Thanks again for your help

Hi Ray

yes...the job uses DRS stage to read from Oracle table and loads into Hash File

We are still getting the error.

We have the jobs scheduled through DataStage Scheduler

We are observing that when this job runs from Scheduler,it fails with the above error

When it is triggered manually,it runs successfully

Any ideas ?

Thank you all for your help

Check the .profile (or .bash_profile or whatever) for the scheduler. It sounds like it is over-riding the LD_LIBRARY_PATH setting. Since the DataStage job inherits the properties of the starting process, that's where you need to look.