Five 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
2 REPLIES
Seven 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?

-----------
Five 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)