Wednesday, December 19, 2012

Connection Failed Error in OBIEE 11 g Admin tool -2

Hi Friends,

Recently I came across the following issue as shown in the figure below. I already posted a article on this same type of issue earlier in the blog.

There the issue was Tnsnames.ora file not present at C:\OBIHOME\Oracle_BI1\network\admin.

New Issue : - we have OBIEE installed in a remote server (Linux). My collegue installed  OBI client tool on her system. My collegue was having two older versions of  Oracle clients installed on her system and BI Admin tool was not able to figure out which one to use.

Error :

[nQSError: 17014] Could not connect to Oracle database. [[

[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified

at OCI call OCIServerAttach

Solution :  Create a system variable of the  tns file path


Right Click on My computer > Properties > Advanced system settings > Environement variables >

In the system variable create new called " TNS_ADMIN"

which is equal to your   C:\oracle\product\11.2.0\client_1\network\admin.

Click ok.

That should solve your problem.




Tuesday, November 27, 2012

Installing BI Composer using Script in OBIEE

Hi Friends,

My Environment : 64 bit Linux

Today I upgraded  my OBIEE to latest version OBIEE

In this post I will demonstrate how to install BI Composer using Script method

as shown in the below Documentation

1)  Open a shell prompt and  go to the directory 


Note : I  installed OBIEE at /u01/app/oracle/OBIEE11g. So Please choose the path as per your installation

2)   If you see the Oracle Documentation above it asks you to execute  the  command in the following  format 

./ ORACLE_HOME/bicomposer/install/ DOMAIN_HOME 
<administration_server_home> <Port_Number> <Admin_User_Name>

./ mw_home/BI1/bicomposer/install/ mw_home/user_projects/bifoundation mycomputer 7001 jdoe 

This command is actually  Six parts parts.......

1) ./ : If you navigate  to /u01/app/oracle/OBIEE11g/wlserver_10.3/common/bin  you will find script.

2)   mw_home/BI1/bicomposer/install/ : Here you have to give your complete script location like below


3)DOMAIN_HOME : This is your Domain_HOME location

 actuall path should be  as below


4)<administration_server_home> :  If your  OBIEE URL is like below


The name before 9704 is <administration_server_home>.

So here localhost  is  <administration_server_home>

5) <Port_Number> :  By default this is 7001

6) <Admin_User_Name> : This is also web logic

In a whole your command should look like below

Command : 

 ./  /u01/app/oracle/OBIEE11g/Oracle_BI1/bicomposer/install/   /u01/app/oracle/OBIEE11g/user_projects/domains/bifoundation_domain  localhost  7001 weblogic
Once you execute the script It will ask you to enter weblogic username/Password

3Start the Administration Server :

When you run the above script It will stop the Administrator Server as below

You have to start the script as shown below

4) Stop & Start  Managed WebLogic Server:

If your  Managed server is Already running  Press Ctrl + C

 5) Stop & Start OPMNCTL:

 6) Login to OBIEE > then go to > My Account  and select " Wizard (Limited Functionality)"

as shown below

7) Then go to New > Analysis > Subject Area . You will see the BI composer as shown below.



OBIEE Patch --Applied successful

Hi  Friends,

I just applied the OBIEE Patch to my  Linux -64 bit  OS and it was successful.

No issues so far.......

Patch details are as below :


Tuesday, November 20, 2012

How to install BI composer OBIEE (or) Above

Hi Friends,

Please refer the foloowing blog for Installing.


Monday, November 19, 2012

"Exception occured when saving user preferences to the catalog access denied for user to path /users//_prefs/userprefsxmlstore

Hi Friends,

I recently stumbled upon two issue

1) OBIEE 11g: Error: "Exception occured when saving user preferences to the catalog access denied for user to path /users/<username>/_prefs/userprefsxmlstore.

When one of my user is trying to setup Delivery preference as shown below.

2) When users login to OBIEE they are not able to see their "My Folders" etc.

I navigated to the "Catalog">Root>users>  and observed that upgrade assistance not able to copy the same user folder permissions from 10G to 11g(Bug)....

Solution 1:  Delete the user folders .... When users login again System will recreate the folder again.

 Drawback of this method is if user's have any reports  in their my folders in10G. They will get deleted.

Solution 2  :1) Using catalog Manager , Go to each user's folder,
                  2)Right click-Permissions: Full access to to the user and apply it recursively.
                  3) Right click-Properties, and set the Ownership to the user and apply it recursively.

All my two issues were resolved.

Happy upgrading and Happy holiday's Friends.....


Saturday, November 3, 2012

USAGE Tracking in OBIEE (or) Above

Hi Friends,

Recently I was trying to setup usage tracking in OBIEE as in OBIEE 10G.

If you wan to set up simple Usage Tracking follow this oracle learning library Article.

If you want to setup usage tracking as in 10G. Follow as below.

Steps 1: 

Paul has already took the 10G RPD and upgraded it to RPD and made the tweaks necessary so that  the S_NQ_ACCT meets the new table structure.

I just took the RPD  and used obieerpdmigrateutil.exe utility to upgrade it to

How to upgrade the RPD using obieerpdmigrateutil.exe :

1) I copied the paul's RPD in to  a folder in the c:\ called "up"

1) open your  OBIEE clients installation folder  and click on " BI Command Prompt"

using client tools you don't have to set environment variables  to use obieerpdupgradeutil.exe. When you click BI command Prompt , it will initiate the environment variables.

Syntax format for the obieerpdmigrateutil.exe  is as follows

After the bin > enter as follows

obieerpdmigrateutil - I C:\up\Usage Tracking.rpd  -O c:\up\11g.rpd -L c:\up\text.LDIF -U Administrator

Now we got the upgraded RPD. 

Important note : There is one new column "ID" added to usage tracking in obiee need to import the new column and add it to the  S_NQ_ACCT table. 

Otherwise you will get the following error : 

 [2012-11-03T13:02:58.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: fea5681cb2e6e3a0:-586c3f5d:13ab9179653:-8000-0000000000015bc2] [tid: 11599700]  [nQSError: 17011] SQL statement execution failed. [[
[nQSError: 17001] Oracle Error code: 1400, message: ORA-01400: cannot insert NULL into ("DEV1_BIPLATFORM"."S_NQ_ACCT"."ID")

step2:   I just took the 10G Catalog and used the upgrade assistant to upload the 10G usage tracking to 11g usage tracking catalog.

To save others time I just have the RPD and Catalog available for you to download from box which is compatiable with the OBIEE and above 

PASSWORD FOR RPD "Administrator"


Step 2:  You have to enable the usage tracking in the Enterprise manager.

1) Login to Enterprise Manager  

a) select coreapplication from Business Intelligence and click on " Lock and Edit"

b) Click on web logic > bi foundation> right click on  bifoundation and select  " System Mbean Browser>  Application Defined Mbean > oracle.biee.admin > Domain : bifoundation_domain >

as shown below.

In the Right side you will see the following fields.

 at 18 > Give your connection pool details
  at     20>  change  it to true
at     21 > give your S_NQ_ACCT  table  details.

Restart the services in the Enterprise Manager. That's it. usage Tracking is all set.

Step 3: After you merge the  Usage  tacking catalog with your 11G catalog  you will come across the following error  OBIEE 11g: Unresolved table: "**NONE**". (HY000) on each report.

Issue  : You have a saved filter called  "Subject Area not eqaul to /is not in usage tracking ". that filter is a faulty one

Just follow the thing as said in the blog below to fix the issue.