SQL Generation in Version 5.01

We have recently upgraded to Business Objects 5.01, running against an Oracle database. We have a report that has run successfully in 4.1.3, 4.1.5, and 5.0. Under 5.01, it gets an error message “ORA-01416: two tables cannot be outer-joined to each other :-1416”. When I cut the query and run it directly in SQL, it executes without a problem.

In the query, there is a table that is aliased and outer joined to itself. I am wondering if Business Objects is having a hard time handling this?

I would appreciate any insight you could offer!

Thank you -

Nancy M. Nearing
Federal Trade Commission
600 Pennsylvania Avenue, NW
Washington, DC 20580


Listserv Archives (BOB member since 2002-06-25)

I found that BO 5.01 / designer is different than 4.15 was… You may want to spot check your universe, look to see if it finds loops or other issues that were not noticed before…

Just a thought, we did spot some differences that affected queries

Brent

We have recently upgraded to Business Objects 5.01, running against an Oracle database. We have a report that has run successfully in 4.1.3, 4.1.5, and 5.0. Under 5.01, it gets an error message “ORA-01416: two tables cannot be outer-joined to each other :-1416”. When I cut the query and run it directly in SQL, it executes without a problem.

In the query, there is a table that is aliased and outer joined to itself. I am wondering if Business Objects is having a hard time handling this?


Listserv Archives (BOB member since 2002-06-25)

Brent -
Thanks for your suggestion. I did a detailed integrity check on the universe and everything is fine. The SQL generates using the proper aliases, and runs fine in SQL navigator, but generates an error in Business Objects and will not run.

Does anyone else have any ideas?

Nancy

“Douglas, Brent” bd150002@EXCHANGE.DAYTONOH.NCR.COM 03/23 12:40 PM >>>
I found that BO 5.01 / designer is different than 4.15 was… You may want to spot check your universe, look to see if it finds loops or other issues that were not noticed before…

Just a thought, we did spot some differences that affected queries

Brent

We have recently upgraded to Business Objects 5.01, running against an Oracle database. We have a report that has run successfully in 4.1.3, 4.1.5, and 5.0. Under 5.01, it gets an error message “ORA-01416: two tables cannot be outer-joined to each other :-1416”. When I cut the query and run it directly in SQL, it executes without a problem.

In the query, there is a table that is aliased and outer joined to itself. I am wondering if Business Objects is having a hard time handling this?


Listserv Archives (BOB member since 2002-06-25)