Error when executing the batch (packaged job) on another machine

Anonymous — Sat, 16 Nov 2024 08:50:49 GMT

I have a Project with three Jobs on my machine (Windows 10) and they all run fine.

When I export them to another machine (Windows Server 2012) and execute the batches only two run fine and one fails.

What the failed job does is extract tables from Oracle NetSuite Cloud ERP and load them into the MSSQL Server Express located in the Windows Server 2012 machine.

The job that fails has the following batch code:

%~d0
cd %~dp0
java -Xms256M -Xmx1024M -cp .;../lib/routines.jar;../lib/NQjc.jar;../lib/dom4j-1.6.1.jar;../lib/log4j-1.2.16.jar;../lib/mssql-jdbc.jar;rd_1_0.jar; ricardoperez.rd_1_0.RD --context=Default %*

And the error result is:

C:\Ricardo Caro\Job Designs\RD>C:

C:\Ricardo Caro\Job Designs\RD>cd C:\Ricardo Caro\Job Designs\RD\

C:\Ricardo Caro\Job Designs\RD>java -Xms256M -Xmx1024M -cp .;../lib/routines.ja
r;../lib/NQjc.jar;../lib/dom4j-1.6.1.jar;../lib/log4j-1.2.16.jar;../lib/mssql-jd
bc.jar;rd_1_0.jar; ricardocaro.rd_1_0.RD --context=Default
[statistics] disconnected
Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/Dataty
peConverter
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerC
onnection.java:4098)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConne
ction.java:3160)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServer
Connection.java:43)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecu
te(SQLServerConnection.java:3123)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe
rverConnection.java:2445)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLSer
verConnection.java:1981)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConne
ction.java:1628)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLS
erverConnection.java:1459)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerCon
nection.java:773)
        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.
java:1168)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
        at ricardocaro.rd_1_0.RD.tJDBCInput_2Process(RD.java:881)
        at ricardocaro.rd_1_0.RD.runJobInTOS(RD.java:14162)
        at ricardocaro.rd_1_0.RD.main(RD.java:14016)
Caused by: java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter
        at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown So
urce)
        at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(U
nknown Source)
        at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
        ... 16 more

Re: Error when executing the batch (packaged job) on another machine

Anonymous — Wed, 17 Jan 2018 23:56:48 GMT

I just solved it myself!

Had to change the DB Version of the MSSQL Database Connection from 'Microsoft' to 'Open source JTDS'

topic Re: Error when executing the batch (packaged job) on another machine in Talend Studio

Error when executing the batch (packaged job) on another machine

Re: Error when executing the batch (packaged job) on another machine