Hello I have been able to configure Connection to Databricks on Windows server. Using SAS EG I am able to create a libname statement and library is created. But I cannot see any tables. My code is libname dbrk odbc dsn="dbrk" user="clinet-id" password="password" schema="catalog.schema"; proc sql; select * from dictionary.tables where libname="DBRK"; quit; Works perfectly library is created. But do not see any tables. The log is as follows libname dbrk odbc dsn="dbrk" user="client-id" password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 27 ! schema="catalog.schema"; NOTE: Libref DBRK was successfully assigned as follows: Engine: ODBC Physical Name: dbrk 28 proc sql; 29 select * from dictionary.tables where libname="DBRK"; NOTE: No rows were selected. 30 quit; ... View more

We are using SAS Viya 4 2024.09 LTS on AWS. I am trying to test connectivity to Databricks on AWS using JDBC but having errors. My code is as follows libname libdbrk jdbc classpath="/opt/sas/viya/home/lib64/accessclients/jdbc" driver="/opt/sas/viya/home/lib64/accessclients/jdbc/cdata-jdbc-databricks-23.0.8806.0.jar" class="cdata.jdbc.databricks.DatabricksDriver" URL="jdbc:databricks://xyz.cloud.databricks.com:443;AuthMech='11';Auth_Flow='1'; database=dev_test.test_schema; HTTPPath=/sql/1.0/warehouses/abcdxyz; OAuth2ClientId='Client_ID'; OAuth2Secret='Client Secret'"; The log is WARNING: Libref LBDBRK is not assigned. 30 libname lbdbrk jdbc classpath="/opt/sas/viya/home/lib64/accessclients/jdbc" 31 driver="/opt/sas/viya/home/lib64/accessclients/jdbc/cdata-jdbc-databricks-23.0.8806.0.jar" 32 class="cdata.jdbc.databricks.DatabricksDriver" 33 URL="jdbc:databricks://xyz.cloud.databricks.com:443;AuthMech='11';Auth_Flow='1'; 34 database=dev_test.test_schema; 35 HTTPPath=/sql/1.0/warehouses/abcdxyz;OAuth2ClientId='Client_ID'; 35 ! OAuth2Secret='Client-Secret'"; NOTE: The "CLASSPATH" option has been deprecated and will be ignored. Please refer to SAS documentation for instructions on setting the JDBC SAS/ACCESS classs path. ERROR: Error trying to establish connection: java.sql.SQLClientInfoException: 'useragententry' is not a valid connection property. ERROR: Error in the LIBNAME statement. Wondering if anybody can help? ... View more

Hello I have a SAS 9.4M4 environment in which there are files in the [SASConfig]/Lev1/Web/Staging/exploded/platformpws/platform/WEB-INF/lib. There are jar files under this folder. Wondering if these can be safely deleted? ... View more

Hello We are running SAS 9.4M6 Server on Windows Server. Report consumers authenticate to the Stored Process web Interface and generate reports as needed.  Authentication fails for users who have configured "Windows Hello" on their laptop. The error is incorrect username/password. These users   reach the following screen but cannot type their username and password Request guidance from the community. ... View more

Hello We have SAS 9.4M6 Server installed on Windows OS. Different users login to the stored process interface to generate reports. Sometimes there is a login failure. I don't see such login failures logged in metadata server logs. Wondering if there is a log where I can find these failures and the cause logged? ... View more

Hello I see a large number of jobs for example sas-update-checker, sas-deployment-operator-reconcile ,sas-backu-job etc listed when I check for completed jobs using kubectl. Can these completed jobs be deleted? I always delete any adhoc start / stop jobs I create. ... View more

Hello Wondering if there are any downsides in moving from LTS to Stable Cadence (Other than support level)? Any thing to look out for? ... View more