BookmarkSubscribeRSS Feed
r_alation
Calcite | Level 5

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?

 

2 REPLIES 2
gwootton
SAS Super FREQ
Are there any other messages indicating the details of the exception being encountered? Does the behavior change if you use JDBC driver version 94290?
https://support.sas.com/downloads/package.htm?pid=2620
--
Greg Wootton | Principal Systems Technical Support Engineer
a_alation
Calcite | Level 5
We are unable to test that our internally as our license has expired.

But we are seeking help on this since, we got to know from one of our customer that with AES encryption the above mentioned driver is not working.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 203 views
  • 0 likes
  • 3 in conversation