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 APRIL 30, 2023

Applies to:

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!

Cause

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