How to Modify the OBIEE Error Message

November 1, 2017

Author: Cameron Ross, Performance Architects

The Oracle Business Intelligence Enterprise Edition (OBIEE) error message can be a very daunting alert for an end user to receive. This message can be edited in order to change the display.

The standard Oracle error message contains three content objects: 1. The title; 2. The subtitle; and 3. Error details.  The steps below outline how to change this message:

  1. Create a new folder called “Custom Messages” inside the Oracle BI Presentation Service (OBIPS) folder in the following path of your OBIEE install. The reason for doing this is because when upgrades or patches are done to the install, the xml files will be reset in the initial file path:
  2. A user has the ability to change the title of the error message. In order to change the title of the error, find the “viewmessages.xml” file in your OBIEE install directory:

/OBIEE_Home/Middleware/bi/bifoundation/web/msgdb/l_en/messages/

The first part of the error message can be customized by editing the “viewmessages.xml” file. Search for “kmsgEVCViewDisplayErrorTitle” in the xml file. This is the location of the error message that will display. Change the “View Display Error” to the text of your choice.

Save the “viewmessages.xml” file in the custom messages folder that was created earlier.

  1. Just like with the title, a user can alter the subtitle. The one downfall of editing subtitles is that it will make it harder for the administrator to fix the issue since this is diagnosing the error source. To edit the “ODBC Subtitle,” go to the same folder that the “viewmessages.xml” file was located in above. This time find the “odbcaccessmessages.xml” file. Edit this file and search for “kmsgOdbcAccessOdbcException”. Replace the text “ODBC driver returned an error” message and replace it with the text of your choice.

Save the “odbcaccessmessages.xml” file in the custom messages folder that was created earlier.

  1. An OBIEE administrator can alter the privileges that other end users have. One thing that the administrator can change is the ability to see the SQL in the error details of an OBIEE message. Login to OBIEE as an administrator. Go to the top right corner of the OBIEE home screen and click the “Administration” tab:

On the “Administration” page, select “Manage Privileges.” In “Manage Privileges,” scroll down to the “Admin: General” section and find the “See SQL issued in errors” and alter this message so that only administrators have the rights to see the SQL for the error.

By setting this to “Administrators Only”, this cleans up the appearance of the error details when end users run into an error message.


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Leave a Reply