Sunday 29 April 2018

OBIEE Variables overview

Below screen shot shows the overview of OBIEE variables.

OBIEE Start services Error -- Server state changed to FORCE_SHUTTING_DOWN

This summary is not available. Please click here to view the post.

OBIEE 11g Error: 500 Internal Server Error

If you are getting the error following error 

Error 500--Internal Server Error 
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

FMW_SECURITY_SERVICES_URL in NQSConfig.ini has wrong IP. checking log file its noticed that this parameter has invalid IP which caused the after updating with correct IP address its got working fine so this is permanent solution.

Below screen short shows the FMW_SECURITY_SERVICES_URL in NQSConfig.ini file.

Try to update your static IP address like below screen,

Then try to re - start your bi services then Error: 500 Internal Server Error won't come again.

Monday 12 March 2018

File Locations for Oracle BI 12c

BI Tools (e.g.,,,

TNSNAMES file (to configure Oracle db connections):

Weblogic scripting tool (

Log files (for BI system and weblogic servers):

BI Catalog:

Live RPD:

NOTE: You need to use to download the live RPD

Weblogic configuration:

FMW Configuration:

BI System configuration (instanceconfg.xml, NQSConfig.xml etc):


Presentation Services configuration: .../biconfig/OBIPS/instanceconfig.xml
BI Server configuration: .../biconfig/OBIS/NQSConfig.INI

BI Publisher Configuration:

Tuesday 19 January 2016

weblogic admin account creation : OBIEE 11g

When you lost the weblogic account or security files are corrupted then create a new admin account (web logic) using following commands as shown below


don't forgot to give ( . )  at the end with space after the password

If you get below error while creating admin account set the path using 

Error: Could not find or load main class


Editing a report on Criteria tab instead of Results tab in OBIEE

By default when you click on Edit report, your OBIEE Answers opens it on the Results tab. Apply the account settings to navigate directly to the Criteria tab when editing.

  • Go to top right corner of the screen and click on My Account:


  •       In Preferences tab change Analysis Editor setting to Start on Criteria tab when editing Analysis and click OK.

Tuesday 26 November 2013

Direct Links to various OBIEE User and Administration Presentation functions

These are some direct links to various OBIEE User and Administration functions.  These can be useful to know for efficiency and at times can also be useful for debugging security.

To go directly to “Home Page”

To go directly to “Dashboard”

To go directly to “Manage Privileges”

To go directly to “Manage Catalog Groups”

To go directly to “Manage Sessions”

To go directly to “Manage Agent Sessions”

To go directly to “Issue SQL”

To go directly to “Manage Map Data”

To go directly to “Manage BI Publisher”