Art of BI: An error occurred while processing the EXECUTE PHYSICAL statement

Typically I haven’t bumped into this error in the past with OBIEE but the other day it smacked me in the face. 

error_on_view_data1

Problem
I was adding a SQL Server 2005 datamart to my Physical layer and didn’t run the initial check to see that OBIEE could read the data in my view/table objects. Clearly it was able to connect to the server and bring over the pertinent DB objects. However, when I right-click on a table or view object in the physical layer and select “View data…” I get the error prompt above.  The error reads something like ODBC error state: 37000, ODBC error state 50002, [NQODBC][SQL_STATE:HY000]….A general error has occured.

Solution
Figuring this problem out was not that difficult. The error prompt above is actually produced when the “Require fully qualified table names” checkbox is not checked.

To get rid of the error and to allow OBIEE to correctly read the data source in Answers, etc. follow the instructions below.

  1. Right-click “Connection Pool” for the database in question.
  2. Under the “General’ tab ensure that “Require fully qualified table names” checkbox is checked
  3. Click “OK” button and close the window.
  4. Right-click any table or view object you previously had a problem with and select “View data…”
  5. Enjoy
Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).