Wednesday 1 February 2012

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


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

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.

2 comments:

  1. Hi I also have a question...when I tried it deploy a rpd in em 11.1.6 ,the server restarted and asked my login credentials , when I give the credentials it says invalid user id /password . I restarted the services and tried logging in again ,but it says authentication failure ....but I'm still able to log into em,console but not analytics

    I am stuck with this

    ReplyDelete
  2. hello i got same issue but particular to one folder. is that because of upgradation or i need to check anything in my code.

    ReplyDelete