Outer joins are incoherent (qp0005)

building reports desktopintelligence
1

Hi Friends,

I run my Business Objects reports on a weekly basis on 6.5 environment. All was running fine but from some days some of my reports throwing en error message which is “Outer joins are incoherent (QP0005)” and does not run. I am not able to understand this error message, because if there was any issue with report query then previously it should not work. Aslo same report is running fine on b.1b environment.

I understand this is problem related to configuration, Please help me to resolve this.

Thanks
Nitin

nitinkg :india: (BOB member since 2005-03-09)

2

are you sure there was no change in the universe under the report?
try deleting - reimporting the universe to eliminate universe corruption problems…
if still got the problem - check and compare the generated sql-s from both of your environments… can be a difference of sql generating settings in the two environments.

PeterC :hungary: (BOB member since 2005-02-14)

3

:smiley: i have got the same error before…its :yesnod: 1000000% SURE :yesnod: that without change in the universe it will not display…if there are no changes in the universe but still u get an error i am :nonod: 0.000000000% :nonod: NOT SURE why the error appears?

clickme (BOB member since 2005-07-06)

4

Please let me know -

  • What kind of changes made in universe can generate this error ?
  • How can we know that because of this change this error is occuring?
  • And what else can be done to resolve it. Apart from rollback those changes. If we require those changes either?

Thanks
Nitin

nitinkg :india: (BOB member since 2005-03-09)

5

I also have a similar problem. We started getting the error message when we upgraded to 6.5. BO tech support is “working on it” or not!

It looks like that for a few of our universes we do not have a few tables joined at all, these universes stopped working and give the above error message.

If anyone has seen this problem, let me know if there is a solution, and what caused it.,

BTW, we are using sybase 12.5.03

Thanks,
Gary

garye905 (BOB member since 2004-02-11)

6

From 6.5 version, the parsing has been made very strict. Maybe there might be some tables in the universe which are not joined to any other tables or in other words are free standing in the universe. Please check that.

Chinnu.

chinnu (BOB member since 2002-11-22)

7

Is this documented anywhere? Or did BO just decided to add this “Feature” and not mention it to anyone…

I know for a fact that we have a few free standing tables that are not joined.
Is there any configuration that you know of to turn this “strict parsing” off?

Thanks for your post…

-G

garye905 (BOB member since 2004-02-11)

8

Hi,

I just upgraded to 6.5 from 5.1 and one report on a universe is generating this error message. There are other reports which run no problem. There are no free standing tables. I am trying to get to the bottom of the problem. In the meantime I’m wondering did anyone with this problem figure out a solution. I did find something on Business Objects website which required chaning the odbc.rss file but it didn’t work.

Thanks for any suggestions.
Heather

heatherbs :ireland: (BOB member since 2005-05-17)

9

See topic

Regards,
Bert

bvirsel :netherlands: (BOB member since 2006-02-01)

10

I faced this issue in BO 4.1 Universe design tool and got this resolved by removing the joins cardinality (earlier it was may to many) and this removed the error message.

siddu0206 (BOB member since 2010-01-25)