nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

User_WGGLW

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

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

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 Acha

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

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>

<DSN>AnalyticsWeb</DSN>

Mark correct if this helps..

Sagar

User_WGGLW

Hi Sagar

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

Thanks and Regards

Priti

User_WGGLW

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.

<CheckUrlFreshness>false</CheckUrlFreshness>

</Security>

Thanks and Regards

Priti

Joel Acha

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.