Tag Archive

How To: Download, install, configure and verify you have the latest version of Opatch

Published on June 9, 2013 By Ignacio de la Torre

On this post we will discuss all the steps necessary to ensure you have the correct version of the OPatch patching utility for oracle software running on your system.

Configuring OBIEE to run as a Windows Service

Published on February 24, 2013 By Ignacio de la Torre

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.

How To: Manage your Oracle patch deployment life cycle using Oracle Support Patch Plans

Published on December 8, 2012 By Ignacio de la Torre

As part of my writing I often try to document and share best practices I develop on my day to day work, this one relates to formalizing the patch deployment process for your oracle environments …

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

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

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

Published on March 15, 2012 By Ignacio de la Torre

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

11g Bug: Issue with equality operator on content filters

Published on November 21, 2011 By ignacio

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

Changing the value of a session variable at the session level

Published on November 12, 2011 By ignacio

I recently needed to update the value of a session variable beyond a prompt’s scope, I played a bit with the NQSSetSessionValue() ODBC function

Default Web Catalog Path in OBIEE 11g

Published on June 2, 2011 By Ignacio de la Torre

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…

Configuring WebLogic Automated Startup Credentials

Published on May 26, 2011 By ignacio

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

Commentary: Oracle releases OBIEE

Published on May 10, 2011 By Ignacio de la Torre

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

Published on April 19, 2011 By Ignacio de la Torre

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