Latest News

Thursday, January 30, 2014

OBIEE 10g to 11g Upgradation Errors & Resolutions

Some of the very common Errors post 11g up-gradation are as below 

1) After successfully migrating the 10g repository and catalog to 11g most of the reports are working fine, except for some reports which are shooting the following error:

Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of C:\ADE\aime_bi\bifndn\analytics_web\main/project/webreport/exprformulautils.cpp

Resolution : 
Apply Patch 12561330, Follow below steps for applying the patch

Download opatch setup from here,


*Make sure you only use, do not use 11.2.x version

1. Unzip the patch zip file into the PATCH_TOP.

unzip -d PATCH_TOP

2. Set your current directory to the directory where the patch is located.

cd PATCH_TOP/12561330

3. Run OPatch to apply the patch.

Run following command:
- opatch apply -jre $ORACLE_HOME/jdk/jre

  • Google+
  • Pinterest

1 comment

  1. On step 3 i got the following error: 'opatch' is not recognized as internal or external command, operable program or batch file.
    Please advise