My Oracle Support Banner

OBIEE 12c: Expanding a Hierarchy Column Throws a Bad XML Instance Error or the Levels are Displayed Incorrectly (Doc ID 2218463.1)

Last updated on FEBRUARY 13, 2019

Applies to:

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

Symptoms

After upgrading from OBIEE 11g (11.1.1.7.x) to OBIEE 12c (12.2.1.2.0), where the native Teradata ODBC driver is used to access the back-end Teradata database (the datasource for the OBIEE analyses), ragged hierarchies behave unexpectedly and/or throw an error when expanded.  See various symptoms may be encountered as below :-

1.  When expanding / drilling down on a particular level in the hierarchical column, the following error is thrown:

Error Displaying Results
The current xml is invalid with the following errors: Bad xml instance! .... Element 'target' is not valid for content model: '(staticMemberGroup,(target|measureTarget))' ... Element 'selectionGroups' is not valid for content model: '(selectionGroup,)

Error Details
Error Codes: EIRWWH9E

2.  When expanding / drilling down on a particular level in the hierarchical column, the "child" level appears above the "parent" level.  For example: 

See results after drilling to the 1st level (correct behavior):-
[+] ACME Corporation
     [+] ACME Level 1

See results after drilling to the 2nd level (incorrect behavior):-
[+] ACME Corporation
          [+] ACME Level 1.1 <<<<====== The "child" level displays above its "parent"
     [+] ACME Level 1

 3.  The root (Grand Total) is not displayed.  For example:

Organization Hierarchy
[+]                            <<<<==== The Grand Total (root level) is "blank"
    [+] ACME Level 1
    [+] ACME Level 2

Changes

 

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
Changes
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.