Six Stars

Error While Execution of Talend job using Crontab

Hi,

I tried to schedule the job using unix crontab but i am getting connection error ...

But this job is running fine on talend open studio..

can anybody help  me to resolve the give below is the error while connecting to oracle database...

 

 

java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at local_project.job_document_types_004_stg2_0_1.job_DOCUMENT_TYPES_004_Stg2.tOracleConnection_1Process(job_DOCUMENT_TYPES_004_Stg2.java:1599)
at local_project.job_document_types_004_stg2_0_1.job_DOCUMENT_TYPES_004_Stg2.tRunJob_1Process(job_DOCUMENT_TYPES_004_Stg2.java:1454)
at local_project.job_document_types_004_stg2_0_1.job_DOCUMENT_TYPES_004_Stg2.tPrejob_1Process(job_DOCUMENT_TYPES_004_Stg2.java:763)
at local_project.job_document_types_004_stg2_0_1.job_DOCUMENT_TYPES_004_Stg2.runJobInTOS(job_DOCUMENT_TYPES_004_Stg2.java:9720)
at local_project.job_document_types_004_stg2_0_1.job_DOCUMENT_TYPES_004_Stg2.main(job_DOCUMENT_TYPES_004_Stg2.java:9543)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)
at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
at oracle.net.ns.DataPacket.send(DataPacket.java:209)
at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:215)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:302)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:426)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:439)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:580)
... 11 more
Connection Error

  • Data Integration
  • Talend Runtime
1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

Re: Error While Execution of Talend job using Crontab

Thanks vapukov,
Solution worked for me.
I changed this two line i java.security file now it is working fine
% java -Djava.security.egd=file:/dev/urandom MainClass
securerandom.source=file:/dev/urandom
8 REPLIES
Ten Stars

Re: Error While Execution of Talend job using Crontab

do You have this error only from cron or also when run Job from shell?

-----------
Six Stars

Re: Error While Execution of Talend job using Crontab

in both i am getting his error.. When try to run the job using unix having oracle component it is giving this error..
Tags (1)
Six Stars

Re: Error While Execution of Talend job using Crontab

Hi Forum,
This issue is not resolved,can you please help me on this issue.
Ten Stars

Re: Error While Execution of Talend job using Crontab

no one not open You a secrets Smiley Happy

 

only one way - step by step

 

as You confirm - crontab - not relate to the problem

let go forward - do You can connect from this machine to Oracle Server with any other tools?

 

simple reason usually is most right - may be it just network (firewall) issues

if You can connect - check settings

-----------
Six Stars

Re: Error While Execution of Talend job using Crontab

Hi,

I used this command to check weather we can connect to oracle server from putty

telnet blosdd01.cv2dbyklqgxy.ap-southeast-1.rds.amazonaws.com 1521

it is working fine.

Six Stars

Re: Error While Execution of Talend job using Crontab

Thanks vapukov,
Solution worked for me.
I changed this two line i java.security file now it is working fine
% java -Djava.security.egd=file:/dev/urandom MainClass
securerandom.source=file:/dev/urandom
Ten Stars

Re: Error While Execution of Talend job using Crontab

So, it is Your solution? ;-)

fine, next time - study Google Your self ;-)

-----------