topic Re: CAS Connection issue SAS Viya 4 in SAS Viya

CAS Connection issue SAS Viya 4

Mahis — Sun, 27 Oct 2024 09:49:45 GMT

Hi Community,

I'm trying to connect to Hadoop Hive using a new connection, but I encountered an error.

The connection to the data source driver failed.

Client unable to establish connection. System error: Connection refused
Function failed.
The action stopped due to errors.

If anyone has experienced a similar problem, could you please help me resolve this issue?

Re: CAS Connection issue SAS Viya 4

SASKiwi — Sun, 27 Oct 2024 21:52:34 GMT

If you haven't done so already Tech Support is your best way to progress this. You can open a track online here: https://service.sas.com/csm

Database connection setup is tricky and sometimes requires a lot of troubleshooting.

Re: CAS Connection issue SAS Viya 4

JuanS_OCS — Mon, 28 Oct 2024 03:13:02 GMT

Hi,

I agree, you might need SAS Technical Support for this. The only thing I can suggest for now:

- Do have your admins to check if the requirements are properly configured: https://documentation.sas.com/doc/en/itopscdc/v_057/itopssr/p03lkog7sche30n16nz48rhqe2ka.htm

- when they are 100% they are properly set, they can a) chech the driver connection without SAS and b) check the logs in the pods

Re: CAS Connection issue SAS Viya 4

Sajid01 — Wed, 20 Nov 2024 23:08:54 GMT

Based on my experience in similar scenarios, the first thing I would do is to check if there is any Firewall rule that is blocking the connection.

Re: CAS Connection issue SAS Viya 4

Mahis — Mon, 25 Nov 2024 16:18:27 GMT

@SASKiwi @Sajid01 @JuanS_OCS

Thank you for your replies. I forgot to add an update: the problem was that the Hive driver was down, and SAS Viya was unable to connect to it because of that.