Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JCC1
Contributor II
Contributor II
‎2022-09-12 09:21 PM

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)
Labels
1,007 Views
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2022-09-19 11:25 PM

In response to JCC1

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

1,007 Views
0 Likes
9 Replies
Anonymous
Not applicable
‎2022-09-13 05:56 AM

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

1,007 Views
0 Likes
JCC1
Contributor II
Contributor II
‎2022-09-15 08:18 PM
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]

1,007 Views
0 Likes
Anonymous
Not applicable
‎2022-09-15 11:59 PM

In response to JCC1

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

1,007 Views
0 Likes
JCC1
Contributor II
Contributor II
‎2022-09-16 02:24 PM
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

1,007 Views
0 Likes
Anonymous
Not applicable
‎2022-09-18 10:55 PM

In response to JCC1

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

1,007 Views
0 Likes
JCC1
Contributor II
Contributor II
‎2022-09-19 01:07 AM
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

1,007 Views
0 Likes
Anonymous
Not applicable
‎2022-09-19 11:25 PM

In response to JCC1

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

1,008 Views
0 Likes
JCC1
Contributor II
Contributor II
‎2022-11-03 01:21 PM
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.

1,007 Views
0 Likes
Anonymous
Not applicable
‎2022-11-04 04:11 AM

Hello @ASDG Support​ 

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

Best regards

Sabrina

1,007 Views
0 Likes