OBIEE 12c (12.2.1.3) post upgrade challenges - unable to save HTML based dashboard reports

    Dec 11, 2017 4:18:00 AM by Syed Jaffar Hussain

    Very recently, an OBIEE v12.2.1.1 upgraded to v12.2.1.3 on an Exalytics machine. Though it wasn't a major upgrade, we had to do it to fix some bugs encountered in v12.2.1.1. For sure, it wasn't a easy walk in the park during the upgrade and post upgrade.

    I am here to discuss a particular issue we faced post upgrade. This should be interesting.

    Post upgrade to v12.2.1.3, we heard from the application team that all the reports working perfectly fine, except the dashboard reports with HTML tag unable to save. The below error was thrown when try to save the existing HTML reports:


    "You do not currently have sufficient privileges to save a report or dashboard page that contains HTML markup"

    It appeared to be a very generic error, and we tried all the workarounds we found on various websites and Oracle docs. Unfortunately, none of the solution fixed the issues. One of the popular advice is the following:

    you need to go and check the HTML markup privileges in Administration.

    1. Login with OBIEE Admin user,
    2. Go to Administration link - Manage Privileges,
    3. Search for "Save Content with HTML Markup" and see if it has necessary privileges. else assign the necessary roles and re-check the issue. 

    After giving an additional privilege we could save the existing HTML reports. However, still the issue exists when we create a new dashboard report, with HTML tag. This time the below error msg was appeared:

    While doing the research we also opened a SR with Oracle support. Luckily, (I mean it), the engineer who assigned this SR was good enough to catch the issue and provide the solution.

    The engineer tried to simulate the issue on his 12.2.1.3 environment and surprisingly he faced the similar problem. He then contacted the OBIEE development team and reaised the above concerns.

    A few hours later, he provided us the below workaround, which seems to be a generic solution to the first and second problem we faced. I believe this is a common issue on 12.2.1.3.

    Please follow below steps ::

    Take a backup of Instanceconfig.xml file, which is located in the following location, 

    <obiee_home>/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml 

    2. Add the following entry under security. 

    <Security> 

    <CheckUrlFreshness>false</CheckUrlFreshness> 
    <EnableSavingContentWithHTML>true</EnableSavingContentWithHTML> 

    </Security> 

    3. Restart the presentation services with command below :: 

    cd /refresh/home/oracle/12c/Oracle_Home/Oracle_Config/bi/bitools/bin
    ./stop.sh -i obips1 
    ./start.sh -i obips1 

    4. Now you will see the "Contains HTML MARK up" in the answers , check it and try to save the report now. 


    The solution perfectly worked and all HTML dashboard reports were able to save.

    If you are on OBIEE 12.2.1.3, I strongly recommend you to test the HTML reports, and if you encounter one similar to ours, apply the workaround.

     

     

    Tags: Oracle

    Syed Jaffar Hussain

    Written by Syed Jaffar Hussain

    An Oracle Database Expert for over 15 years from his 20 years of Information Technology (IT) career. Over the past 15 years of Oracle journey, he involved with several local and large scaled international banks where he implemented and managed highly complex cluster and non-cluster environments with over 100’s of business critical databases. Recognizing his efforts and contribution towards the Oracle community, Oracle awarded him the prestigious ‘Best DBA of the year, 2011’ and Oracle ACE Director status. He also acquired industry best Oracle credentials, Oracle Certified Master (OCM), Oracle RAC Expert, OCP DBA 8i,9i,10g & 11g in addition to ITIL Expertise. Syed is an active Oracle speaker, regularly presents technical sessions and webinars on various Oracle database technologies at many Oracle events. You can visit his technical blog, http://jaffardba.blogspot.com where he discuss and writes the workaround/solution about the issues confronted from his day-to-day activities. Apart from being the part of the core Technical Review committee member for a few Oracle technology oriented books, he also co-authored an Oracle 11g R1/R2 Real Application Cluster Essentials and Oracle Expert RAC books. His blog can be found at http://jaffardba.blogspot.com/