Tuesday, November 27, 2012

Installing BI Composer using Script in OBIEE 11.1.1.6.6

Hi Friends,

My Environment : 64 bit Linux

Today I upgraded  my OBIEE to latest version OBIEE 11.1.1.6.6.

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

as shown in the below Documentation

http://docs.oracle.com/cd/E23943_01/bi.1111/e10539/c5_postinstall.htm#CHDDDIJA

1)  Open a shell prompt and  go to the directory 


/u01/app/oracle/OBIEE11g/wlserver_10.3/common/bin


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 



./wlst.sh ORACLE_HOME/bicomposer/install/configureComposer.py DOMAIN_HOME 
<administration_server_home> <Port_Number> <Admin_User_Name>

./wlst.sh mw_home/BI1/bicomposer/install/configureComposer.py mw_home/user_projects/bifoundation mycomputer 7001 jdoe 


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


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

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

/u01/app/oracle/OBIEE11g/Oracle_BI1/bicomposer/install/configureComposer.py 

3)DOMAIN_HOME : This is your Domain_HOME location

 actuall path should be  as below

/u01/app/oracle/OBIEE11g/user_projects/domains/bifoundation_domain 

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


http://localhost:9704/analytics/saw.dll?bieehome&startPage=1

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 : 

 ./wlst.sh  /u01/app/oracle/OBIEE11g/Oracle_BI1/bicomposer/install/configureComposer.py   /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.



Thanks
Venkat





 

OBIEE 11.1.1.6.6 Patch --Applied successful

Hi  Friends,


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

No issues so far.......






Patch details are as below :



Thanks
Venkat

Tuesday, November 20, 2012

How to install BI composer OBIEE 11.1.1.6.4 (or) Above

Hi Friends,

Please refer the foloowing blog for Installing.

http://paulcannon-bi.blogspot.com/

Thanks
Venkat

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.....


Thanks
Venkat











Saturday, November 3, 2012

USAGE Tracking in OBIEE 11.1.1.6.4 (or) Above

Hi Friends,

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

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

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html

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 11.1.1.5 RPD and made the tweaks necessary so that  the S_NQ_ACCT meets the new table structure.

http://total-bi.com/2011/09/obiee-11g-usage-tracking-rpd/.

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

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 11.1.1.6We 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")
 at OCI call OCIStmtExecute: INSERT INTO S_NQ_ACCT (USER_NAME, REPOSITORY_NAME, SUBJECT_AREA_NAME, NODE_ID, START_TS, START_DT, START_HOUR_MIN, END_TS, END_DT, END_HOUR_MIN, QUERY_TEXT, QUERY_BLOB, QUERY_KEY, SUCCESS_FLG, ROW_COUNT, TOTAL_TIME_SEC, COMPILE_TIME_SEC, NUM_DB_QUERY, CUM_DB_TIME_SEC, CUM_NUM_DB_ROW, CACHE_IND_FLG, QUERY_SRC_CD, SAW_SRC_PATH, SAW_DASHBOARD, SAW_DASHBOARD_PG, PRESENTATION_NAME, IMPERSONATOR_USER_NAME, NUM_CACHE_INSERTED, NUM_CACHE_HITS)  VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29).

  
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 11.1.1.6.0 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 >
BIDOMAIN.BIINSTANCE.ServerConfiguration

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.

http://www.oraclenerd.com/2011/09/obiee-11g-usage-tracking.html


Thanks
Venkat