- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?