session crashed since 0.17.3 on Windows

[Jiefei-Wang]

Hello, thanks for making this interesting project. I updated the server to 0.17.4 and observed a fatal error. The session crashes whenever I try to run any SAS code. There is no output on the web. I tried all the old versions and found out that the latest runnable one is 0.17.2, so something is not right since 0.17.3. Here is the error from 0.17.3. I hope this can be helpful to locate the issue. Please let me know if there is anything I need to post.

Startup message

sasLoc:  C:/Program Files/SASHome/SASFoundation/9.4/sas.exe
sasDrive:  C:\Users\jiewang\Documents\SAS\sasjs_root
sasLogs:  C:\Users\jiewang\Documents\SAS\sasjs_root\logs
runTimes:  [ 'sas' ]
Writing Logs to : C:\Users\jiewang\Documents\SAS\sasjs_root\logs\20220902160241.log
All CORS Requests are enabled for: []
Copying Macros from container to drive(tmp).
Macros Drive Path: C:\Users\jiewang\Documents\SAS\sasjs_root\sasjscore
App Stream Config loaded!
PROTOCOL:  http
⚡️[server]: Server is running at http://localhost:5000

Error when run SAS code

session crashed 20220902160247-93675-1662134567126 Error: Command failed: C:/Program Files/SASHome/SASFoundation/9.4/sas.exe -SYSIN C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\code.sas -LOG C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\log.log -PRINT C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\output.lst -WORK C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126 -AUTOEXEC C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\autoexec.sas -nosplash -icon -nodms -noterminal -nostatuswin -SASINITIALFOLDER -nologo

session crashed! while waiting to be ready Error: Command failed: C:/Program Files/SASHome/SASFoundation/9.4/sas.exe -SYSIN C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\code.sas -LOG C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\log.log -PRINT C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\output.lst -WORK C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126 -AUTOEXEC C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160247-93675-1662134567126\autoexec.sas -nosplash -icon -nodms -noterminal -nostatuswin -SASINITIALFOLDER -nologo

session crashed 20220902160248-98959-1662134568638 Error: Command failed: C:/Program Files/SASHome/SASFoundation/9.4/sas.exe -SYSIN C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\code.sas -LOG C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\log.log -PRINT C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\output.lst -WORK C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638 -AUTOEXEC C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\autoexec.sas -nosplash -icon -nodms -noterminal -nostatuswin -SASINITIALFOLDER -nologo

session crashed! while waiting to be ready Error: Command failed: C:/Program Files/SASHome/SASFoundation/9.4/sas.exe -SYSIN C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\code.sas -LOG C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\log.log -PRINT C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\output.lst -WORK C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638 -AUTOEXEC C:\Users\jiewang\Documents\SAS\sasjs_root\sessions\20220902160248-98959-1662134568638\autoexec.sas -nosplash -icon -nodms -noterminal -nostatuswin -SASINITIALFOLDER -nologo

[allanbowe]

Hi @Jiefei-Wang - thanks for raising! We don't have windows so was difficult to test this one, I believe I know where the issue is, looking into it now

[allanbowe]

@Jiefei-Wang - version 0.17.5 should be available in a minute or two, if you can confirm it's working fine I'll close the ticket

[sasjsbot]

🎉 This issue has been resolved in version 0.17.5 🎉

The release is available on:

• GitHub release
• v0.17.5

Your semantic-release bot 📦🚀

[Jiefei-Wang]

Hello @allanbowe, thanks for the quick response! The problem has been fixed!

I just start using SASjs so I have another simple question. If I print the table from the localhost web interface, I can see the printed table in text format from the log panel, there is no output like the regular SAS output. Is it normal? My ultimate goal is to use SASjs in Visual Studio Code. I have installed the SASjs extension, but VS code also gives me the text output. Is there any way to see the result in a pretty format? Thanks!

[allanbowe]

I did reply to this (by email) but seems it didn't get attached to the issue.

If you want this right now, I suggest writing your ODS output to the _WEBOUT fileref.

In the meantime we'll look at supporting the output destination as a first class citizen in SASjs Server. It is also requested here: sasjs/vscode-extension#336

[allanbowe]

@Jiefei-Wang - if you are just wanting to view tables in SAS, you can also try Data Controller. Just download the server.json.zip file from here: https://git.4gl.io/dc/deploy

And upload it to appStream.