Select Page

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

Christian Screen | | June 28, 2009

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 occurred.

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

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Art of BI: BI Publisher (BIP) Quick Guide and Tips

Read our blog post on how to take over production support of BI Publisher reports.

Sherry Milad | January 15, 2018

Art of BI: How to Add Comments in Oracle BI (OBIEE)

Ultimately the goal of commentary in OBIEE is to have a system for persisting feedback, creating a call to action, and recognizing the prolific users.

Christian Screen | December 29, 2013

Art of BI: Uninstalling WebLogic Not Working on Windows OS

It isn’t often that one has to go about uninstalling WebLogic, the main application server for Oracle Fusion Middleware, when implementing Oracle BI or the EPM suite.

Christian Screen | September 10, 2013

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS