Tag Archive

Architecture CDC configuration database DataStage old EPM Error ETL Fusion Middleware HCM 9.0 HRMS 9.0 Informatica install installation Issue linkedin Linux Log Mining MDX modeling nQSError OAS OBIEE OBIEE 11g OBIEE new obiee_11g ODI Oracle ORCL OWE OWS PATH PeopleSoft processes Product Review Reference Repository solution SuSE sysadmin troubleshooting Unix variables WebLogic windows

Upgrading the Oracle Web Tier to version 11.1.1.5.0 by applying Patchset 1

Published on July 26, 2013 By Ignacio de la Torre
Share

This post will very briefly describe the steps required to upgrade Oracle Web Tier 11.1.1.2.0 to version 11.1.1.5.0. This is the recommended procedure to deploy Oracle Web Tier 11.1.1.5.0 per the Fusion Middleware Documentation.

Issue with invalid or corrupted repository joins

Published on April 12, 2013 By Ignacio de la Torre
Share

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

How to: Install the Oracle Web Tier / Oracle HTTP Server

Published on March 28, 2013 By Ignacio de la Torre
Share

This post will guide you through the steps to deploy Oracle Web Tier 11.1.1.2.0. This instance will later be upgraded to 11.1.1.5.0 by applying PatchSet 1 (12395155) and configured to serve as a front end for WebLogic as part of an Oracle Business Intelligence environment.

Configuring OBIEE to run as a Windows Service

Published on February 24, 2013 By Ignacio de la Torre
Share

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.

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

Published on June 14, 2012 By Ignacio de la Torre
Share

Symptom: The following error message is displayed when trying to issue any queries to an Oracle database: [nQSError: 10058] A general error has occurred. libclntsh.so.10.1: wrong ELF class: ELFCLASS64 [nQSError: 46029] Failed to load the DLL /usr/oracle/OracleBI/server/Bin/libnqsdbgatewayoci10g.so. 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.

Published on May 10, 2012 By Ignacio de la Torre
Share

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)

Published on March 29, 2012 By Ignacio de la Torre
Share

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 Business Intelligence 11.1.1.6.0 is Generally Available!

Published on February 23, 2012 By Ignacio de la Torre
Share

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

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

Published on February 2, 2012 By Ignacio de la Torre
Share

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

Default Web Catalog Path in OBIEE 11g

Published on June 2, 2011 By Ignacio de la Torre
Share

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 (11.1.1.5) Client Tools

Published on May 30, 2011 By Ignacio de la Torre
Share

Overview This is a brief installation guide for those currently working on their 11.1.1.5 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

Published on May 26, 2011 By ignacio
Share

After reading this post you should be able to configure the boot.properties 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 boot.properties file

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

Published on April 19, 2011 By Ignacio de la Torre
Share

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

Published on December 25, 2010 By Ignacio de la Torre
Share

Extracting lists of OBI repository objects

OBIEE Logical Table vs Logical Table Sources – Best Practice

Published on December 15, 2010 By Ignacio de la Torre
Share

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.

OBIEE 10g Administration – useful linux environment variables

Published on November 14, 2010 By ignacio
Share

Create some basic variables in your OBIEEE Linux server

OBIEE MUDE Repository Life Cycle

Published on July 4, 2010 By Ignacio de la Torre
Share

The attempt today was to illustrate in a very simple diagram the metadata development process in a OBIEE multi-user development environment (MUDE).

So I installed OBIEE, now what?

Published on January 10, 2010 By Ignacio de la Torre
Share

So I realized more than a week has gone since I finished installing OBIEE and while I’m going to the “Oracle BI Suite EE 10g R3: Build Repositories” class next week I still want to play around and get my questions started.