Abdullah, Why don't you just set all the records as as single update to null both in the t table in the password field and the user_cache table? That should clear whatever the problem is since you say that updating a record by blanking out the password helps..
Cheers Joe ----- Original Message ---- From: Abdullah Baytops <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, February 19, 2008 10:23:23 PM Subject: Migrating Users from People Form ** Hello Listers I am migrating users from our 6.3 to 7.1 and it seems to not be running as smoothly as I thought it would. The accounts are migrated into the 7.1 application but the password field seems to causing the problem when users try to acces the application. The users login password is actully NULL becuase we authenticate externally but when you try to login with the user account it fails. When I go to the user account and manually clear the password field and save the record it works. I can't possibly do this though for thousands of records. Can someone give me any insight on what they have done when migrating user accounts and password. Thanks in Advance Abdul Windows Server 2003 SQL Server 2005 Remedy ARS 7.1 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
