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 problem.so 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. data-model-cmd.sh, start.sh, stop.sh, status.sh):
[home]/user_projects/domains/bi/bitools/bin

TNSNAMES file (to configure Oracle db connections):
[home]/user_projects/domains/bi/config/fmwconfig/bienv/core/tnsnames.ora

Weblogic scripting tool (wlst.sh)
[home]/oracle_common/common/bin

Log files (for BI system and weblogic servers):
[home]/user_projects/domains/bi/servers

BI Catalog:
[home]/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/catalog

Live RPD:
[home]/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations

NOTE: You need to use data-model-cmd.sh to download the live RPD

Weblogic configuration:
[home]/user_projects/domains/bi/config

FMW Configuration:
[home]/user_projects/domains/bi/config/fmwconfig

BI System configuration (instanceconfg.xml, NQSConfig.xml etc):
[home]/user_projects/domains/bi/config/fmwconfig/biconfig

Examples:

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

BI Publisher Configuration:
[home]/user_projects/domains/bi/bidata/components/bipublisher/repository/Admin/Configuration/xmlp-server-config.xml

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


java weblogic.security.utils.AdminAccount USER_NAME  PASSWORD .


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  setWLSEnv.sh(cmd) 


Error: Could not find or load main class weblogic.security.utils.AdminAccount

\Bi11g_driver\wlserver_10.3\server\bin>setWLSEnv.cmd

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”
http://servername:9704/analytics/saw.dll?bieehome

To go directly to “Dashboard”
http://servername:9704/analytics/saw.dll?Dashboard

To go directly to “Manage Privileges”
http://servername:9704/analytics/saw.dll?PrivilegeAdmin

To go directly to “Manage Catalog Groups”
http://servername:9704/analytics/saw.dll?ManageGroups

To go directly to “Manage Sessions”
http://servername:9704/analytics/saw.dll?Sessions

To go directly to “Manage Agent Sessions”
http://servername:9704/analytics/saw.dll?ManageIBotSessions

To go directly to “Issue SQL”
http://servername:9704/analytics/saw.dll?IssueRawSQL&Done=%2fanalytics%2fsaw.dll%3fAdmin

To go directly to “Manage Map Data”
http://servername:9704/analytics/saw.dll?ManageMapData

To go directly to “Manage BI Publisher”
http://servername:9704/analytics/saw.dll?bipublisherEntry&Done=%2fanalytics%2fsaw.dll%3fAdmin&Action=admin