topic Re: Error While Execution of Talend job using Crontab in Talend Studio

Error While Execution of Talend job using Crontab

Anonymous — Sat, 16 Nov 2024 09:48:21 GMT

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

Re: Error While Execution of Talend job using Crontab

vapukov — Wed, 10 May 2017 13:22:03 GMT

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

Re: Error While Execution of Talend job using Crontab

Anonymous — Wed, 10 May 2017 15:35:00 GMT

in both i am getting his error.. When try to run the job using unix having oracle component it is giving this error..

Re: Error While Execution of Talend job using Crontab

Anonymous — Mon, 12 Jun 2017 07:29:53 GMT

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

Re: Error While Execution of Talend job using Crontab

vapukov — Mon, 12 Jun 2017 09:39:04 GMT

no one not open You a secrets

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

Re: Error While Execution of Talend job using Crontab

Anonymous — Mon, 12 Jun 2017 11:44:39 GMT

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.

Re: Error While Execution of Talend job using Crontab

vapukov — Mon, 12 Jun 2017 11:57:16 GMT

ok, great

try read this discussions:

https://stackoverflow.com/questions/43777075/java-sql-sqlexception-i-o-error-connection-reset-in-linux-server

https://stackoverflow.com/questions/2327220/oracle-jdbc-intermittent-connection-issue

https://community.talend.com/t5/Design-and-Development/resolved-Connection-reset-on-tOracleConnection/td-p/103210

http://docs.oracle.com/cd/E13209_01/wlcp/wlss31/configwlss/jvmrand.html

Re: Error While Execution of Talend job using Crontab

Anonymous — Mon, 12 Jun 2017 15:47:49 GMT

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

Re: Error While Execution of Talend job using Crontab

vapukov — Mon, 12 Jun 2017 21:29:03 GMT

So, it is Your solution? 😉

fine, next time - study Google Your self 😉