https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600474#M18319 <P>I'm pleased to hear it!</P> <P>&nbsp;</P> <P>Happy computing,</P> <P>&nbsp; &nbsp;Tom</P> Wed, 30 Oct 2019 17:41:12 GMT TomKari 2019-10-30T17:41:12Z https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600169#M18309 <P>Hello everyone,</P><P>&nbsp;</P><P>I had been using an ODBC to connect SAS to Athena for months. Now when I try to connect, it's throwing me this error:</P><P><STRONG>ERROR: CLI open cursor error: [Simba][Athena] (1040) An error has been thrown from the AWS Athena</STRONG><BR /><STRONG>client. Athena Error No: 100, Error Message: No response body. [Execution ID:</STRONG><BR /><STRONG>edd966b7-12bc-4938-b461-276668116e36]</STRONG></P><P>&nbsp;</P><P>It's doing the same thing for everyone on my team. The ODBC still connects successfully and we can access the data through Python, so I'm pretty certain the problem stems from SAS.</P><P>&nbsp;</P><P>Do you guys have any insights as to what's going on?</P><P>&nbsp;</P><P>Thanks!</P> Tue, 29 Oct 2019 20:18:55 GMT https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600169#M18309 renaudguilbert 2019-10-29T20:18:55Z https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600202#M18311 <P>I think that's what SAS does when it catches an error from the database software, and doesn't know what else to do with it. I think the "Athena Error No: 100, Error Message: No response body." is what SAS is getting back from Athena. Can you look up that error number in the Athena documentation?</P> <P>&nbsp;</P> <P>Are you sure you're successfully connecting to the database using ODBC from the same machine that's running the SAS session?</P> <P>If so, maybe:<BR />- credential changes?<BR />- firewall / network changes?</P> <P>&nbsp;</P> <P>You could take a look at the SASTRACE system option, using it might return some useful information.</P> <P>&nbsp;</P> <P>Good luck!<BR />Tom</P> Tue, 29 Oct 2019 22:36:55 GMT https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600202#M18311 TomKari 2019-10-29T22:36:55Z https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600403#M18315 <P>Hello,</P><P>&nbsp;</P><P>You were right, the issue was linked to a new firewall update that shut the connection down while it was being deployed. I checked with our IT department and the connection was restored when the deployment was complete.</P><P>&nbsp;</P><P>Thank you!</P> Wed, 30 Oct 2019 14:11:24 GMT https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600403#M18315 renaudguilbert 2019-10-30T14:11:24Z https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600474#M18319 <P>I'm pleased to hear it!</P> <P>&nbsp;</P> <P>Happy computing,</P> <P>&nbsp; &nbsp;Tom</P> Wed, 30 Oct 2019 17:41:12 GMT https://communities.sas.com/t5/SAS-Data-Management/Error-in-SAS-Athena-An-error-has-been-thrown-from-the-AWS-Athena/m-p/600474#M18319 TomKari 2019-10-30T17:41:12Z