Using VB Script to close EG not working on Win2019 Server

cmyers1 — Mon, 01 Feb 2021 21:39:25 GMT

We have a simple VB script for error checking/reporting that will also close the EG session with this block:

printLog("Initiating exit sequence")
If not (app Is Nothing) Then
printLog("Attempting to shutdown EG")
app.Quit
Set app = Nothing
End If

This has worked flawlessly to close out the EG session and not have any remnant temp files being stored in the user directory on our Win2012R2 server, however on our new AWS EC2, it works intermittently. At times it will close the EG session properly, other times it just hangs after the app.Quit command.

Log entries when everything is working shows this:

021-02-01 11:35:24,386 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - Calling IWorkspace.Close
2021-02-01 11:35:24,544 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - IWorkspace.Close completed
2021-02-01 11:35:24,544 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - Calling ObjectKeeper.RemoveObject
2021-02-01 11:35:24,547 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - ObjectKeeper.RemoveObject completed
2021-02-01 11:35:24,547 [1] DEBUG SAS.EC.Directory.Model.Server [(null)] - Enter Dispose(true) for server named: SASApp
2021-02-01 11:35:24,548 [1] DEBUG SAS.EC.Execution.ExecutionService [(null)] - Disposing.

Log Entries when it does not work show this with the application hanging on ObjectKeeper.RemoveObject:

2021-02-01 11:45:28,383 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - Calling IWorkspace.Close
2021-02-01 11:45:28,509 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - IWorkspace.Close completed
2021-02-01 11:45:28,509 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - Calling ObjectKeeper.RemoveObject

After some time left untouched we see this:

2021-02-01 12:21:15,894 [2] DEBUG SAS.BI.SASComb.Method [(null)] - Deleting CBObject 0xc0.
2021-02-01 12:21:15,894 [2] DEBUG SAS.BI.SASComb.Method [(null)] - SAS has disconnected; not sending final release.
2021-02-01 12:21:15,894 [2] DEBUG SAS.BI.SASComb.Method [(null)] - Deleting CBObject 0xbf.
2021-02-01 12:21:15,894 [2] DEBUG SAS.BI.SASComb.Method [(null)] - SAS has disconnected; not sending final release.
2021-02-01 12:21:15,896 [2] DEBUG SAS.BI.SASComb.Method [(null)] - Deleting CBObject 0xbc.
2021-02-01 12:21:15,896 [2] DEBUG SAS.BI.SASComb.Method [(null)] - SAS has disconnected; not sending final release.
2021-02-01 12:21:15,896 [2] DEBUG SAS.BI.SASComb.Method [(null)] - Deleting CBObject 0xbb.
2021-02-01 12:21:15,896 [2] DEBUG SAS.BI.SASComb.Method [(null)] - SAS has disconnected; not sending final release.

Trying to determine why when we are running app.Quit it hangs on

2021-02-01 11:45:28,509 [1] INFO SAS.EC.Directory.Model.SASWorkspace [(null)] - Calling ObjectKeeper.RemoveObject

Has anyone had experience with these hanging issues in the past? Thank you

Re: Using VB Script to close EG not working on Win2019 Server

ChrisHemedinger — Tue, 02 Feb 2021 12:18:21 GMT

I don't know why it's hanging there. From the log, it's cleaning up the connection to the SAS session (Workspace) -- unsubscribing from events, closing data connections, etc.

topic Using VB Script to close EG not working on Win2019 Server in SAS Enterprise Guide

Using VB Script to close EG not working on Win2019 Server

Re: Using VB Script to close EG not working on Win2019 Server