topic Re: problem with session in SAS Programming

problem with session

sateh — Tue, 01 Nov 2022 21:33:56 GMT

I have a code in SAS that performs several processes, and there is a process that generates a table with 19,985,984 records because it is required, then that table is taken to another process where sql is applied using some joins with another table, when the execution of my code reaches that part, the following messages appear in SAS STUDIO and I really don't know what it can be.

if I select the button "establecer" the whole section is restarted. and I select the button "cancelar" appear this:

Re: problem with session

SASKiwi — Tue, 01 Nov 2022 22:47:09 GMT

Looks like a timeout problem to me. How long does your program run for when this happens? Are you able to check your SAS log for additional information? If so can you post it please. Are you reading the data from an external database by any chance?

Re: problem with session

sateh — Tue, 01 Nov 2022 23:32:16 GMT

I have the timeout configured in the session as 36000, the code starts executing then after another process must be done with the large table that I mentioned but that is where these windows appear, I am not reading the data from a database data, the code executes and lasts about 5 minutes and that is where the windows appear, in the log it shows me this:

I don't get any kind of error or warning

Re: problem with session

SASKiwi — Wed, 02 Nov 2022 01:43:03 GMT

Hmm, 5 minutes isn't very long so maybe there is some other cause. I suggest you open a Tech Support track given this is a SAS Viya problem and likely will require diagnosing of server logs.

Re: problem with session

ahmedaldorr — Tue, 03 Dec 2024 11:51:31 GMT

Hello, I wonder if you had the chance to get this issue resolved, please

I have the same issue