Partial load of data using GRLOADER if the input .XML contains local or national characters (example: accented small letter a)

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Using GRLOADER with XML files containing special/national characters like (it is only an example) accented 'a', the result is a partial load of the data.

The command used to upload the data is:

grloader -u <userid> -p <password> -s http://localhost:8080 -a -E -n -tf "C:\Program Files (x86)\CA\Service Desk Manager\bin\rules.xml" -i input.xml

The result is that only the items before the one having the accented letter have been inserted.
In grloader.log there are these error messages:

 

-----       
ERROR grReader 189 Invalid UTF-8 character detected during processing of input.xml 
ERROR grReader 191 java.io.UTFDataFormatException: Invalid byte 2 of 3-byte UTF-8 sequence.
-----

 

A wrong behavior having the same root cause can be noticed simply when trying to see the input.xml file via Internet Explorer: the file is partially displayed and where the accented 'a' is found the following error message is noted:

-----
The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

An invalid character was found in text content. Error processing resource 'file:///C:/Folder1/Folder2/Folder3/input.XML

<name>Name containing accented a
..
-----

 

Environment

CA Service Management 17.3.X 

Resolution

The problem in both the cases is due to the encoding of the input.xml file not in UTF-8.

A workaround is the following:

1. Open the input.xml file with a notepad
   
   
2. Click on File, Save As
   
   
3. In the Encoding dropdown select 'UTF-8'
   
   
4. Click on Save

The input.xml file saved with UTF-8 encoding can now be successfully used by GRLOADER with no loss of data and can be correctly opened by Internet Explorer without error message.