SAP Knowledge Base Article - Preview

3237847 - SAP PO JDBC Adapter "Communications link failure" error

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.