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
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?
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?