Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
JCC1
Contributor II
Contributor II

Connection Reset Error - TAC and Talend Server

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

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

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

View solution in original post

9 Replies
Anonymous
Not applicable

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
Contributor II
Contributor II
Author

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
Not applicable

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
Contributor II
Contributor II
Author

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
Not applicable

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
Contributor II
Contributor II
Author

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
Not applicable

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
Contributor II
Contributor II
Author

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
Not applicable

Hello @ASDG Support​ 

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

Best regards

Sabrina