topic Re: tmesiladataaddress component error in Talend Studio

tmesiladataaddress component error

RAJ6 — Sun, 30 Jul 2017 11:24:06 GMT

Hi Frnds,

when I ran a job. I am getting below error while using tmesiladataaddress component. how to solve this issue?

How to set path for mdAddrJavaWrapper.dll. I dont have mdAddrJavaWrapper.dll in my system.

Image: 2

error:

[statistics] connecting to socket on port 3886
[statistics] connected
Exception in thread "main" java.lang.UnsatisfiedLinkError: com.melissadata.mdAddrJavaWrapperJNI.new_mdAddr()J
at com.melissadata.mdAddrJavaWrapperJNI.new_mdAddr(Native Method)
at com.melissadata.mdAddr.<init>(mdAddr.java:39)
at local_project.mesiladataaddress_0_1.mesiladataaddress.tFixedFlowInput_1Process(mesiladataaddress.java:1466)
at local_project.mesiladataaddress_0_1.mesiladataaddress.runJobInTOS(mesiladataaddress.java:2381)
at local_project.mesiladataaddress_0_1.mesiladataaddress.main(mesiladataaddress.java:2207)
java.lang.UnsatisfiedLinkError: no mdAddrJavaWrapper in java.library.path
java.library.path = C:\Program Files\Java\jre1.8.0_121\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_121/bin/server;C:/Program Files/Java/jre1.8.0_121/bin;C:/Program Files/Java/jre1.8.0_121/lib/amd64;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\;c:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;%JAVA_HOME%\bin;C:\Users\GIS_Anju\AppData\Local\Microsoft\WindowsApps;;C:\Talend\6.4.1\studio;;.
[statistics] disconnected
Job mesiladataaddress ended at 15:41 30/07/2017. [exit code=1]

Re: tmesiladataaddress component error

Anonymous — Tue, 01 Aug 2017 10:28:31 GMT

Hi
Please read the Prerequisites section in the component documentation.
To retrieve longitude and latitude data and the GeoCode result codes, you must have purchased a GeoCode or a GeoPoint license.
In order to successfully execute a Job with the tMelissaDataAddress component, you must have installed Melissa Data with the GeoPoint and GeoCode data files.

You must also add the path to the folder containing the mdAddr library to your system environment variables.
For example:
•on Linux: export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<path to folder containing libmdAddr.so>.
•on Windows: PATH=%PATH%;<path to folder containing mdAddr.dll>.

If you have purchased a GeoCode or a GeoPoint license, you should contact Melissa Data and ask for the dll file.

Regards
Shong

Re: tmesiladataaddress component error

Anonymous — Sun, 06 Aug 2017 13:15:17 GMT

I have read and re-read the prerequisites and I'm sure I have met them, but I still get the error above:

Starting job testMelissaData at 08:03 06/08/2017.

[statistics] connecting to socket on port 3432
[statistics] connected
java.lang.UnsatisfiedLinkError: no mdAddrJavaWrapper in java.library.path
java.library.path = C:\Program Files\Java\jdk1.8.0_65\jre\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jdk1.8.0_65/bin/../jre/bin/server;C:/Program Files/Java/jdk1.8.0_65/bin/../jre/bin;C:/Program Files/Java/jdk1.8.0_65/bin/../jre/lib/amd64;C:\Program Files\Java\jdk1.8.0_65\bin;C:\Program Files\Melissa DATA\DQT\AddrObj\dll_64bit;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files\Amazon\cfn-bootstrap\;C:\Program Files\VisualSVN Server\bin;C:\Program Files\PuTTY\;C:\Program Files\MySQL\MySQL Utilities 1.6\;D:\Talend\6.3.1\studio;;.
Exception in thread "main" java.lang.UnsatisfiedLinkError: com.melissadata.mdAddrJavaWrapperJNI.new_mdAddr()J
   at com.melissadata.mdAddrJavaWrapperJNI.new_mdAddr(Native Method)
   at com.melissadata.mdAddr.<init>(mdAddr.java:39)
   at talendexamples.testmelissadata_0_1.testMelissaData.tFixedFlowInput_1Process(testMelissaData.java:1349)
   at talendexamples.testmelissadata_0_1.testMelissaData.runJobInTOS(testMelissaData.java:5503)
   at talendexamples.testmelissadata_0_1.testMelissaData.main(testMelissaData.java:5317)
[statistics] disconnected
Job testMelissaData ended at 08:03 06/08/2017. [exit code=1]

I've tried JRE1.8u125 as well as JDK1.8u65.

The DLL is in a path: "C:\Program Files\Melissa DATA\DQT\AddrObj\dll_64bit"

There is also a 32bit DLL location that I have tried too without success

Re: tmesiladataaddress component error

Anonymous — Fri, 21 Sep 2018 11:05:34 GMT

even I was facing the same issue .

What mentioned in the talend support document is to just add mdAddr.dll in environment path. I was adding the same and running the job which was not working for me.

the below solution worked for me

It ran after setting the path for :

1. add path for both mdAddrJavaWrapper.dll and mdAddr.dll in the PATH variable in environment setup.

2. "C:/Program Files/Melissa DATA/DQT/Data/" in the tMelissaDataAddress component for the tab "specify for melissaData DataFile Folder"

3.in the advanced setting in the run job tab , check the jvm settigns and add

"-Djava.library.path =C:\Program Files\Melissa DATA\DQT\AddrObj\samples\Java\" (this is the path where "mdAddrJavaWrapper.dll " is located)

Re: tmesiladataaddress component error

Anonymous — Fri, 21 Sep 2018 11:16:57 GMT

My bad. I did get it working but did not update this post. Thanks for sharing!

Re: tmesiladataaddress component error

Anonymous — Fri, 21 Sep 2018 11:25:08 GMT

No worries,

By the way, what was the solution that worked for you ... was that the same that I posted or any other than that