Unstructured data not working in 11.3

krishna81 · Post by **krishna81** » Thu Jul 16, 2015 9:16 am

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!

ArndW · Post by **ArndW** » Thu Jul 16, 2015 9:47 am

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?

krishna81 · Post by **krishna81** » Thu Jul 16, 2015 9:55 am

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;

chulett · Post by **chulett** » Thu Jul 16, 2015 10:25 am

Then perhaps permissions?

ArndW · Post by **ArndW** » Thu Jul 16, 2015 11:31 am

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?

priyadarshikunal · Post by **priyadarshikunal** » Thu Jul 16, 2015 12:14 pm

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.

krishna81 · Post by **krishna81** » Thu Jul 16, 2015 2:08 pm

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