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!
Unstructured data not working in 11.3
Moderators: chulett, rschirm, roy
Unstructured data not working in 11.3
Datastage User
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?
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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;
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;
Datastage User
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?
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?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.
do echo $LD_LIBRARY_PATH to find if those parameters being used are correctly resolved.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
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
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
Datastage User