Sunday, September 23, 2012

OBIEE 11.1.1.6.4 patching issue

Hi ,

Today I tried to apply the patch-set OBIEE 11.1.1.6.4 on my oracle  Linux 64 bit. When I was applying patch number 14405222. It was giving me weired  message

Running prerequisite checks...
Prerequisite check "CheckApplicable" failed.
The details are:

Patch 14405222:
Copy Action: Source File "/u01/app/oracle/obiee11g/Oracle_BI1/14405222/files/bifoundation/server/bin/jobmanager/plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.0.101.R34x_v20080731/launcher.win32.win32.x86_64.properties" does not exists or is not readable
'oracle.bi.bifndn, 11.1.1.6.0': Cannot copy file from 'launcher.win32.win32.x86_64.properties' to '/u01/app/oracle/obiee11g/Oracle_BI1/bifoundation/server/bin/jobmanager/plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.0.101.R34x_v20080731/launcher.win32.win32.x86_64.properties'

[ Error during Prerequisite for apply Phase]. Detail: OPatch failed during prerequisite checks:
Prerequisite check "CheckApplicable" failed.
System is intact, OPatch will not restore the system

Recommended actions : This patch requires some components to be installed in the home. Either the Oracle Home doesn't have the components or this patch is not suitable for this Oracle Home.



its is not able to copy a file (or) cannot read from patch given by oracle.

After that I tried to navigate to the  Source File below to see what's happening.

 "/u01/app/oracle/obiee11g/Oracle_BI1/14405222/files/bifoundation/server/bin/jobmanager/plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.0.101.R34x_v20080731

the file extension was just .properti insted of properties.

No Respite for OBIEE Developers.


Solution : just change the extension of the file from .properti to to properties.


Thanks
Venkat

Saturday, September 22, 2012

The Oracle Business Intelligence 11.1.1.6.4 Patchset is Available Now!!

Hi Floks ,

Oracle has relased a OBIEE 11.1.1.6.4 patchset.


Bugs fixed by each of the patches in the Oracle Business Intelligence 11.1.1.6.4 patchset are described in the Readme file for each patch.

Bugs fixed in this patch (1 of 7) are shown in the following list:

13560245:BIDOMAIN/CONFIG/JDBC NOT FOUND.

13504454:BLK - BIINSTANCE COPYCONFIG FAILURE ESSBASE MAXL LOGIN IS FAILING

13510938:NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD

13628293:EMPTY PROCUREMENT DASHBOARD IN RC4

13565722:BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL

13589944:BI T2P - PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR

13619973:INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN

13683204:STRESS:FA:CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED

13724975:RUP2 AIX HCM STARTERDB POSTCONFIGURE FAILED

13779029:BI T2P BI RPD PLUGIN OPERATION ERROR WHILE LOADING SHARED LIBRARIES LIBARICU23

13687239:RUP2_RC4 BI DOMAIN - BI ANALYTICS DATASOURCE TEST FAILS

13780076:USE BIPROV PROPERTIES FROM 13694505

13404296:BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS

13485655:T2P ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG

13896014:RPDTRIM INCORRECT PROPERTY BIPROV.BI-HOME.DIR IN BI-CONTENT.XML FILE

13896152:TRIMRPD NOT ABLE TO CREATE BIPROJECTS.TXT BASED ON FAOFFERING LIST BAD XPATH ERR

13896209:TRIMRPD RELATIVE BI ORACLE HOME LOCATION PASSED TO SCRIPTS DURING RPDTRIM

13898786:TRIMRPD PLEASE MASK THE RPD PASSWORD WHICH IS LOGGED DURING _TRIMRPDTARGET EXEC

13910554:MISSING CONNECTION PROPERTIES IN OBIEE RPD

13926479:TRIMRPD FOR WINDOWS THE PROPS FILE SHOULD INCLUDE FORWARD SLASH IN DIR PATHS


14538078
Patch 11.1.1.6.4 (1 of 7) Oracle Business Intelligence Installer
14538128
Patch 11.1.1.6.4 (2 of 7) Oracle Real Time Decisions
14285344
Patch 11.1.1.6.4 (3 of 7) Oracle Business Intelligence Publisher
14538164
Patch 11.1.1.6.4 (4 of 7) Oracle Business Intelligence ADF Components
14415773
Patch 11.1.1.6.4 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x
14405222
Patch 11.1.1.6.4 (6 of 7) Oracle Business Intelligence
14409674
Patch 11.1.1.6.4 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer


Thanks
Venkat 

Wednesday, September 5, 2012

OBIEE 10G to 11G (11.1.1.6) upgrade issue

Hi Folks,

Recently I upgraded OBIEE 10g Reports and dashboards to OBIEE 11.1.1.6 . After upgrading I was facing  two weird problem.

1)  When I click on catalog button on the menu whole screen is becoming blue as shown below.



 If you see the left down corner of the IE. It says done with some errors. when you double click  on that one and the error is shown  as below.

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Win64; x64; Trident/4.0; .NET CLR 2.0.50727; SLCC2; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E; InfoPath.3; Tablet PC 2.0)
Timestamp: Mon, 27 Aug 2012 16:26:59 UTC



Message: 'saw.componentheader' is null or not an object
Line: 1
Char: 17211
Code: 0
URI: http://bbcxxxyyy:9704/analytics/res/b_mozilla/catalog/catalogview.js.


If I open the OBIEE browser in Firefox (or) Chrome Everything was perfect.  In my organization they use IE only. So I need to fix this issue in IE.

 2) When I click on different tabs on the dashboard pages. I was not able to navigate. What ever tab I click I was returning to the same first tab.

Solution for both the problems : 

Clear the IE Browser Cache

Doesn't work : if you go to tools > internet options and  browsing history > delete.

Some how this is not doing the trick


Works :  Open IE > Press F12 >  Go to the cache menu > click on delete browser cache.

Now everything opens Normal.

Thanks
Venkat Rachuri.