My Oracle Support Banner

Exalytics OBIEE 12.2.1.2 -"Bad Xml Instance!" Error When Saving A Dashboard Customization After Using Action Link (Doc ID 2491011.1)

Last updated on SEPTEMBER 10, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Business Intelligence Answers Option - Version 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Oracle Exalytics Software - Version 2.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An error is generated while attempting to save a dashboard customization containing a report with an action link.

When saving a dashboard containing a report with an action link which navigates to the current dashboard to set a prompt, an XML-error is shown, and the customization cannot be saved.

Error Message:

<?xml version="1.0"?> <sawsel:dashboardSelections xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:sawsel="com.siebel.analytics.web/dashselections/v1" xmlns:sawst="com.siebel.analytics.web/state/v1" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="0.7"><sawst:envState xmlVersion="200811100"><sawst:container cid="d:dashboard" xsi:type="sawst:topLevelStateContainer"><sawst:container cid="f:dpstate" xsi:type="sawst:dashpromptstate" statepoolId="3i92qfdl93ttk4gmdj13ug49rq"/><sawst:container cid="p:plnvksgvujf9b9bb" xsi:type="sawst:page" firstVisit="true"><sawst:container cid="s:7ja1jrh475kd0hh9" xsi:type="sawst:section"><sawst:container cid="g:p81papaes9a8hkf1" xsi:type="sawst:dashprompt" links="-"/></sawst:container><sawst:container cid="r:qoq79c8jk3esm3ag" xsi:type="sawst:report" defaultView="compoundView!1" folder="/shared/Sareesh" itemName="A"><sawst:container cid="v:compoundView!1" xsi:type="sawst:view"><sawst:container cid="v:tableView!1" xsi:type="sawst:view" clientViewportRowStart="0" clientViewportRowEnd="10" clientViewportColStart="0" clientViewportColEnd="1"/></sawst:container></sawst:container><sawst:container cid="s:kb2ovqqsm2kpcsu0" xsi:type="sawst:section"/></sawst:container></sawst:container></sawst:envState><sawsel:xmlStatesReferredTo><sawsel:ref refId="3i92qfdl93ttk4gmdj13ug49rq"><sawsel:appliedStates><sawsel:filter><sawx:expr xsi:type="sawx:logical" op="and"><sawx:expr xsi:type="sawx:comparison" op="equal" promptPrimarySubjectArea="&quot;A - Sample Sales&quot;" appliedFromNavigationSource="navigationSourceExternal"><sawx:expr xsi:type="sawx:columnExpression" formulaUse="display" displayUse="display"><saw:columnFormula formulaUse="display"><sawx:expr xsi:type="sawx:sqlExpression">&quot;Time&quot;.&quot;T05 Per Name Year&quot;</sawx:expr></saw:columnFormula></sawx:expr><sawx:expr xsi:type="sawx:untypedLiteral">2013</sawx:expr></sawx:expr><sawx:expr xsi:type="sawx:comparison" op="equal" promptPrimarySubjectArea="&quot;A - Sample Sales&quot;" appliedFromNavigationSource="navigationSourceExternal"><sawx:expr xsi:type="sawx:sqlExpression">&quot;Customers&quot;.&quot;C1 Customer Name&quot;</sawx:expr><sawx:expr xsi:type="sawx:untypedLiteral">George Maguire</sawx:expr></sawx:expr><sawx:expr xsi:type="sawx:rank" op="top" appliedFromNavigationSource="navigationSourceReport"><sawx:expr xsi:type="sawx:columnExpression" formulaUse="display" displayUse="display"><saw:columnFormula formulaUse="display"><sawx:expr xsi:type="sawx:sqlExpression">&quot;Base Facts&quot;.&quot;1- Revenue&quot;</sawx:expr></saw:columnFormula></sawx:expr><sawx:expr xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="xsd:decimal">10</sawx:expr><sawx:expr xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="xsd:decimal">10</sawx:expr></sawx:expr></sawx:expr></sawsel:filter><sawsel:variables/></sawsel:appliedStates></sawsel:ref></sawsel:xmlStatesReferredTo></sawsel:dashboardSelections>

Line:2, Col:2828, Element 'expr' is not valid for content model: '{null}'

Steps to reproduce:

  1. On Samplesales lite , create a report with criteria - Time: Per Name Year, customer name and revenue->Save this report as A.
  2. Create a dashboard prompt: column prompt->customer name.->Save this prompt as B.
  3. Create a dashboard with this prompt and report.->Save this dashboard as C.
  4. Edit the report and on customer name->Interactions->Primary Interaction->Action Link -> Link Text : navigate to current page Action: navigate to BI Content and then select dashboard C.
  5. Open dashboard C.
  6. Click on a customer name, for example "Philippe Lionel". This will navigate to the current dashboard page and set the prompt.
  7. Click on "Save Current Customization" (Under "Page Options" in upper right corner).
  8. In the popup: enter a name and click "OK"

An error message is shown.

Error message:
The current xml is invalid with the following errors:
Bad xml instance!

Note: Tested this issue by applying patch for following bug but the issue still exists.
<Bug 25498573> - BAD XML INSTANCE ERROR WHEN SAVING CUSTOMIZATION IN DASHBOARD

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.