rsubmit fedsql

[mansour_ib_sas]

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

[LinusH]

Well, it looks like you have not correct credentials.

Or is there something in the set-up that tells that there something different...?

[mansour_ib_sas]

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;

[mansour_ib_sas]

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;

[SylviaPowell]

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.