SAS code runs manually but "hangs" when run Automatically

apeksha — Sun, 04 Sep 2016 08:50:00 GMT

Hi,

I have a batch process which consist of some 5-6 sas codes, this runs everyday via a windows scheduler (the vesrion is SAS EG 9.4).

The codes have been running automatically at 09:30 am in the morning everyday for the past 6 months.

Since last Friday, i have run into a weird issue. The first code in the process (it reads an XML) gets hung at one place in the code (the run time of the code is ~8 mins). This place is where dataset X is formed by a right join of dataset Y and Z in a proc sql. Dataset X is 1.2 GB in size. The code always hangs here and this has started happening only since last Friday. Before that there was never such issues.

As the process delays, i kill the scheduler, and run the code manually at the same time and it runs just fine. I have been trying to replicate the issue, at some times of the day the code take 17 mins to run and some times 8 mins (via scheduler). But when run manually it always runs ~8 mins.

There was NO change/modification made to the code before the problem started happening. There was though a vulnerability fix done to the SAS web server (apache) from my client side.We also tried changing the network location of the datasets to F drive, we are still facing the same issue.

Any ideas why this would be happening? and how to fix this issue?

Thanks,

Apeksha Pathak

Re: SAS code runs manually but "hangs" when run Automatically

TomKari — Mon, 05 Sep 2016 12:03:49 GMT

Are X, Y, and Z all SAS datasets?

Re: SAS code runs manually but "hangs" when run Automatically

ballardw — Tue, 06 Sep 2016 15:59:30 GMT

If this coincides with a software update, such as you mention about Apache, I would investigate any permissions you use. Possibly the "fix" defaulted to a traffic limit setting, read/write permission change or similar.

Your scheduler may have slightly different permissions set.

And when you say "run manually" do you mean in EG or Base SAS?

topic SAS code runs manually but "hangs" when run Automatically in SAS Enterprise Guide

SAS code runs manually but "hangs" when run Automatically

Re: SAS code runs manually but "hangs" when run Automatically

Re: SAS code runs manually but "hangs" when run Automatically