Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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]
Hello,
We have relied to your another topic about:
Could you please have a look at this?
Best regards
Sabrina
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
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
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
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
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.
Hello @ASDG Support
What error message are you getting after adding required jar files Via tLibraryLoad component in your job?
Best regards
Sabrina