Craig, I think this might work...
Export all the records from the User form to an arx file EXCEPT the Demo user account that you are working with (assumption) that has Administrative access. Delete all the records from user_cache EXCEPT the Administrative user account that you are working with (Demo as per my assumption)... Import the records that you exported back to the user form with the preference to 'Update all records with new records'. This will maintain the Entry ID / Request ID as it should.. This should create your new user_cache entries for every record that you import into the user form.. Warning: Performing this task on 240 K records may mean you will be doing this for a long long time.. Cheers Joe PS: If there is any filter on delete on the user form that deletes corresponding entries in forms like SHR:People or CTM:People (depending on what ITSM application version you are on if you are using any ITSM apps), disable them. Disable any filters on MERGE on the user form that may add records to forms like CTM:People or SHR:People.. If its a home grown application make sure whatever you have defined on the user form to create records on your home grown applications user base does not delete or add entries there during the process of deleting or importing... Nothing like doing it on a test system first if you have that luxury if you can duplicate this problem on your test system.. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Craig Carter Sent: Friday, December 07, 2007 6: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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.14/1172 - Release Date: 12/5/2007 8:41 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
