Curious if anyone has found that by setting the -ForeceRefresh, that the cmdlet never finishes, I let this run overnight and never finished, It only has around 27k files.
I run it nightly on all our data sources. It takes many hours (especially since I kick off 20 of them over the course of an hour) but it does complete.
I just checked my script's logs, I start my process at midnight and launch 5 datasources at a time every 30 minutes. Takes until 4am until the last one completes.
You're probably going to have to check with your db group to see what's hanging this up. the logging on it on the projectwise side isn't very granular.