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: [email protected] 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 <http://www.arslist.org/> > Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
