No more files error - from Gene De Guzman

[TheDBCommunity]

For some reason, Gene can't create a new topic, so I'm posting this for him.

-Liz

Gene:

I wanted to share that today we encountered a weird intermittent error “no more files” when running queries or interactively adding records. Some queries will not run and show a “no more files” error but when you run the same query the 2nd time there is no error. 

We are running windows 10 32bit clients on a windows server 2022 and pdox 9 and pdox 7 users. 

We just upgraded to windows server 2022 today from windows server 2016. 

Luckily, i was able to find the solution from the below 2 links. 

https://help.medilink.com.au/support/solutions/articles/11000104247-no-more-files

https://bsoft.zendesk.com/hc/en-us/articles/8948684412431-Intermittent-No-More-Files-error

Users with Windows 10/11/Server 2019/2022 and onwards may have experienced "No More Files" errors sporadically when trying to access the shared folder from workstations.

This is caused by a change in the way Microsoft accesses files over network shares on Windows 10 update 1803, resulting in unexpected errors.

On your windows server run the following command from Powershell:

Set-SmbShare -name "foldersharename" -LeasingMode none -Force

On LAN workstations try and add the following registry key:

HKLM\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters\

(All DWORD) 

DirectoryCacheLifetime=0

DisableBandwidthThrottling=1

FileInfoCacheEntriesMax=32768

DirectoryCacheEntriesMax=4096

FileNotFoundCacheEntriesMax=32768

MaxCmds=32768

I rebooted workstations but there was no need to reboot the server. 

I hope it helps other paradox users.