**
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___
