SAS PC connect, Conversations terminated

[daviddu]

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.

[s_lassen]

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.

[daviddu]

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;

[SASKiwi]

I suspect this would work in an OPTIONS statement as explained here: https://documentation.sas.com/?docsetId=hostwin&docsetTarget=p01905399zwlc4n115yaey6jt871.htm&docset...