If you're still running the Providex version, those are still valid

Can you tell me what those files do? 

I do not find SY_Workstation on my 2022 Sage 100 

The sessions.pvk file is 15MB file, so not big compared to others like 1.8GB audit files.  

When you say if you are still running Providex, does that insinuate you would say to get off Providex and get on SQL? 

Thank you for sharing any insight you can, 

Chris

These are old notes which I maintained for Sage 2014, but I believe the records in the sessions table. is a reflection of what is listed in the Sage 2014 providex application configuration utility "Sessions" tab.

On occasion we would have a network issue that left open sessions. These sessions could not be ended using master console so I would log off all the users on our Terminal Server, then I could then stop the application server.

Then I would delete the sessions.pvk file in "\MAS90\Home\Lib\_appserv" folder. The sessions would be cleared, and the table would be created again after the first user logged into Sage.

The sy_workstation table is in the \mas90\sy folder. I haven't seen the file in Sage 2023, so I thought it might be in a different

location on Sage 2023.

I did a weekly offsite backup where I removed all the users, shut down the providex db server and did a backup with no

users connected. Then I zipped the backup and copied into our offsite cloud server.

So far Sage 2023 has been operating very nicely. Our current environment is Server 2019 and Sage 2023 in a Remote Desktop Services platform.

We have three RDS session servers with approx 20-30 users on each session server.

Not going to the SQL version.

.

We typically only do this when there are issues with something related to connectivity, but I don't see any harm in doing it as part of routine maintenance.

https://us-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=224924650066909