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 AUGUST 30, 2021
Applies to:
Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and laterInformation 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:
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:
[+] 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:
[+] <<<<==== 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 |