Error in Talend: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path

0 votes

I have a ETL job which I have successfully executed the same job on a Windows 2003 and a XP machine. Now, I am trying to execute this Job in Talend and for that I have placed the jar & dll files in the lib folder of Talend. Both path and the classpath is set as well. Moreover I have also downloaded the missing dlls provided by SAP along with VC++ 2005 redistribution sp 1 patch and have already installed them. But when I am trying to execute the job, its giving me the following error. Please suggest some way out of this:
 

Starting job Chargebacks at 13:57 03/10/2014.

[statistics] connecting to socket on port 3350
[statistics] connected
java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
   at java.lang.ClassLoader.loadLibrary(Unknown Source)
   at java.lang.Runtime.loadLibrary0(Unknown Source)
   at java.lang.System.loadLibrary(Unknown Source)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.loadLibrary(DefaultJCoRuntime.java:441)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.registerNativeMethods(DefaultJCoRuntime.java:307)
   at com.sap.conn.jco.rt.JCoRuntime.registerNatives(JCoRuntime.java:969)
   at com.sap.conn.rfc.driver.CpicDriver.<clinit>(CpicDriver.java:955)
   at com.sap.conn.rfc.engine.DefaultRfcRuntime.getVersion(DefaultRfcRuntime.java:43)
   at com.sap.conn.rfc.api.RfcApi.RfcGetVersion(RfcApi.java:261)
   at com.sap.conn.jco.rt.MiddlewareJavaRfc.<clinit>(MiddlewareJavaRfc.java:200)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.initialize(DefaultJCoRuntime.java:73)
   at com.sap.conn.jco.rt.JCoRuntimeFactory.<clinit>(JCoRuntimeFactory.java:23)
   at com.sap.conn.jco.rt.RuntimeEnvironment.<init>(RuntimeEnvironment.java:40)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at java.lang.Class.newInstance0(Unknown Source)
   at java.lang.Class.newInstance(Unknown Source)
   at com.sap.conn.jco.ext.Environment.getInstance(Environment.java:121)
   at com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(Environment.java:216)
   at jdi.chargebacks_0_1.Chargebacks.tSAPConnection_1Process(Chargebacks.java:361)
   at jdi.chargebacks_0_1.Chargebacks.runJobInTOS(Chargebacks.java:3718)
   at jdi.chargebacks_0_1.Chargebacks.main(Chargebacks.java:3577)
Exception in thread "main" java.lang.ExceptionInInitializerError: Error getting the version of the native layer: java.lang.UnsatisfiedLinkError: no sapjco3 in java.library.path
   at com.sap.conn.jco.rt.MiddlewareJavaRfc.<clinit>(MiddlewareJavaRfc.java:212)
   at com.sap.conn.jco.rt.DefaultJCoRuntime.initialize(DefaultJCoRuntime.java:73)
   at com.sap.conn.jco.rt.JCoRuntimeFactory.<clinit>(JCoRuntimeFactory.java:23)
   at com.sap.conn.jco.rt.RuntimeEnvironment.<init>(RuntimeEnvironment.java:40)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at java.lang.Class.newInstance0(Unknown Source)
   at java.lang.Class.newInstance(Unknown Source)
   at com.sap.conn.jco.ext.Environment.getInstance(Environment.java:121)
   at com.sap.conn.jco.ext.Environment.registerDestinationDataProvider(Environment.java:216)
[statistics] disconnected
   at jdi.chargebacks_0_1.Chargebacks.tSAPConnection_1Process(Chargebacks.java:361)
   at jdi.chargebacks_0_o1.Chargebacks.runJobInTOS(Chargebacks.java:3718)
   at jdi.chargebacks_0_1.Chargebacks.main(Chargebacks.java:3577)
Job Chargebacks ended at 13:57 03/10/2014. [exit code=1]

Apr 14, 2018 in Talend by geek.erkami
• 2,640 points
1,115 views

1 answer to this question.

0 votes

You can start off by placing the .jar files in \lib\java\.

Next, put the dll and the sapjco3.jar files into C:\Windows\system32\ if you are working on Windows.

In case you are working on Linux follow the below steps:

  1. In the talend lib/java directory, copy the sapjco3.jar and place the sapjco3.dll in the %PATH%

  2. Check the file by double clicking it. If it’s correct then it must display the location info of the jar and dll files

Make sure to use jdks of same versions as your processor.

answered Apr 14, 2018 by code.reaper12
• 3,450 points

Related Questions In Talend

0 votes
1 answer

Using Java Classes in Talend

While working with routines, the very 1st ...READ MORE

answered Apr 14, 2018 in Talend by geek.erkami
• 2,640 points
476 views
0 votes
2 answers

How to use java classes in Talend?

For many data integration requirements, the standard ...READ MORE

answered Oct 3, 2018 in Talend by daisyridley
• 160 points

edited Oct 3, 2018 by Vardhan 460 views
0 votes
1 answer

Parsing JSON in Talend

While working with JSON files, one thing ...READ MORE

answered Apr 2, 2018 in Talend by code.reaper12
• 3,450 points
590 views
0 votes
1 answer
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points
137 views
0 votes
1 answer

Adding third party libraries into the Talend project

You can add the 3rd party libraries ...READ MORE

answered Apr 9, 2018 in Talend by code.reaper12
• 3,450 points
457 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,640 points
402 views
0 votes
1 answer

Downloading files using Talend Studio

As per my understanding, I think first ...READ MORE

answered Apr 11, 2018 in Talend by code.reaper12
• 3,450 points
307 views
0 votes
1 answer
0 votes
1 answer

Parsing Date Error in Talend

This job doesn’t needs tConvertType. You can ...READ MORE

answered Apr 19, 2018 in Talend by code.reaper12
• 3,450 points
606 views