Yes I would correct it directly at DB level since its not a really critical error and only a data issue... since that date field is not a part of the user_cache, it doesn't matter if you correct it from the DB level as you do not have to modify the corresponding entry in the user_cache table to sync the information from the user schema to its cache..
Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mike Sent: Tuesday, December 18, 2007 11:09 PM To: arslist@ARSLIST.ORG Subject: ARS7.1 User Form, "Last Password change for policy" date "1/01/1970" invalid and read-only. Hi, newbie here, I have installed the 7.1 server on Win32 with MS-SQL and midtier. When I tried to make a change to the 'Demo' user in the User form of the admin console, I get an error: "Format of date or time value is not recognized. : Last Password Change For Policy (ARERR 9376)" The value is "1/01/1970", possibly an integer 0 or 1 in the database? While wrong, it hardly seems invalid. But I'm not allowed to make any changes to the request. I was able to create a new user, and that field was blank. But after I set a password for the new user (login and password link from home page), the user also has a "1/01/1970" value in that field, so the record cannot be edited. 1) Why is the date not being set correctly (to today)? or how would i try to find out? 2) Why is that date invalid? Maybe I'm not seeing the real bad value. Is it that string that is bad, or an ARS bug that shows that date for invalid values? (same problem in midtier and ARS_User.) 3) How do you generally deal with read-only invalid fields? Must I talk SQL direct to the database? regards, Mike No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.17.4/1189 - Release Date: 12/18/2007 9:40 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
