SAS Enterprise Guide freezes after stored process run

[HRprasad]

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

[Kurt_Bremser]

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?

[HRprasad]

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.

[Kurt_Bremser]

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.

[ChrisHemedinger]

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).