SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Hello, Can you please suggest possible reason to get the following error while executing below query. 

 

%GLOBAL conn_table;
%logon_macro(SSKC, JX123456, {SAS002}2XXXX04E3xxxxxxx2C19BCE799);

rsubmit;

options db2ssid=DVC0 ;

proc sql;

  create table LAND_KD as select *

  from connection to db2(

      select distinct substr(KODE_WD,1,2) as CUSTOMER_COUNTRY_CODE

            ,substr(EN_OMS_TK,1,35) as CUSTOMER_COUNTRY_DESC

      from qera.Cabcdf

      where kode_nm = 'ISO-LAND-KD'

  );

  disconnect from db2;

  quit;

 

proc download data= LAND_KD; run;

endrsubmit;

 

ERROR:

NOTE: Remote submit to SSKC commencing.

ERROR: Conversation termination; status=1.

ERROR: A link must be established by executing the SIGNON command before you can communicate with SSKC.

1 ACCEPTED SOLUTION

Accepted Solutions
SASKiwi
PROC Star

Do you have other DB2 queries that work OK and this is the only one getting this error? If so what is the maximum elapsed time of the queries that work?

View solution in original post

7 REPLIES 7
kumarsandip975
Pyrite | Level 9
@Kurt_Bremser , Ideally this macro definition is %logon_macro correct, there is no issue with macro. That is being called in backend.
SASKiwi
PROC Star

This looks suspiciously like a timeout issue on the SAS/CONNECT network connection to me. How long does it run for before the error occurs? Where is the error happening - on the query or the DOWNLOAD? If it is on the DOWNLOAD, try reducing the size of the dataset by say 50% to see if that works.

proc download data = MyData (obs = nnnnnnn); * Change the obs = number to 50% of total obs;
run;
kumarsandip975
Pyrite | Level 9
@SASKiwi It is happening on Query, not on download. I have verified removing download line, but same error.
Kurt_Bremser
Super User

@kumarsandip975 wrote:
@SASKiwi It is happening on Query, not on download. I have verified removing download line, but same error.

Then it is possible that the inactivity of the link while the query is running causes a drop of the connection on one of the routers/firewalls. Have your network people take a look at the connection path.

SASKiwi
PROC Star

Do you have other DB2 queries that work OK and this is the only one getting this error? If so what is the maximum elapsed time of the queries that work?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 1636 views
  • 0 likes
  • 4 in conversation