Connection String Issue

Reply
New Contributor
Posts: 3

Connection String Issue

 

Hi,

 

I think I'm getting these messages because there's a problem with my connection string. Does that sound right? I'm using SAS EG.

 

ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.

ERROR: Remote submit to UNKNOWN canceled.

 

Thanks!

Super User
Posts: 3,861

Re: Connection String Issue

Posted in reply to paul_schulten

Please post your complete SAS log showing both the code and the errors. 

New Contributor
Posts: 3

Re: Connection String Issue

Hi,

I've copied the log and code below.

Thanks,
Paul



1 The SAS System 16:06 Thursday, January 18, 2018

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='ANI Match';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTNAME='';
7 %LET _SASPROGRAMFILE=;
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
11 GOPTIONS XPIXELS=0 YPIXELS=0;
12 FILENAME EGSR TEMP;
13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14 STYLE=HtmlBlue
15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHOME2/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
16 NOGTITLE
17 NOGFOOTNOTE
18 GPATH=&sasworklocation
19 ENCODING=UTF8
20 options(rolap="on")
21 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 rsubmit;
ERROR: Invalid or unspecified remote session ID. Set OPTIONS REMOTE=session_id.
NOTE: Subsequent lines will be ignored until ENDRSUBMIT.
ERROR: Remote submit to UNKNOWN canceled.
25
26 GOPTIONS NOACCESSIBLE;
27 %LET _CLIENTTASKLABEL=;
28 %LET _CLIENTPROCESSFLOWNAME=;
29 %LET _CLIENTPROJECTPATH=;
30 %LET _CLIENTPROJECTNAME=;
31 %LET _SASPROGRAMFILE=;
32
33 ;*';*";*/;quit;run;
34 ODS _ALL_ CLOSE;
35
36
37 QUIT; RUN;
38

rsubmit;
libname schulten '/workspace/lob2/wellsmktg/paul';
proc sql;
connect to aster (server="edaast1q.wellsfargo.com" database='EDAASTPRD' user='&LANID' password='&LANPWD');
drop table FRAC.cust_interactions;
create table FRAC.cust_interactions as select * from connection to aster(

SELECT distinct a.cust_num, b.ANI_NUMBER, a.start_date, b.connid, a.dnis
FROM "sbx_fraud_frac"."infomart_detail" a
INNER JOIN "sbx_fraud_frac"."infomart_summary" b on a.interaction_id = b.interaction_id
WHERE a.start_date >=current_date -1 and (a.cust_num is not null)
and exit_reason not in ('CORE ACTIVATION', 'MARCELLUS ACTIVATION', 'TPB WFA PREMIER ACTIVATION', 'TPB_ACTIVATION', 'cc_lost');

); disconnect from aster;
quit;
endrsubmit;




New Contributor
Posts: 3

Re: Connection String Issue

Hi,

 

I googled and found something that said rsubmit and endrsubmit where for sas connection which i don't think i have.  when i removed the rsubmit and endrsubmit the query ran.

 

Thanks!

Super User
Posts: 3,861

Re: Connection String Issue

Posted in reply to paul_schulten

Correct. An RSUBMIT block is only required if you wish to connect to another SAS server from the one you are running on. The RSUBMIT should be preceded by a SIGNON statement to establish a session on the second SAS server - hence the error you were getting.

PROC Star
Posts: 1,218

Re: Connection String Issue

Posted in reply to paul_schulten

What does your connection string look like?

 

And post your entire log, makes it much easier to help you Smiley Happy

Ask a Question
Discussion stats
  • 5 replies
  • 183 views
  • 2 likes
  • 3 in conversation