Restart of the email engine uses the cache, restart of the server doesn't rebuild the cache...so you are likely correct that the cache was out of sync with the data...the fix for that is to do a arcache on the user table...this dumps the cache table and reloads it from the User form....how it got out of sync is anyone's guess...but it apparently happens enough for the arcache tool to have been written...
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, March 30, 2007 11:02 AM To: [email protected] Subject: User Cache Issue An unusual situation happened today that is now resolved, but I want to understand how it could occur. An employee's email address changed. The employee has a record in User with a Read-Restricted license. When an email (any email) was sent from Remedy the AR System Email Messages form would list their old email address. The old email address does not exist anywhere in the system. I restarted the Email Engine NT service and then ran arsignal with the -u switch to reload the user data. When that didn't fix it I restarted the Remedy NT service (surely, this had to work). When that didn't work I opened her record in User, removed the email address, saved, re-entered the email address, and saved. That fixed it. I'm thinking the user_cache table kept the old email address but I presume that it should have been reinitialized when arsginal was run or when the Remedy NT service was restarted. How could this situation occur? Thanks. ARS 6.3 p16 Windows Server 2003 SQL Server 2000 Stephen ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
