Error While Execution of Talend job using Crontab

[Anonymous]

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

[vapukov]

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

[Anonymous]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

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.

[vapukov]

ok, great

try read this discussions:

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

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

https://community.talend.com/t5/Design-and-Development/resolved-Connection-reset-on-tOracleConnectio...

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

[Anonymous · Accepted solution]

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

[vapukov]

So, it is Your solution? 😉

fine, next time - study Google Your self 😉