DSXchange

we recently moved from 9.7 to 11.3 .
The job which reads excel file works in old version but throwing error in 11.3 any idea?

Unstructured_Data_0: Error loading connector library libccapijni.so. libjvm.so: cannot open shared object file: No such file or directory (CC_LoadedConnector::loadLibrary, file CC_ConnectorFactory.cpp, line 1,525)

Thanks you!

I'm currently on 11.3 and using the unstructured stage for Excel files and it does work.

The error message indicates that the LD_LIBRARY_PATH might not be set correctly; so I would start by specifically checking paths. Is the InformationServer/Server/DSComponents/bin directory in the library path?

Yes, see the below entries
LD_LIBRARY_PATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/linux-all-x86_64:${TWB_ROOT}/lib64:${TD_ICU_DATA}:/opt/teradata/client/14.10/lib64:$ORACLE_HOME/bin:$ORACLE_HOME/lib;

Then perhaps permissions?

Did you get that path from the Director log of the process that failed - if not, that's where you should be looking to the get the runtime values.

addendum - I don't recall seeing that syntax in the environment before, are you certain the $DSHOME is set and points to the correct location?

were you able to locate those two .so files in the error message. And is that path present in there? And do you have atleast read and execute privilege?

do echo $LD_LIBRARY_PATH to find if those parameters being used are correctly resolved.

Thank you guys for trying to help me.
i figured out issue lied in LD_LIBRARY_PATH after i added below line it worked.

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:`dirname $DSHOME`/biginsights/IHC/c++/Linux-amd64-64/lib:$ISHOME/jdk/jre/lib/amd64/j9vm:$ISHOME/jdk/jre/lib/amd64;
export LD_LIBRARY_PATH

Thanks