How to stop / start individual OBIEE 11g System Components from the OPMN

Posted by on May 23, 2013 at 2:30 am

Sometimes I have a configuration change to make or need to restart a specific system component in one of my servers, here is a list of stop / start commands for each of the system components…

Issue with invalid or corrupted repository joins

Posted by on April 12, 2013 at 3:20 am

Symptom: The following error message is displayed: [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46043] Internal error: No matching table for expr D_OPER_UNIT_XL.OPER_UNIT_SID, File .\Src\SQOSPSimplifyJoin.cpp, line 118. Cause: This symptom is associated with corrupted physical layer join relationships. The best way to test for a root cause is to isolate the […]

Configuring OBIEE to run as a Windows Service

Posted by on February 24, 2013 at 3:30 am

One key step to configuring an enterprise deployment of Oracle Business Intelligence is to be setup your services to run in the background as Windows services and start automatically with your server. By default the installer will create windows services for Oracle Process Manager (OPMN) and the Weblogic Node Manager, this leaves us with the need to configure services for the Weblogic AdminServer and the BI Managed Server.

Configuring the windows host file to correctly use the loopback adapter for Oracle product installations

Posted by on November 11, 2012 at 1:30 am

This procedure is required when installing Oracle products such at the Oracle Database or Oracle Business Intelligence Enterprise Edition on a host machine that uses DHCP.  Follow the steps to configure a loopback adapterand then: Open the host file under c:\windows\system32\drivers\etc using notepad Identify your computer’s host name by right clicking on My Computer, selecting […]

Error message when incorrect version of Oracle Database Client has been installed

Posted by on June 14, 2012 at 3:30 am

Symptom: The following error message is displayed when trying to issue any queries to an Oracle database: [nQSError: 10058] A general error has occurred. wrong ELF class: ELFCLASS64 [nQSError: 46029] Failed to load the DLL /usr/oracle/OracleBI/server/Bin/ Check if ‘Oracle OCI 10G’ database client is installed. Causes: This error message is typical of a situation […]

Error: [nQSError: 23026] The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID column.

Posted by on May 10, 2012 at 3:30 am

Description This error message is associated with the “Descriptor ID” feature introduced with OBIEE 11g. This feature is aimed at transparently replacing descriptor fields (ie. Department Name) with their equivalent ID fields (ie. Department ID) on the WHERE clause of SQL statements issued by the BI server. This is achieved by selecting a “Descriptor ID” […]

Issue with [nQSError: 10040] The requested data source name is either not found, incomplete, or incorrect. (IM002)

Posted by on March 29, 2012 at 3:30 am

Problem: The OBIEE 11g presentation service fails to start. Symptoms: Error Code: “IM002. Code: 10040. [NQODBC] [SQL_STATE: IM002] [nQSError: 10040]The requested data source name is either not found, incomplete, or incorrect. (IM002)”   Cause: The DSN tag value on the instanceconfig.xml file is incorrect or a valid data source is missing.   Solution: Verify that […]

Oracle Support asking for flash version

Posted by on February 29, 2012 at 6:01 pm

Oracle support now requires you to enter the flash version you are using when filing a new Service Request in relation to a Char issue, to find out your flash player version go to the adobe website below:

Oracle Business Intelligence is Generally Available!

Posted by on February 23, 2012 at 5:29 pm

Features include prompt autocomplete, optional apply button, favorites, full text search, and enhancements to: Mapview, Selections, Views, Scorecard and Strategy Managemnet….

Workaround: OBIEE compatibility issue with Firefox 10

Posted by on February 6, 2012 at 2:00 am

This work around is related to my previous post on OBIEE error: “Your browser is not supported by Oracle BI Presentation Services”

OBIEE error: “Your browser is not supported by Oracle BI Presentation Services” being triggered by automatic update to Firefox 10

Posted by on February 2, 2012 at 11:41 am

OBIEE is not compatible with Firefox 10 which is being rolled out to user desktop computers through automatic updates…

List of Bug Fixes Included In OBIEE

Posted by on January 5, 2012 at 9:36 am

The following is the list of Bugs fixed in OBIEE Release grouped by component : Admin Tool * 7538753 SAP BW IMPORT DOES NOT RETRIEVE UNIQUE NAME FOR MEASURE COLUMNS * 10012297 ADMIN TOOL CRASH ON VERY LARGE EXPRESSIONS – OVERFLOW AT APPROX 3200 CHARACTERS * 10032385 TABLE MISSING IN SQL "FROM" CLAUSE – […]

11g Bug: Issue with equality operator on content filters

Posted by on November 21, 2011 at 12:02 pm

I ran into an weird issue yesterday trying to troubleshoot data security for my current gig. What it came down to is the fact that for some reason the equality operator in the expression below wasn’t being resolved correctly by OBI: LOWER( TRIM(“Data Warehouse”.””.”SCHEMA_NAME”.”ALS_BI_SEC_USER_DEPT”.”EMAIL_ADDRESS”)) = ( LOWER( TRIM( VALUEOF(NQ_SESSION.”USER”)))) Even after toying with :USER, applying […]

Default Web Catalog Path in OBIEE 11g

Posted by on June 2, 2011 at 2:01 pm

This post should guide users new to Oracle Business Intelligence Enterprise Edition version 11g familiarize themselves with changes in directory structure and to be able to locate the OBIEE 11g web catalog directory…

Installing the Oracle Business Intelligence 11g ( Client Tools

Posted by on May 30, 2011 at 8:00 am

Overview This is a brief installation guide for those currently working on their OBIEE installation. Please post commnents if you have any questions or run into issues installing OBIEE 11g, we will try to fix them and can document their resolution for future reference. Pre-requisites Download the installer from OTN to your windows machine […]

Configuring WebLogic Automated Startup Credentials

Posted by on May 26, 2011 at 2:00 pm

After reading this post you should be able to configure the file to provide the WebLogic server with startup credentials, a necessary step when configuring the server for automated startup …The WebLogic server does not start automatically, it is prompting for a user name and password    WebLogic not reading file

Commentary: Oracle releases OBIEE

Posted by on May 10, 2011 at 7:10 pm

Oracle releases native SAP BW BAPI adapter and iPad/iPhone support in release of OBIEE

Linux Environment variables to simplify your life – OBIEE 11g System Administrator Edition

Posted by on April 19, 2011 at 7:18 pm

As I spend a lot of time switching between a very well defined set of directories in the Oracle Middleware home for OBIEE 11g I have been developing a list of variables that I like to use in my scripts and configure in the servers that I most commonly work with. They have proven to […]

OBIEE Repository Reporting

Posted by on December 25, 2010 at 6:00 pm

Extracting lists of OBI repository objects

OBIEE Logical Table vs Logical Table Sources – Best Practice

Posted by on December 15, 2010 at 6:00 pm

The difference between Logical Tables, Logical Table Sources (LTS) and the physical tables that compose a Logical Table Source, here are some basic guidelines that have helped me get this concept to seat more clearly in my mind.