topic Re: ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException: in SAS Data Management

ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

pauger2 — Wed, 05 Oct 2016 21:29:13 GMT

Hello All!

Has anyone encountered the error below while writing to hadoop?

Can you please share some insight and how you got around it.

ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

java.net.SocketException: Software caused connection abort: recv failed

Thanks.

Re: ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

JBailey — Wed, 12 Oct 2016 18:22:05 GMT

Hi @pauger2,

Can you tell us which Hadoop distribution you are using, provide a code sample which reproduces the error, and include the entire error message (Java dump)?

Thanks!

Jeff

Re: ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

pauger2 — Wed, 12 Oct 2016 21:00:55 GMT

Hi Jeff,

Thanks for your response.

The hadoop distribution is Hortonworks and hadoop version is 2.7.1.2.3.4.23-3.

Attached is a full dump of the log...luckily I used sastrace= option.

I see the same error when I am closing my sas session in the log window as well....I attach as well.

Thanks,

Gerald

Re: ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

pauger2 — Wed, 12 Oct 2016 21:01:51 GMT

....here is what I see in my log window when exiting sas.

Re: ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

JBailey — Tue, 18 Oct 2016 15:03:37 GMT

Hi @pauger2

Your KNOX_GATEWAY_URL= value does not include the Knox port number. This could be a problem.

OPTIONS SET=KNOX_GATEWAY_URL='https://knox-dev.some-madeup-corp.com/gateway/default';

Have you installed the SAS Hotfix for Knox?

Problem Note 56644: The SAS/ACCESS® Interface to Hadoop does not support Hortonworks Apache Knox Gateway

Best wishes,

Jeff