If you have OBIEE10g and have plan to upgrade to OBIEE11g, then you come across the following message
Assertion failure: isXsiTypeSqlExpression(rExpr) at line 67 of /net/stasunnas09/export/ifarm_test/solaris64/views/ aime_bifndn_936652/bifndn/analytics_web/main/proje ct/webreport/exprformulautils.cpp
Error Details
Error Codes: ACIOA5LN
Error Details
Error Codes: ACIOA5LN
This is actually the OBIEE upgradation bug, to resolve this bug the oracle provided the” 12561330 - DRILL DOWN REPORTS WITH SQL FILTER ARE ERRORING OUT IN SYSTEM TEST ENV” patch
But this patch is only available for WINDOW (32 bit & 64 bit) and LINUX(x86 & x64).
To overcome this bug without patch: as we do not have any patch available for Solaris. Need to remove the save filter from the report and reapply it but not from previous location as we had in OBIEE10g
NOT: DO NOT CHANGE THE SAVE FILTER AS Apply contents of filter instead of a reference to the filter. IT WILL RESOLVE THE PARENT REPORT ISSUE BUT STILL THE REMAIN WITH DRILL DOWN REPORT.
