IBM Support

Error "org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document" importing artifacts using the ETM Excel Import Utility

Troubleshooting


Problem

An error is thrown in IBM Engineering Test Management (ETM) Excel Import Utility log when you attempt to import test artifacts from a Microsoft Excel spreadsheet:

Example: 

org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document

The importer tool generates XML from the spreadsheet's data to post the content to the ETM server. If the content contains invalid character, the server's XML parser cannot process that data. 

Symptom

A generic error in the ETMExcel Import Utility UI:

Error 400 Bad Request

A more detailed error in Mso2Rqm_Debug.log. Example:

org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1f) was found in the element content of the document

[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"ARM Category":[{"code":"a8m0z0000001j1CAAQ","label":"Test Management-\u003EUtilities-\u003EETMExcelWordImporter Utility"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Engineering Test Management

Component:
Test Management->Utilities->ETMExcelWordImporter Utility

Software version:
All Versions

Operating system(s):
Windows

Document number:
719403

Modified date:
24 August 2021

UID

ibm10719403

Manage My Notification Subscriptions