Hello,
I use for the first time fedsql with rsubmit.
I have i my log this error
proc fedsql;
ERROR: General error ORA-01017: invalid username/password; logon denied
ERROR: TKTS initialization failed.
I use this request
%let srv_c=xxxxxxxx port;
%let user_c = xxxxxxx ;
%let pwd_c = xxxxxxxx ;
options comamid=tcp remote=srv_c;
signon user="&user_c" password="&pwd_c" ;
rsubmit srv_c ;
option obs=max nosyntaxcheck;
libname myora oracle PATH="xxxxxx" SCHEMA="xxxxxxxx" USER="xxxxxxxxxxxxxxxxxxxx" PASSWORD="xxxxxxxxxxxxxxxxx" access=readonly defer=yes ;
endrsubmit ;
libname myora server = srv_c;
rsubmit;
proc fedsql;
create table table as select a.*
from myora.table as a
;
quit;
endrsubmit;
can you help me
thank you
Well, it looks like you have not correct credentials.
Or is there something in the set-up that tells that there something different...?
Thank you,
I remake the test:
proc fedsql;
select sex, avg(height) as avg_height, avg(weight) as avg_weight from
sashelp.class group by sex;
quit;
Log:
1 proc fedsql;
NOTE: Writing HTML Body file: sashtml.htm
2 select sex, avg(height) as avg_height, avg(weight) as avg_weight from
3 sashelp.class group by sex;
ERROR: Table "SASHELP.CLASS" does not exist or cannot be accessed
ERROR: BASE driver, schema name SASHELP was not found for this connection
4 quit;
With rsubmit:
rsubmit;
proc fedsql;
select sex, avg(height) as avg_height, avg(weight) as avg_weight from
sashelp.class group by sex;
quit;
endrsubmit;
Log:
455 proc fedsql;
ERROR: General error ORA-28000: the account is locked
ERROR: TKTS initialization failed.
456 select sex, avg(height) as avg_height, avg(weight) as avg_weight from
457 sashelp.class group by sex;
458 quit;
This now, work normaly
libname tt 'C:\';
data tt.test;
set sashelp.class;run;
proc fedsql;
create table test1 as
select * from tt.test;
quit;
The SASHELP library is not available to PROC FEDSQL or PROC DS2. The FedSQL and DS2 languages run outside of the SAS supervisor kernel, so cannot access SASHELP. They are also not affected by most SAS system options.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.