Hello,
I am using sas to connect wrds database. After I login, the code start to run. But several hours later, I encounter the following error:
ERROR: Conversations terminated; Status=1
ERROR: A link must be established by executing the Signon command before you can communicate with the remote host.
After that, all my previous results are lost, and I have to re-submit the code. But again, the connection is terminated several hours later.
It seems the system thought the connection is not active, thus shut down the connection.
Is there any step by step methods to make some settings to keep the connection active?
I searched the website, and find two possible solutions, one is to set the CPUTIMEMAX, and the other is to set the CONNECTKEEPALIVE. But I just can not figure out how to set this.
Great thanks for you all.
The CPUTIMEMAX option is part of a definition of a user on z/OS. Probably not relevant for you, unless Wharton uses a mainframe for their data, and it has to be set in the definition of your user account there.
If the problem is due to network inactivity, you may have luck with setting the CONNECTKEEPALIVE option in the server session. If the Wharton database has the relevant hotfix installed, that is (you may have to ask them). In that case you should be able to prevent the firewall software from closing the connection due to inactivity by setting this system option on the remote session, e.g.:
rsubmit;
-set CONNECTKEEPALIVE 5;
endrsubmit;
This should cause the remote session to send a signal every 5 seconds, so that the connection stays open. The SAS support page does not specify whether you should apply the hotfix to your client session, or to the server, or to both. You may have to ask SAS Institute.
Not sure if that works, but it probably won't hurt trying.
Thanks very much. I am trying it.
One more question, when I type in the code, the word "-set" in not shown in blue, and it is just the normal color, is it right? It seem the system does not recognize this option setting.
%let wrds=wrds.wharton.upenn.edu 4016;options comamid=TCP remote=WRDS;
signon username=_prompt_;
rsubmit;
-set CONNECTKEEPALIVE 15;
I suspect this would work in an OPTIONS statement as explained here: https://documentation.sas.com/?docsetId=hostwin&docsetTarget=p01905399zwlc4n115yaey6jt871.htm&docset...
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.