topic Re: SAS Enterprise Guide freezes after stored process run in SAS Enterprise Guide

SAS Enterprise Guide freezes after stored process run

HRprasad — Thu, 23 Jun 2016 04:04:52 GMT

Hi All,

Regarding SAS EG freezing issue in SAS 9.4 M3. We are running stored process in EG. Once Stored proces complete, Output window show as ""LOADING" and EG screen freezes. After that we are not able to do anything in EG. We need to close the EG and open again.

To resolve this issue, we just de-selected the "Automatically open data when added to project" in options. That resolve the freezing issue.

Please let me know if you have faced this issue and what solution you implemented other than above? or If there any other parmanent solution of this issue?

As per my opinion, this issue is occurring due to data volume. What is your view on this?

Thanks,

HR Prasad

Re: SAS Enterprise Guide freezes after stored process run

Kurt_Bremser — Thu, 23 Jun 2016 05:33:37 GMT

Your output might be so large that it

- takes a very long time to load

- causes a memory overflow in EG that you detect as "freeze".

What happens when you run your STP through the web interface?

Re: SAS Enterprise Guide freezes after stored process run

HRprasad — Thu, 23 Jun 2016 20:34:42 GMT

I generated the EG log and verified but did not find any specific error for memory issue.

We are using EG to run STP, did not tried on web interface.

Re: SAS Enterprise Guide freezes after stored process run

Kurt_Bremser — Fri, 24 Jun 2016 05:26:04 GMT

Have you taken a look at the STP server logs?

Apart from that, I can only repeat: run the STP from the web (or another) interface so you can isolate EG as the culprit if nothing bad happens there.

At least you can take a look at the STP output this way.

Re: SAS Enterprise Guide freezes after stored process run

ChrisHemedinger — Fri, 24 Jun 2016 14:46:08 GMT

What type of data are you creating? Some sequential data types, such as accessed via the XML or XLSX libname engines, can cause a hang in EG (though this has been fixed in the most recent EG 7.12 hotfix).