about the only thing I can think of that would be uglier would be managing over 200K in user accounts...:)
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Friday, December 07, 2007 5:26 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache ** Thats good because that is what I usedI entered the command off of those pages. As long as I was doing it, I told it to do both user and group forms. Its doing the initial read at about 3,880 records a minute. Extrapolate that out and you get 147 minutes (2 ½ hours). I dont know how many passes it has to do but this could be ugly. Craig Carter _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davies, J.T. Sent: Friday, December 07, 2007 5:21 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache The -f switch does do a flush of the data. (7.0 Config book, page 355) J.T. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, December 07, 2007 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache ** Honestly I rarely had to use it either.. usually in my case it has always been a single record or a smaller number of records I had to mess with and have managed doing that at DB level without having to run arcache or arreload for altering anything in the user_cache. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of LJ LongWing (Head) Sent: Friday, December 07, 2007 7:07 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache ** if it doesn't do it by default, I'm pretty sure there is an option to wipe and start over....but as I said...it's been awhile since I've used it _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, December 07, 2007 4:55 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache ** LJ, Does it really truncate the user_cache table? I thought arreload only updates it as it expects it to be in sync so duplicate entries are not removed but out of sync entries are updated and missing user_cache entries are recreated... I may be wrong in believing this? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of LJ LongWing (Head) Sent: Friday, December 07, 2007 6:47 PM To: arslist@ARSLIST.ORG Subject: Re: Urgent - user_cache ** arreload is the way to go. it should dump the cache and reload from the user table. You should be able to watch record counts change in the cache, if not output to the screen....it's been awhile since I've needed to run it myself _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Craig Carter Sent: Friday, December 07, 2007 4:40 PM To: arslist@ARSLIST.ORG Subject: Q: Urgent - user_cache ** Were 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. Ive been trying to run the arreload process but it runs for a long time and doesnt 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 didnt 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___ __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"
