topic Re: WORK library contents lost during user session in Administration and Deployment

WORK library contents lost during user session

Dodecaphonic — Tue, 26 Oct 2021 21:04:16 GMT

On a 3-server 9.3 M2 BI Platform (AIX 64 bits), users report having their WORK library contents deleted in the middle of their EG session. Available space is not an issue, and the OS is running smoothly. Session is not otherwise interrupted (connexion to metadata server is maintained). Any idea what / where to look next? Things had been running normally for quite some time before that happened.

The only thing I can think of, in terms of changes on the server side, was the /tmp directory being emptied before a restart. That was done after several years of leaving /tmp alone, which resulted in amassing loads of obsolete files and folders. I don't think it's very likely to be related but it's as much relevant info as I can think of right now.

Thx in advance

Re: WORK library contents lost during user session

whymath — Wed, 27 Oct 2021 01:09:21 GMT

Check the SAS log and find if there a "proc datasets" or "drop table" operation.

Re: WORK library contents lost during user session

SASKiwi — Wed, 27 Oct 2021 01:27:56 GMT

Do you have any server firewall rules in play with time limits on ports? For example do sessions drop after a period of inactivity like one hour? Both Metadata and App server ports are relevant.