Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

We Recently move from obiee 11 g to obiee 12c(12.2.1.3).When ever we are trying to save a report is

Received Response
31
Views
7
Comments
User_WGGLW
User_WGGLW Rank 1 - Community Starter
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Right after the migration of all the reports from 11 g to 12 c we tried saving some reports in the dashboard .This is causing an issue mentioned below:

Cannot save report that contains HTML markup.

Error message : "Catalog object privilege validation failed for user to path ... . You do not currently have sufficient privileges to save a report or dashboard page that contains HTML markup.

I am stuck on this from quiet a long time.Mentioning what all I have already Tried so far,

1)In "Administration -> Manage Privileges" Answers > Save Content with HTML Markup

2)Took 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. Added the following entry under security. 

<Security> 

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

</Security>

But the presentation services is not starting after this change in the instance config file.

Thanks and Regards

Priti

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    2934375 wrote:But the presentation services is not starting after this change in the instance config file.

    And what does the log tell you? OBIPS doesn't stop starting without generating anything in the logs ...

  • User_WGGLW
    User_WGGLW Rank 1 - Community Starter

    I will attach the presentation server log.please suggest how to proceed,please clarify if my approach .

    The BI presentation services :

    [2018-08-20T05:20:03-04:00] [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: ] [tid: 6892] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW).

    State: HY000.  Code: 10058.  [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

    (HY000)

    State: HY000.  Code: 73025.  [nQSError: 73025] The Oracle BI Server is currently unavailable for queries. Please contact your System Administrator to report the failure. (HY000)[[

    Thanks and Regards

    Priti kumari

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you checked the XML syntax of your updated instanceconfig.xml file?Is it well-formed? As @Gianni Ceresa said, check your log files as well.

  • Sagar Tippe
    Sagar Tippe Rank 4 - Community Specialist

    Hi Priti,

    The cause of this issue was due to an incorrect value for the <DSN> parameter in the Instanceconfig.xml file (Presentation

    Service).

    Compared to the value in the Operating System's ODBC Administration setup for the Oracle BI Server Data Source.

    In the /DOMAIN_HOME/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml change the parameters.

    For example:

    <DSN>coreapplication_OH64097644</DSN>

    to

    <DSN>AnalyticsWeb</DSN>

    Mark correct if this helps..

    Sagar

  • User_WGGLW
    User_WGGLW Rank 1 - Community Starter

    Hi Sagar

    Thanks for your response I wil try this out asap and update your response  as correct.

    Thanks and Regards

    Priti

  • User_WGGLW
    User_WGGLW Rank 1 - Community Starter

    Hi

    I have mention the portion of  the instance config file where I Have made my changes the change is made in the security tag .Please have a look on the syntax and correct me if I have made some mistake.

    <Security>

    <CheckUrlFreshness>false</CheckUrlFreshness>

    <EnableSavingContentWithHTML>true</EnableSavingContentWithHTML>

    </Security>

    Thanks and Regards

    Priti

  • Joel
    Joel Rank 8 - Analytics Strategist

    quickest way to validate the XML is to open the instanceconfig.xml file in a web browser. If you can see the XML, then it's well formed.