topic SAS server 'Viya' taking longer to respond in SAS Programming

SAS server 'Viya' taking longer to respond

ketan_korde — Sat, 14 Dec 2024 12:49:14 GMT

Hello everyone,
I am performing a left join in SAS EG using PROC SQL and it is giving me a following message after some time:
"A request to server 'Viya' has taken longer to respond than the 60 minutes threshold.....Wait for connection or Disconnect"

After increasing the wating time by again 60 minutes same message is shown.

It would be very helpful if anyone have solution for this.

Thank you.

Re: SAS server 'Viya' taking longer to respond

Kurt_Bremser — Sat, 14 Dec 2024 23:03:13 GMT

Please post the complete (all code and messages) log of the PROC SQL step by copy/pasting it into a window opened with this button:

Re: SAS server 'Viya' taking longer to respond

SASKiwi — Sat, 14 Dec 2024 23:05:03 GMT

What does your SAS log show? That your PROC SQL query never completes or something else? My guess is that the query never completes and that EG is prompting you if you want to continue running it or not.

What type of solution do you want? For the message not to pop up every 60 minutes, which I suspect might be an EG setting, or for your query to run faster so it completes in less than 60 minutes avoiding the message?

Re: SAS server 'Viya' taking longer to respond

ketan_korde — Sun, 15 Dec 2024 04:38:46 GMT

Yes, it never completes and SAS log doesn't show anything only the message of 60 minutes

Re: SAS server 'Viya' taking longer to respond

SASKiwi — Sun, 15 Dec 2024 06:56:08 GMT

Please post your program in that case.

Re: SAS server 'Viya' taking longer to respond

ketan_korde — Tue, 17 Dec 2024 10:57:59 GMT

proc sql;

create table Want as
select a.*,b.*
from Lib1.Have1 a
left join Lib2.Have2 b
on trim(upcase (a.ID))=trim(upcase(b.ID)) and trim (upcase (a.MemberNo))=trim(upcase(b.MemberNo))
AND a.Date_Received between b.'Start Date'n and b. 'End Date'n
AND a.Date_Received between b.policy_startdate and b.policy_ enddate
AND a.Date_Received between b.policy_start_date and b.policy_end_date;

QUIT;

Left Data contains 90,00,32 and Right Data 8,10,74,788

Re: SAS server 'Viya' taking longer to respond

ketan_korde — Tue, 17 Dec 2024 11:00:58 GMT

Hi, in my case log is not generated only the message that I mentioned pops up and the code is:

proc sql;

create table Want as
select a.*,b.*
from Lib1.Have1 a
left join Lib2.Have2 b
on trim(upcase (a.ID))=trim(upcase(b.ID)) and trim (upcase (a.MemberNo))=trim(upcase(b.MemberNo))
AND a.Date_Received between b.'Start Date'n and b. 'End Date'n
AND a.Date_Received between b.policy_startdate and b.policy_ enddate
AND a.Date_Received between b.policy_start_date and b.policy_end_date;

QUIT;

Left Data contains 90,00,32 and Right Data 8,10,74,788

Re: SAS server 'Viya' taking longer to respond

SASKiwi — Tue, 17 Dec 2024 18:57:56 GMT

Do LIB1 and LIB2 point to external databases by any chance? If so it is possible that SAS can't push the functions you are using and so is reading all data to SAS first before joining. What happens if you remove the TRIM and UPCASE functions?