Connection Reset Error - TAC and Talend Server

[JCC1]

We are getting error after setting the context variable for new Oracle Server 19c connection. TAC Studio is not opening projects getting "connection reset error" and also affecting the Non-Prod environment server. The services like cmdline and TAC are not getting started. Need help ASAP.

Thanks

Ram

[Anonymous]

Hello,

The issue connection reset error" occurs when tac is trying to make a connection to db due to which the number of open connections is unavailable.

"Can you please try to increase the max open connection to a higher value in the oracle db and restart the server and check the issue?

Thanks

Kavya S

[JCC1]

Hello Sreeram

We are still getting the error. I suspect the driver issue or wallet issue since the database we are talking to is using tcps connection.

[statistics] connecting to socket on port 3629

[statistics] connected

Exception in component tOracleInput_7 (DCACS_ACCMS_ATTORNEY)

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 projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tOracleInput_7Process(DCACS_ACCMS_ATTORNEY.java:4648)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tFixedFlowInput_1Process(DCACS_ACCMS_ATTORNEY.java:2191)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tJava_6Process(DCACS_ACCMS_ATTORNEY.java:1738)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.runJobInTOS(DCACS_ACCMS_ATTORNEY.java:15576)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.main(DCACS_ACCMS_ATTORNEY.java:14954)

Caused by: java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(SocketInputStream.java:210)

at java.net.SocketInputStream.read(SocketInputStream.java:141)

at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)

at sun.security.ssl.InputRecord.read(InputRecord.java:503)

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)

at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)

at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:750)

at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)

at oracle.net.ns.Packet.send(Packet.java:419)

at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:241)

at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:151)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)

... 11 more

[FATAL]: projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY - tOracleInput_7 IO Error: Connection reset

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 projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tOracleInput_7Process(DCACS_ACCMS_ATTORNEY.java:4648)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tFixedFlowInput_1Process(DCACS_ACCMS_ATTORNEY.java:2191)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tJava_6Process(DCACS_ACCMS_ATTORNEY.java:1738)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.runJobInTOS(DCACS_ACCMS_ATTORNEY.java:15576)

at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.main(DCACS_ACCMS_ATTORNEY.java:14954)

Caused by: java.net.SocketException: Connection reset

at java.net.SocketInputStream.read(SocketInputStream.java:210)

at java.net.SocketInputStream.read(SocketInputStream.java:141)

at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)

at sun.security.ssl.InputRecord.read(InputRecord.java:503)

at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)

at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)

at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:750)

at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)

at oracle.net.ns.Packet.send(Packet.java:419)

at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:241)

at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:151)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)

... 11 more

DCACS_ACCMS_ATTORNEY - IO Error: Connection reset

2022-09-15 17:09:32|It88tc|It88tc|It88tc|PROJECTS_BIP_DCACS|DCACS_ACCMS_ATTORNEY|Default|6|Java Exception|tOracleInput_7|java.sql.SQLRecoverableException:IO Error: Connection reset|1

*** display from tJavaRow_2 *** 

 - Error in Talend component: tOracleInput_7

 - Error Message: java.sql.SQLRecoverableException:IO Error: Connection reset

[statistics] disconnected

Job DCACS_ACCMS_ATTORNEY ended at 17:09 15/09/2022. [Exit code = 0]

[Anonymous]

Hello,

We have relied to your another topic about:

https://community.talend.com/s/question/0D55b00007n27bICAQ/issue-with-integrating-oracle-19c-with-ta...

Could you please have a look at this?

Best regards

Sabrina

[JCC1]

We are using Talend 7.3.1 and ojdbc10.jar to Support Oracle 19c. We are using Oracle Custom connection. Here are the details:

"jdbc:oracle:thin:@(description=(address=(protocol=tcps)(host="+context.ACCMS_Server+")(port="+context.ACCMS_Port+"))(connect_data=(service_name="+context.ACCMS_ServiceName+")))"

Please guide us with the steps to resolve this issue. Also we can have a MS Teams video meeting, that we can setup, so that you can see the process we are running and the configuration we need to do in TAC and Talend server for Oracle 19c.

Thanks

Ram

[Anonymous]

Hello Ram,

Is your Oracle Db connection working well in metadata of studio? Are you able to establish DB connection successfully without using context variable?

Best regards

Sabrina

[JCC1]

Hello Sabrina,

Yes. Please see the attached screenshot (Talendconnection.pdf). I think what is happening is, the talend connection needs to provide SSL connection checkbox and its parameters which don't appear on the screen.

Ram

[Anonymous · Accepted solution]

Hello,

We missed the SSL support during the Oracle 18c and above.

Here exists a jira issue: https://jira.talendforge.org/browse/TDI-46913

Before connection component, please add the following jar files Via tLibraryLoad components

oraclepki.jar

osdt_core.jar

osdt_cert.jar

Feel free to let us know if it helps.

Best regards

Sabrina

[JCC1]

Hello All,

We tried downloading the jar files and added a load module program, but still we were unable to connect to Oracle 19c on TCPS port.

[Anonymous]

Hello @ASDG Support​ 

What error message are you getting after adding required jar files Via tLibraryLoad component in your job?

Best regards

Sabrina