While connecting to the SAS via JDBC driver, we are getting below error:
com.sas.rio.MVASQLException: Unable to establish connection. An exception was thrown during the encryption key exchange.
"java.io.EOFException: null
at com.sas.net.crypto.jce.JceCipher$BasePhase.recv(JceCipher.java:636) ~[APP.jar:?]
at com.sas.net.crypto.jce.JceCipher$SizePhase.transmit(JceCipher.java:691) ~[APP.jar:?]
at com.sas.net.crypto.jce.JceCipher.keyExchange(JceCipher.java:81) ~[APP.jar:?]
at com.sas.iom.orb.brg.Engine.handleStatus(Engine.java:5014) ~[APP.jar:?]
at com.sas.iom.orb.brg.Engine0200.flowSendReqs(Engine0200.java:188) ~[APP.jar:?]
at com.sas.iom.orb.brg.Engine.flow(Engine.java:720) ~[APP.jar:?]
at com.sas.iom.orb.brg.Engine.initClient(Engine.java:681) ~[APP.jar:?]
at com.sas.iom.orb.brg.ORBImpl.uri_to_object(ORBImpl.java:114) ~[APP.jar:?]
at com.sas.services.connection.ClusterEnvelope.createObject(ClusterEnvelope.java:395) ~[APP.jar:?]
at com.sas.services.connection.ClusterEnvelope.getConnection(ClusterEnvelope.java:87) ~[APP.jar:?]
at com.sas.services.connection.AggregationKernel.doGetConnection(AggregationKernel.java:242) ~[APP.jar:?]
at com.sas.services.connection.ConnectionFactoryKernel.getConnection(ConnectionFactoryKernel.java:325) ~[APP.jar:?]
at com.sas.services.connection.ConnectionFactoryShell.getConnection(ConnectionFactoryShell.java:69) ~[APP.jar:?]
at com.sas.services.connection.ConnectionFactoryShell.getConnection(ConnectionFactoryShell.java:51) ~[APP.jar:?]
at com.sas.rio.RIOUtil.getWorkspace(RIOUtil.java:1881) ~[APP.jar:?]
at com.sas.rio.RIOUtil.<init>(RIOUtil.java:304) ~[APP.jar:?]
at com.sas.rio.MVAConnection.<init>(MVAConnection.java:254) ~[APP.jar:?]
at com.sas.rio.MVADriver.connect(MVADriver.java:280)
Additional info:
- JDBC driver version 94280
- SAS version 9.4
- SAS is setup using AES 64-bit encryption
- JDBC URI format: "sasiom://<hostname_or_ip>:<port>?libref=<library_name>'/<library_location>'"
Can you please let us know what could be the issue here?