BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Narendra_P
Fluorite | Level 6

Hi Team,

 

I am encountering below SSL verification error while attempting to trigger a sas viya(task 1_code1.sas) job from apache airflow using python script.

 

ERROR - Failed to execute job 134 for task 1_code1.sas (SASStudioOperator error: HTTPSConnectionPool(host='sas-viya.gcp.xxx.xxx.ca', port=443): Max retries exceeded with url: //SASLogon/oauth/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1131)'))); 3467

 

i have tried adding the following code to disable SSL verification in the python script. However, the problem persists.

import requests

# URL of the host for which SSL verification needs to be disabled
host_url = "https://sas-viya.gcp.xxx.xxx.ca"

# Disable SSL verification
response = requests.get(host_url, verify=False)

and i have tried adding {"verify": "/path/to/ca.crt"} in the connection's extra field, to use the specified CA certificate for SSL verification. However, the problem persists.

Narendra_P_0-1707130524436.png

 

Could you please suggest on this issue?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gwootton
SAS Super FREQ
According to the SAS airflow doc you need to specify the SSL CA or turn off certificate validation using the ssl_certificate_verification setting rather than "verify":
https://github.com/sassoftware/sas-airflow-provider?tab=readme-ov-file#create-a-connection-to-sas
--
Greg Wootton | Principal Systems Technical Support Engineer

View solution in original post

1 REPLY 1
gwootton
SAS Super FREQ
According to the SAS airflow doc you need to specify the SSL CA or turn off certificate validation using the ssl_certificate_verification setting rather than "verify":
https://github.com/sassoftware/sas-airflow-provider?tab=readme-ov-file#create-a-connection-to-sas
--
Greg Wootton | Principal Systems Technical Support Engineer

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
  • 1 reply
  • 458 views
  • 0 likes
  • 2 in conversation