Run window my job runs with error, the Bat file runs ok! Help me, pls!

[Anonymous]

Hello guys,
I'm having trouble running jobs that perform in SQL Server database connection due to Java version being used (this is the conclusion I arrived).

The version of TOS:
      Talend Open Studio for Data Integration
      Version: 6.2.1

Through the images below it is easier to explain:

On Run Windows, I had the error describle as follow:




My dbConnection checked is successfull:




When I run using the Bat file(genereted by build) is successfully executed:
Bat File: (I configured to use the java setted on Java_home)



This result:



On the green balloon have a string printed by tJava after tMSSqlConnection component.
Jre configured on Talend:




Pay attention that the Jre that is configured in Talend is the same being used as java_home in Bat file.
On last line at bat file result, have a path setted by Oracle installation.

I need help, please!
Thanks in advance.

Roma

[Anonymous]

Can you please confirm what java path is added in your path variable? Is it same as one in Java_Home?

[Anonymous]

Good Morning,

In this machine there is more than one version of java, as follows:

-> "C: \ Program Files (x86) \ Java \ jre1.8.0_101" (setted in the JAVA_HOME environment variable used in the bat file that runs successfully)
-> "C: \ Program Files \ Java \ jdk1.8.0_101"
-> "C: \ Program Files \ Java \ jre1.8.0_101"

In Java- Control Panel> Java tab> Settings Java Runtime Environment, is setted "C: \ Program Files \ Java \ jre1.8.0_101 \ bin \ javaw.exe"

Searching the error displayed, they say it is due to lack of ntlmauth.dll library (used by MS SQL Server JDBC to connect authenticating through the network login). Following the JDBC provider's instructions, I put the DLL in the BIN Java folder. As I had only installed Java on x86, which was put and ran until the part to test the connection when you create the DBConnection the "Metadata> Db Connections" of Talend. When I was about to use the tMSSqlConnection, I saw that did not solve the problem. So I decided to install the JDK, which installed the versions x64 and after the installation I copied the ntlmauth.dll library for folders:
"C: \ Program Files \ Java \ jre1.8.0_101 \ bin" and "C: \ Program Files \ Java \ jdk1.8.0_101 \ jre" which also did not solve.
Checking the PATH environment variable, I setted the path "C: \ ProgramData \ Oracle \ Java \ JavaPath" where I found the shortcuts to the java.exe, javaw.exe and javaws.exe the folder "C: \ Program Files \ Java \ jre1.8.0_101 \ bin "

If you need more information, please contact us
In regards.

[Anonymous]

Hello guys!
Do you have ideia? Don't have news?
Tks!

[Anonymous]

It is some small issue. Without looking at your system it will be difficult to troubleshoot it further

[Anonymous]

Hello,
 
Java folders:
(this version, my job run on BAT file)

and
(this version, my job does not run on BAT file)

Java Control Panel:

System Variables: PATH
(On PATH variable, this "C:\Program Files\Java\jre1.8.0_101\bin" is java path setted)

In this path I found 3 links:




User variables: 
Java_home



Talend Preferences:
I added the version of Java running my Job through the BAT file




My DBConnection on talend:




Talend Job:





Result, after run on "Basic Run":

Result, after run on "Debug Run" using "Java Debug":




If you need more information, please contact us
In regards.
Thank you