Scheduled Job Still Running even though its deleted and not in Managed Jobs

Hello Everyone,   Scenario I got a request to add a user to a distribution list for a scheduled BI Publisher job which runs every day at 9:00 am. When I went looking for the job in Report Job section it wasn’t there. However when I went to Report History section I could see the jobs were running successfully. Reason After talking to Oracle it seems … Continue reading Scheduled Job Still Running even though its deleted and not in Managed Jobs

OBIEE 12 c is out …

Yes my friends , the much awaited OBIEE 12c is officially available for download. Download link is as follows http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-2717951.html The new features are listed below   Easy to upgrade:  BI 12c offers a radically simple and robust upgrade from 11g, saving customers time and effort in moving to the new version.  BI 12c includes a free utility to automate regression testing, the Baseline Validation … Continue reading OBIEE 12 c is out …

Informatica Navigator is not fixed.. How to set it as a part of the screen

Hello All, At times the Informatica Navigator screen does not stay fixed in the right hand section of the screen and it is annoying and we tried finding all the possibilities to get it back to how it was. It takes away a good amount of time to resolve this small glitch. Every body gets through it but then forgets what they did and hence … Continue reading Informatica Navigator is not fixed.. How to set it as a part of the screen

Configuring Scheduler in OBIEE 11g

Hello All, This post is the process of configuring scheduler in OBIEE 11g. This is a very simple process in 11g as compared to 10g where we had to do certain number of steps. Here all we have to do is enter the mail information in the Enterprise Manager. This is quickly how you can configure the scheduler in 11g 1. Login into you Enterprise … Continue reading Configuring Scheduler in OBIEE 11g

Upgrade Issues and Fixes from Informatica 8.1 to Informatica 9.1 on RedHat Linux – Solved

I had faced some upgrade issues and please find the issue and the resolution to the fixes.         1. Error occurred loading library libclntsh in informatica admin console             Reason: The Informatica Repository is finding for this particular library file which is                 present after the installation of Infomatica. This is present in Informatica … Continue reading Upgrade Issues and Fixes from Informatica 8.1 to Informatica 9.1 on RedHat Linux – Solved

Configuring and Upgrading Informatica 8.1 to 9.1

 Pre -Requisites There are mainly 2 steps 1.      Set the Environmental Variables   The Environmental Variables have to be set in the .profile mentioned below # Oracle and Informatica Settings ORACLE_SID=orcl_9.1; export ORACLE_SID ORACLE_BASE=/oracle; export ORACLE_BASE ORACLE_HOME=/oracle/11.2.0.3; export ORACLE_HOME INFA_HOME=/Informatica/Informatica_9.1; export INFA_HOME export ODBCHOME=$INFA_HOME/ODBC6.1 export ODBCINI=$ODBCHOME/odbc.ini PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH export TNS_ADMIN= LANG=C; export LANG export LC_ALL=C PATH=$PATH:/Informatica/Informatica_9.1/server/bin; export … Continue reading Configuring and Upgrading Informatica 8.1 to 9.1

Installation and Upgrading of Informatica 9.1 in RedHat Linux

Hi All, Its been a while since I have written an article. Well I was a bit busy and felt this task a bit accomplishing and wanted to post this article so that it would be helpful for a few others. Basically the main goal of this project is to upgrade from Informatica 8.1 to 9.1. Here the 9.1 is installed in a new machine … Continue reading Installation and Upgrading of Informatica 9.1 in RedHat Linux

Steps to refresh GUIDS and what to expect from the logs for successfull completion – Solved

What to expect in the logs to confirm GUID refresh has completed successfully. 1) Stop all obiee services (opmnctl stopall) 2) Edit presentation server instanceconfig.xml with the following – put it inside Catalog tag UpdateAndExit    3) Edit obiee server NQSconfig.INI file with the following FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES; 4) Start OBIEE services (opmnctl startall) 5) Wait until presentation services are listed as down (opmnctl status) … Continue reading Steps to refresh GUIDS and what to expect from the logs for successfull completion – Solved

Part 2 Adding Users to Application Roles in OBIEE

Steps to add users to Application Roles and to resolve issues if encountred 1. Once the LDAP is configured then the next task would be to add users to the Application Roles. This is to be done in em Traverse through the path  Business Intelligence–>coreapplication–>Security–>Application Roles 2. Then click on BI Administration Roles and edit. In that add the user from the LDAP  3. Once … Continue reading Part 2 Adding Users to Application Roles in OBIEE