Check integrity error

[Former Member]

Hi All,

I'm getting the error as in snapshot after check integtity, Tested all joins, All are parsing, help needed.

[Former Member]

Click on the parse failed error and it will jump to the join with the problem.

If you can't see which join it is, it may be a self-restricting join (also known as a stub join). If so, move your table to the other side of the table that it joins normally to and you should see it show up. Double click on the self-join and resolve the parsing error.

[Former Member]

Hi Mark,

All the self joins are parsing. very mysterious.

[Former Member]

So you can't find the join that is throwing the exception?

[Former Member]

yes

[Former Member]

Yes you can or yes you can't?

[Former Member]

I can't.

[Former Member]

OK, so you've no idea which join is in error?

[Former Member]

Have deleted all the tables, but still says in summary(parameters) 1 join. surprised from where it is comign.

[Former Member]

Sounds like a bug, I really can't think what it could be

[former_member4998]

Hi

have you specified cardinality for all the joins and checked all the context and loop’s