Whoops MY BAD (not enough cafe yesterday I guess)... The queries for the Filter Actions, need to also have the following added to the end of each sql statement...
and filterId not in (select escalationId from escalation) so for example: select * from filter_notify where filterId not in (select filterId from filter) and filterId not in (select escalationId from escalation) This is because Escalations use 'filter actions'... sorry about any confusion... However Cleanup, yes, if you backup your database, then you can delete these rows, etc. On Documentation, Yes, have a look at the "Database-Ref-xxx.pdf" file... However since you know the filter name, you could do the forensics backwards (down) so to say. BTW - what version / patch are you on? On Feb 7, 2008 11:44 PM, CONDREA, Daniel <[EMAIL PROTECTED]> wrote: > ** Hi All, > > I had experienced the same problem. > > Suppose that the duplicate filter is named 'Filter A' and we have a def > backup for 'Filter A' > > I managed to get solve this problem by deleting 'Filter A' from the > 'filter' table and its mapping from 'filter_mapping' table. After I managed > to delete 'Filter A' using the Admin tool 'Filter A' was imported from DEF > file. > > Have a nice day, > Daniel > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Remedy Maniac > *Sent:* Friday, February 08, 2008 9:34 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: filter does not exist ... however it exist in the database > ... how come? > > ** right so I find some filterId in table filter which are not > referenced in the other tables. > I am able to recover those missing rows from a previous backup. > But I am missing one or two of these entries anyway. > So my question is very simple: can I simply delete those missing entries? > Or anyway: what to do with these ? > s. > > > Robert Molenda wrote: > > ** Generally this happens because "something got corrupted" in the > ARSystem Meta Data... > > When you tried to import the filter again, did you remember to check the > 'overwrite' checkbox? > > You can try the following SQL to 'try' to determine where the issue could > be: > > All statements should return Zero rows... > > /* Form deleted but filters still reference it */ > select * from filter_mapping where schemaId not in ( select schemaId from > arschema ) > /* Filter exists but is not mapped to any form */ > select * from filter where filterId not in ( select filterId from > filter_mapping) > /* Filter Mapping exists, but filter does not */ > select * from filter_mapping where filterId not in ( select filterId from > filter) > /* Fragments left in Filter action definitions, but filter does not exist > */ > select * from filter_notify where filterId not in (select filterId from > filter) > select * from filter_notify_ids where filterId not in (select filterId > from filter) > select * from filter_message where filterId not in (select filterId from > filter) > select * from filter_log where filterId not in (select filterId from > filter) > select * from filter_set where filterId not in (select filterId from > filter) > select * from filter_process where filterId not in (select filterId from > filter) > select * from filter_push where filterId not in (select filterId from > filter) > select * from filter_sql where filterId not in (select filterId from > filter) > select * from filter_gotoaction where filterId not in (select filterId > from filter) > > /* Never actually got around to this one but... thought about trying some > left-outer of left-outer, but... maybe someone else can struggle with that > :( */ > select distinct filterId from (above list of action tables) into excel > crunch up excel to find a filter without any definition in the action > tables > > HTH > > Robert Molenda > On Feb 7, 2008 6:14 AM, T. Dee <[EMAIL PROTECTED]> wrote: > > > I'm not a 100% sure, but I think this happened to us before and I > > think I found the field in question was not in any of the views, so i > > put it in a view and it resolved my problem. > > > > Hope this helps. > > > > T. > > > > > > On 2/7/08, Remedy Maniac <[EMAIL PROTECTED]> wrote: > > > dear listers, > > > > > > following my issues with export (see previous post), I noticed that > > > whenever I start the ARSystem, I see messages about "error in > > definition > > > for a filter". > > > When I look in the Admin tool I don't see the filter. But it exists in > > > the database in table Filter. > > > So first thing is what to do? > > > Second though is my database is somehow corrupted. Is there a way to > > > correctly rebuild the database? > > > We already tried to rebuild the indexes, all, including the primary > > > keys. That didn't help. > > > Maybe there is some internal mechanism via Remedy itself. > > > Any help on this? > > > Thank you. > > > S. > > > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
