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

Document ID : KB000019499
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

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.