Tracking down deleted recordsRick, Perhaps the record is not deleted - you have Assignee Group functionality turned on and the 112 field is set with groups other than the groups that the user that looks for that record is a member of..
So the record is probably still in your system, just not visible to a set of users because of row level security. Try searching for it directly at DB level and see if you can locate it. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Mueller, Doug Sent: Wednesday, August 25, 2010 6:29 PM To: arslist@ARSLIST.ORG Subject: Re: Tracking down deleted records ** Rick, One thing you can do to prevent anything from being deleted inappropriately... Put a filter on the form that runs on delete and returns an error. This will prevent any delete from occurring. Now, it will cause whatever process it is part of to fail which may give you the clue as to where it is coming from. Additionally, you can put a filter that runs at a lower execution order and end it with `! (backquote followed by exclamation point) to tell the filter to run "out of phase" because you want it to run regardless of error which is going to happen in the next filter that is at a higher order. This filter would send a notification to you that can include things like the time and USER NAME and CLIENT TYPE and other information to try and identify who and from what type of client and any other information like this is trying to delete so you can have that as further debugging information. So, this will protect your data and get you a starting point for isolating what is triggering the operation that is messing up your data. I hope this helps. Doug Mueller ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Westbrock Sent: Wednesday, August 25, 2010 10:35 AM To: arslist@ARSLIST.ORG Subject: Tracking down deleted records ** Hello all, long time no post for me. I have run into a new problem this week that I haven't seen in the eight years I've been developing Remedy here and I need some advice on how to track down the root cause. I have a regular form where suddenly we have seen two records just disappear. We disable deletion of records except for administrators and I checked all active links and filters for this form and nothing there would cause a deletion. I checked my log options for server events but there isn't anything there to log deletions. Is there an easy way to trap on a record delete and log it? The only thing I can think of off the top of my head is to add a filter that fires on record delete that will notify me but that will only help catch problems more quickly, it won't necessarily help me find the root cause. I've gotten a bit rusty at ARS since I transitioned into a network engineering role, hopefully all I need is a nudge in the right direction on this one. App Server: ARS 7.0.1 on Windows 2000 Server DB Server: MS-SQL 2000 on Windows 2000 Server Thanks in advance, Rick _________________________ Rick Westbrock, Network Engineer PETCO Animal Supplies, Inc. rick.westbr...@petco.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"