OBIEE 11g Bad Xml Instance! Error While Trying To Save A Customization (Doc ID 2063088.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.141014 and later
Information in this document applies to any platform.

Symptoms

Facing a Bad xml instance error, while trying to save a customization in one of the reports. But this error comes only when customer moves a row format to column format by right clicking on the value and choosing the option move to column. Following error  is also seen in the last line of error message :

'' Line:2, Col:1538, Datatype error: Type:InvalidDatatypeValueException, Message:Value 'NaN' does not match regular expression facet '[+\-]?[0-9]+'.''

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

<?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="u6dv0lo09ib3j79llrs5tenauu"><sawst:container cid="f:dpstate" xsi:type="sawst:dashpromptstate" statepoolId="t3ahcdv0o9pktln1m1ipov7lfe"/></sawst:container><sawst:container cid="p:dld45dojvmcm0bbb" xsi:type="sawst:page"><sawst:container cid="s:m6f6njrpro64loln" xsi:type="sawst:section"><sawst:container cid="g:tapetfs5ae9og54f" xsi:type="sawst:dashprompt" links="-"/></sawst:container><sawst:container cid="r:n8j24s968ni9mtcc" xsi:type="sawst:report" links="mfrd" defaultView="compoundView!3" searchId="qn04u2l317fle6f31tq7nsdngu" folder="/shared/gCore Financials/General Ledger/Reports" itemName="GL6.2 GL Balance Trend" preDrillState="rn3o09insb1sqiuvpq5t4p4km6" previousState="4s2ucbi3v48msr3udc9pga2lte" hasDrillState="true"><sawst:container cid="v:compoundView!3" xsi:type="sawst:view"><sawst:container cid="v:viewSelector!1" xsi:type="sawst:view" selectedView="pivotTableView!1"><sawst:container cid="v:pivotTableView!1" clientRowStart="0" clientRowEnd="NaN" clientColStart="0" clientColEnd="NaN" xsi:type="sawst:view" startPage="0"/></sawst:container></sawst:container></sawst:container><sawst:container cid="f:dpstate" xsi:type="sawst:dashpromptstate" statepoolId="623md7h6bv7gljgqpqvl6g473i"/><sawst:container cid="s:joeopevvl8eiqfs9" xsi:type="sawst:section"><sawst:container cid="n:condition" xsi:type="sawst:navigation" conditionId="1269266" conditionEvalStatus="complete" conditionMet="true"><sawst:container cid="r:navReport" xsi:type="sawst:navReport" links="b" defaultView="compoundView!1" folder="/shared/gCore Financials/General Ledger/Reports" itemName="Currency Check - GL Trend"/></sawst:container></sawst:container><sawst:container cid="s:o9cbv3s3mp5h9dgp" xsi:type="sawst:section"><sawst:container cid="n:condition" xsi:type="sawst:navigation" conditionId="1269266" conditionEvalStatus="complete" conditionMet="false"><sawst:container cid="r:navReport" xsi:type="sawst:navReport" links="b" defaultView="compoundView!1" folder="/shared/gCore Financials/General Ledger/Reports" itemName="Currency Check - GL Trend"/></sawst:container></sawst:container><sawst:container cid="s:matujnpgulben5ve" xsi:type="sawst:section"/></sawst:container></sawst:container></sawst:envState><sawsel:xmlStatesReferredTo><sawsel:ref refId="u6dv0lo09ib3j79llrs5tenauu"><sawsel:appliedStates><sawsel:filter><sawx:expr xsi:type="sawx:logical" op="and"><sawx:expr xsi:type="sawx:list" op="in" promptPrimarySubjectArea="&quot;gCore Financials - GL Balances&quot;"


Steps are following :
1. Generate a report with certain filter values.
2. Move row format to column format for one attribute .
3. Then  try to save it, and it throws error.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms