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.

Customizing your DOS prompt

Posted by on December 6, 2012 at 4:30 am

Being back on a windows shop I find the DOS prompt sort of gets in my way, I have customized it so that it will display my current path and then let met type on a new line with this command: PROMPT Ignacio’s rocking at $P$G$_ The different formatting options for the command are: $A […]

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 […]

Verifying the pre-requisites for an Oracle Database Install on SUSE Linux

Posted by on August 10, 2012 at 5:30 am

This is a list of the parameters and configuration settings you should first check when installing the oracle database into a personal/sandbox environments, I made a note of them to allow me to verify them quickly without going through all the documentation for every install. This assumes you will not use ASM on your new […]

Oracle Database 11g R2 Minimum Requirements (windows)

Posted by on July 10, 2012 at 4:30 am

Database Version: gRelease 2 (11.2)for Microsoft Windows (32-Bit) Hardware Requirements Requirement Minimum Value Physical memory (RAM) GB minimum Virtual memory Double the amount of RAM Disk space Total: 5.35 GB SeeTable 2for details. Processor Type Intel (x86), AMD64, and Intel EM64T Video adapter 56 colors Screen Resolution 024 X 768 minimum Space Requirements Installation Type […]

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 […]

Configuring a new loopback adapter in windows

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

Start > Control Pannel> Add  Hardware Click next on the Welcome screen  When ask if you have connected your hardware, specify yes  In the next dialog select Add new hardware device  On the following screen select Network Adapters  Select Microsoft > Microsoft Loopback Adapter from the list  Select next in the following screen to install […]

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: Cannot manage OHS configuration from Fusion Middleware Control / Enterprise Manager (Error:Failed to invoke operation load on MBean)

Posted by on April 19, 2012 at 2:53 am

The following error is displayed when you attempt to follow any of the administration links

Failed to invoke operation load on MBean,name=ohs1,instance=instance1,Location=AdminServer

Parsing error while loading MBeans at oracle.sysman.emas.sdk.model.jmx.JMXUtil.invokeOperation( at or

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 […]

How to launch OBIEE Catalog Manager in 11g

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

In secondary cluster node systems and versions before a shortcut to the OBIEE Catalog Manager was not created by the install utility, when running on a Windows Box you can easily solve this by running the runcat.cmd file on the Catalog Manager Path: <Middleware Home>\instances\instance<Instance Number>\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager An example of the this path on a […]

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:

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…

Issue: WordPress sticky posts always on top instead of being incorporated in the default descending date sort for blog home

Posted by on January 19, 2012 at 6:30 am

I am using WordPress 3.1, I was able to solve this issue by customizing the call to the query_posts() function in my theme’s home.php file. The only customization necessary was adding the ignore_sticky_posts variable at the end of the query string as illustrated below. Current code in my theme: query_posts($category."&paged=$paged&showposts=$number_posts"); Tweaked code: query_posts($category."&paged=$paged&showposts=$number_posts&ignore_sticky_posts=1");

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 […]

List of Bug Fixes Included In Oracle BI Publisher

Posted by on October 31, 2011 at 4:14 pm

List of Bug Fixes Included In Oracle BI Publisher following is a list of all bug fixes included in Oracle BI Publisher, grouped by type: Administration (ADMIN) * Bug 9381019 XMLP ROLES NOT HONORED WITH SSO ENABLED FOR AD SYNCHED USERS. * Bug 9934771 UNABLE TO LOGON TO PUBLISHER USING SECURITY MODEL EBS: […]

Fixing device references after importing a Linux guest in Oracle Virtual Box

Posted by on June 9, 2011 at 2:00 pm

After reading this post you should be better prepared to smoothly export and import Linux virtual machines from your Oracle Virtual Box servers by being ready to correct any disk device reference issues in fstab and grub.conf