Thanks for all of the answers... I did restart it with debug while waiting for the replies so I could see what it was doing. It is chugging along now and is at record 77,000 out of 566,000 so I just wasn't giving it enough time.
Ideally, I would love to see it delete all of the records that are no longer in the user form (about 300,000) so we'll see what happens. I may have to resort to one of the other options otherwise. It stands to reason all account actions and authentication would be faster without the additional overhead of searching an extra 300K records. Craig Carter ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davies, J.T. Sent: Friday, December 07, 2007 4:45 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache Are you running arreload with the debug switch? (-d, I believe)...this should show a constant stream of work being done. With that many records, it may indeed take a long while to complete. I'd imagine you could shut ARS down, truncate the user_cache table, and restart ARS...but in my opinion, the best way is simply letting arreload finish. J.T. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Friday, December 07, 2007 3:40 PM To: arslist@ARSLIST.ORG Subject: Q: Urgent - user_cache ** We're tying to upgrade from 6.3 to 7.0.1 and found we had about 200 duplicate login names in the user form. We modified them and now the cache is out of sync with the user form. I've been trying to run the arreload process but it runs for a long time and doesn't appear to be doing anything. The user_cache has over 500,000 records in it while the base user form currently has about 240,000 records. We did a mass delete of accounts a while back so I expect that is why. What is the fastest way to get the user_cache back in sync with the user and group forms? Is it possible to simply clear the table and then run the arreload command? Would like to finish these upgrades tomorrow but stuck trying to get this problem resolved. Any ideas/assistance would be appreciated since I didn't know this cache existed until about 2 hours ago... SQL Server 2000 ARS 6.3P12 Craig Carter __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
