topic Re: User is receiving error running code from his computer,but works on another computer on same net in SAS Programming

User is receiving error running code from his computer,but works on another computer on same network

bhofmannHJF — Mon, 20 Sep 2021 18:50:17 GMT

A SAS user on our network receives the below error when trying to run a code, however if a colleague runs the same code on their computer (on the same network), it completes successfully.

ERROR: Windows error code: 59 in hc_disk_normal_read for
G:\IDCRP\GID\TIDOS\Deliverables\2019\TIDOS_DoDTR_EX01_19Nov2019\pid_injury_profile.sas7bdat,
An unexpected network error occurred.
ERROR: File DODTR.PID_INJURY_PROFILE.DATA is damaged. I/O processing did not complete.
ERROR: PROC SQL runtime error for operation=sqxsrc.
ERROR: An error has occurred.

I confirmed in SAS explorer that the G:\ location can be reached, and that the table is not empty. Since it is working for another user on the same network, it does not appear to be a firewall/latency issue. Just wondering where else I should be looking to resolve this. Let me know if I should provide any additional information, thank you!

Re: User is receiving error running code from his computer,but works on another computer on same net

ChrisHemedinger — Wed, 22 Sep 2021 17:48:31 GMT

This error often indicates a device driver issue or a network problem. If it works for one user but not another -- on the same network (meaning on premise, no VPN), then it might be a device driver or network adapter issue.

I know that as many of us are working from home, access to network drives can be spotty and sometimes fail.

Adding a critical piece from the original poster that might help others looking for a solution:

Updating that, as many of you alluded, this is in fact a networking issue. We utilize Zscaler for a cloud/on-prem Firewall/VPN, and it seems that is what is causing this error.

Re: User is receiving error running code from his computer,but works on another computer on same net

Reeza — Mon, 20 Sep 2021 21:45:57 GMT

Probably something to work through with SAS Tech support as well, not something we can likely help diagnose remotely.

Usually these come down to some sort of access issue.
What happens for other locations?
What about other files? In different locations? In same location?
Can the user create a file in that location?

Re: User is receiving error running code from his computer,but works on another computer on same net

Sajid01 — Mon, 20 Sep 2021 23:02:00 GMT

Prima facie it is a network error,
Close all applications on the users PC and then reboot.

If it does not work, take up it support.

Re: User is receiving error running code from his computer,but works on another computer on same net

bhofmannHJF — Tue, 21 Sep 2021 14:11:42 GMT

Thank you all for the quick response.

The computer was restarted last night, but unfortunately the issue remained. I have opened a ticket with SAS Support, and will update when/if a fix is found.

Re: User is receiving error running code from his computer,but works on another computer on same net

Sajid01 — Tue, 21 Sep 2021 16:20:05 GMT

There is another suggestion.
If the user is using IWA in the EG profile please change it to user name / password
and restart EG session

Re: User is receiving error running code from his computer,but works on another computer on same net

bhofmannHJF — Wed, 22 Sep 2021 17:10:29 GMT

Updating that, as many of you alluded, this is in fact a networking issue. We utilize Zscaler for a cloud/on-prem Firewall/VPN, and it seems that is what is causing this error.

It wasn't until we actually tried to copy one of the files in question to the user's computer and it failed with a network error, that we realized we were looking at the wrong piece of the puzzle. Thank you everyone for the prompt feedback!

Re: User is receiving error running code from his computer,but works on another computer on same net

Sajid01 — Wed, 22 Sep 2021 19:04:04 GMT

Thanks for sharing your experience.