topic Re: Exception in component tPOP_1 javax.mail.MessagingException: Connection timed out: connect; nested exception is: in Talend Studio

Exception in component tPOP_1 javax.mail.MessagingException: Connection timed out: connect; nested exception is:

Anonymous — Fri, 09 Mar 2018 09:18:46 GMT

Hello ,

I am trying to connect mailbox server using tPOP_1 component and I am getting following error:-

Exception in component tPOP_1
javax.mail.MessagingException: Connection timed out: connect;
nested exception is:
java.net.ConnectException: Connection timed out: connect
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:479)
at javax.mail.Service.connect(Service.java:275)
at javax.mail.Service.connect(Service.java:156)
at javax.mail.Service.connect(Service.java:105)
at epats.test1_0_1.test1.tPOP_1Process(test1.java:818)
at epats.test1_0_1.test1.runJobInTOS(test1.java:4058)
at epats.test1_0_1.test1.main(test1.java:3791)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at sun.security.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:618)
at sun.security.ssl.BaseSSLSocketImpl.connect(BaseSSLSocketImpl.java:160)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:163)
at com.sun.mail.iap.Protocol.<init>(Protocol.java:84)
at com.sun.mail.imap.protocol.IMAPProtocol.<init>(IMAPProtocol.java:87)
at com.sun.mail.imap.IMAPStore.protocolConnect(IMAPStore.java:446)
... 6 more
[statistics] disconnected
Job test1 ended at 19:40 09/03/2018. [exit code=1]

Thanks & Regard

Re: Exception in component tPOP_1 javax.mail.MessagingException: Connection timed out: connect; nested exception is:

Anonymous — Fri, 09 Mar 2018 15:32:20 GMT

Hi shy

it seems you do not get a response at all ! Test if you have a route to the destination with a ping, or telnet.

Once you have ensured there is a route to the destination, try again.

BR Bp

Re: Exception in component tPOP_1 javax.mail.MessagingException: Connection timed out: connect; nested exception is:

Anonymous — Tue, 13 Mar 2018 08:39:20 GMT

Hello,

Could you please show us your tPop component setting screenshot? Please mask your sensitive data.

Best regards

Sabrina

Re: Exception in component tPOP_1 javax.mail.MessagingException: Connection timed out: connect; nested exception is:

Anonymous — Wed, 14 Mar 2018 09:06:48 GMT

Hello ,

When I upload the job into TAC server then I am getting following error:-

Exception in component connectionStatsLogs
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at epats.epats_main_job_test_1_0_1.EPATS_Main_Job_TEST_1.connectionStatsLogsProcess(EPATS_Main_Job_TEST_1.java:5193)
at epats.epats_main_job_test_1_0_1.EPATS_Main_Job_TEST_1.preStaLogConProcess(EPATS_Main_Job_TEST_1.java:1006)
at epats.epats_main_job_test_1_0_1.EPATS_Main_Job_TEST_1.runJobInTOS(EPATS_Main_Job_TEST_1.java:7923)
at epats.epats_main_job_test_1_0_1.EPATS_Main_Job_TEST_1.main(EPATS_Main_Job_TEST_1.java:7686)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 12 more
Exception in component talendStats_DB
java.lang.NullPointerException
at

Please see the attachement of screen shot of POP component settin.

Thanks

Shyam kanungo

POP3_Server_error_2.PNG