OBIEE 11g: Error: "Sax Parser Returned An Exception. Message: A '<' character cannot be used in attribute. Error Codes: UH6MBRBC or AGEGTYVF" When Exporting Data to Excel (Doc ID 1663644.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.
**Updated 16-Oct-2014**
*Merged with 1919572.1*

Symptoms

When trying to export data from reports to Excel files using certain number formats, the following error appears:

Error:
"Sax parser returned an exception. Message: A '<' character cannot be used in attribute 'xdofo:formatMask', except through &lt;, Entity publicId: , Entity systemId: , Line number: 49, Column number: 679
Error Details
Error Codes: UH6MBRBC
Location: saw.subsystem.go.getxslfo, saw.subsystem.portal.pdf,saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server,saw.rpc.server.handleConnection, saw.rpc.server.dispatch,saw.threadpool.socketrpcserver, saw.threads"

You may also see this error:
"A fatal error occurred while processing the request. The server responded with: org.xml.sax.SAXParseException: <Line 15, Column 208>: XML -20126: (Fatal Error) '<' cannot appear in attribute value..
Error Details
Error Codes: AGEGTYVF
Location: saw.rpc.mis.read, saw.subsystems.portal.generatedashboardexcel.currentpage, saw.subsystems.portal.generatedashboardexcel, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads"

For example: field of type "number" formatted to show has "####"."#####"."##

Step to reproduce the issue are:

1. Log on to BI Analytics.

2.Create an analysis with a Custom Number Format -
 "[<=9999999]###-####;(###) ###-####" (phone number format) defined.

3. Print the report to PDF, it works fine. The Custom number Format was seen in PDF.

4. Click on Export icon from ToolBar to export this report to Excel 2007.

The above error message appears.

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