Symptom
- A Process Orchestration (PO) or Process Integration (PI) JDBC Adapter interface connecting to a mySQL Database fails with the error:
[EXCEPTION]
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet successfully received from the server was 12 milliseconds ago. The last packet sent successfully to the server was 11 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:34)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:21)
at java.lang.reflect.Constructor.newInstance(Constructor.java:578)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:947)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:376)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:111)
at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:6847)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2571)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor1039.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:204)
at com.sap.aii.adapter.jdbc.JDBCConnectionPool.createNewResource(JDBCConnectionPool.java:67)
at com.sap.aii.af.lib.util.concurrent.AbstractResourcePool.getResource(AbstractResourcePool.java:151)
at com.sap.aii.adapter.jdbc.XI2JDBC.getDBConnection(XI2JDBC.java:1211)
at com.sap.aii.adapter.jdbc.ReceiverChannelTester.performTest(ReceiverChannelTester.java:67)
at com.sap.aii.adapter.jdbc.AdminAdapter.testReceiverChannel(AdminAdapter.java:589)
at com.sap.aii.adapter.jdbc.AdminAdapter.testChannel(AdminAdapter.java:599)
at com.sap.aii.af.service.administration.impl.AdminManagerImpl.getChannelSelfTestResults(AdminManagerImpl.java:783)
at com.sap.aii.af.service.administration.impl.cluster.ClusterManager.eventReceivedSync(ClusterManager.java:948)
at com.sap.aii.af.service.event.impl.worker.sync.SyncLocalWorker.work(SyncLocalWorker.java:71)
at com.sap.aii.af.service.event.impl.worker.sync.AbstractSyncWorker.startWork(AbstractSyncWorker.java:40)
at com.sap.aii.af.service.event.impl.EventManagerImpl.sendEventAndWaitForAnswer(EventManagerImpl.java:489)
at com.sap.aii.af.service.event.impl.EventManagerImpl.syncClusterEventReceived(EventManagerImpl.java:428)
at com.sap.aii.af.service.monitor.impl.ClusterController.receiveWait(ClusterController.java:261)
at com.sap.engine.core.cluster.MessageListenerWrapper.process(MessageListenerWrapper.java:96)
at com.sap.engine.core.cluster.impl6.p2pnio.MessageRunner.run(MessageRunner.java:65)
at com.sap.engine.frame.core.thread.Task.run(Task.java:73)
at com.sap.engine.core.thread.impl5.SingleThread.execute(SingleThread.java:178)
at com.sap.engine.core.thread.impl5.SingleThread.run(SingleThread.java:316)
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
at sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:171)
at sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:106)
at sun.security.ssl.TransportContext.kickstart(TransportContext.java:237)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:405)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:384)
at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186) - This can occur after updating the software in either the PI/PO system or the MySQL database
Read more...
Environment
- SAP NetWeaver 7.5
Product
SAP NetWeaver 7.5
Keywords
SSL, TLS, security, cipher suite, driver, jar file, deployed , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview