SAS APP is utf-8 encoding server. from SAS EG, run "libname test9 odbc dsn=MSSQLTest authdomain=mssqlAuth;" this command run ok. DB have one table "TEST", but from library show "t"   when open "t", get error     ... View more

I have a problem with oracle db using odbc, please help me. on SAS APP:  - OS: RHEL8.9 - instal oracle client 19c, unixODBC - test local OK [sas@sasapp ~]$ vi /home/sas/.odbc.ini [Oracle19] Driver              = /u01/app/sas/product/19.0.0/client_1/lib/libsqora.so.19.1 Description         = Oracle 19.3 ODBC driver ServerName          = ORA19TEST   [sas@sasapp ~]$ isql Oracle19 test <pw> +---------------------------------------+ | Connected!                            | |                                       | | sql-statement                         | | help [tablename]                      | | quit                                  | |                                       | +---------------------------------------+ SQL> on SAS META, config Library and add table OK     on client, window 10, using SAS Enterprise Guide, have one error     ... View more

  I use Enterprise Guide with user sasadm@saspw   proc metalib; omr (library="sasdbetlLIB"); run; ERROR: The user does not have permission to perform this action.       Detail logs: 1 The SAS System 01:23 Saturday, July 15, 2023 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program 1'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='/home/main-sas/Project.egp'; 6 %LET _CLIENTPROJECTPATHHOST='dc-sas-app'; 7 %LET _CLIENTPROJECTNAME='Project.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 27 28 /* sync up metadata with physical library */ 29 /* requires Create permissions for the library */ 30 /*libname _temp meta library="sasdbetlLIB" metaout=data;*/ 31 /*proc metalib; 32 /*omr (library="sasdbetlLIB");*/ 33 /*update_rule=(delete);*/ 34 /*select(NEWDATA);*/ 35 /*report;*/ 36 /*run;*/ 37 /*libname _temp clear;*/ 38 proc metalib; 39 omr (library="sasdbetlLIB"); 40 run; ERROR: The user does not have permission to perform this action. NOTE: A total of 1 tables were analyzed for library "sasdbetlLIB". NOTE: Metadata for 0 tables was updated. NOTE: Metadata for 0 tables was added. NOTE: Metadata for 1 tables matched the data sources. NOTE: 0 other tables were not processed due to error or UPDATE_RULE. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE METALIB used (Total process time): real time 0.45 seconds cpu time 0.12 seconds 41 42 %LET _CLIENTTASKLABEL=; 43 %LET _CLIENTPROCESSFLOWNAME=; 44 %LET _CLIENTPROJECTPATH=; 45 %LET _CLIENTPROJECTPATHHOST=; 2 The SAS System 01:23 Saturday, July 15, 2023 46 %LET _CLIENTPROJECTNAME=; 47 %LET _SASPROGRAMFILE=; 48 %LET _SASPROGRAMFILEHOST=; 49 50 ;*';*";*/;quit;run; 51 ODS _ALL_ CLOSE; 52 53 54 QUIT; RUN; 55 ... View more

I use sas management console connect to sas meta with user "sasadm@saspw",  after create server, library then register table,  have error: --- NOTE: SAS Initialization used (Total process time): real time 0.07 seconds cpu time 0.00 seconds NOTE: The autoexec file, /u01/SASConfig/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization. 1 LIBNAME LIBPOSG ODBC DATAsrc=postgresdb1 USER=postgres PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ; NOTE: Libref LIBPOSG was successfully assigned as follows: Engine: ODBC Physical Name: postgresdb1 2 2 The SAS System 18:19 Friday, June 30, 2023 3 proc metalib 4 ; 4 ! omr (LIBURI="A5FSLUGQ.B5000006" 5 user="sasadm@saspw" password=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX 6 ); 7 REPORT(type = summary out = "tab_info"); 8 SELECT ("CAS_USERS" 9 ); 10 FOLDERID = "A5FSLUGQ.AA000002"; 11 run; ERROR: CLI error trying to establish connection: connection to server at "10.4.18.143", port 5432 failed: FATAL: password authentication failed for user "postgres" NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE METALIB used (Total process time): real time 0.24 seconds cpu time 0.10 seconds ... View more

log show: ---- [echo] jdbc classpath dir: /home/sas/JDBC [addAccessControl.groovy] [echo] Starting addAccessControl.groovy... [addAccessControl.groovy] [addAccessControl.groovy] [echo] creating datasource [addAccessControl.groovy] [addAccessControl.groovy] org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'oracle.jdbc.internal.Monitor$1MonitorImpl@2f5f52b' with class 'oracle.jdbc.internal.Monitor$1MonitorImpl' to class 'java.sql.Driver' ... View more

on meta machine, i mount share samba OK, write OK with user sas, but run backup failed.   [root@sasmeta sasbackup]# ll total 1 drwxr-xr-x 2 sas sas 0 May 17 19:55 2023-05-17T20_25_05+07_00 drwxr-xr-x 2 sas sas 0 May 17 19:55 2023-05-17T20_26_26+07_00 -rwxr-xr-x 1 sas sas 0 May 17 20:20 MetadataServerBackupConfiguration.xml -rwxr-xr-x 1 sas sas 0 May 17 20:26 MetadataServerBackupHistory.xml -rwxr-xr-x 1 sas sas 2 May 17 19:48 t.t ... View more