Help Center

Troubleshooting HTTP/FTP: Review raw data Line and Position to identify issues

Sarah B
Sarah B
  • Updated

File parsing can break if unexpected data or missing data is found in the file, especially for XML. Our system will stop the import process as "failed" and bubble up a system error message about the line and position where the issue was found in the raw data.


Review the raw data Line and Position to identify the issue

  1. Go to Products > Primary Source
  2. Find the raw file, HTTP address or from FTP location
  3. Open the raw file in Notepad++ or other program
    1. FTP: download the file from the FTP location
    2. HTTP: open and download the file from the address, enter username and password if prompted
  4. Ctrl + G - Use this shortcut key combo to open the "Go to..." promptmceclip0.png
  5. Enter the line number and then Go
  6. Look for the issue, such as "invalid XML format", "unexpected character" or "unexpected element name X"


This is shown in the bottom right in Notepad++ as Ln: 14 Col: 19.



Example system error messages

SYSTEM ERROR MESSAGE: An error occurred while parsing EntityName. Line 92, position 52. 

SYSTEM ERROR MESSAGE: Data at the root level is invalid. Line 1, position 1.

SYSTEM ERROR MESSAGE: Root element is missing.

SYSTEM ERROR MESSAGE: Unexpected end of file has occurred. The following elements are not closed: channel, rss. Line 4, position 1.

SYSTEM ERROR MESSAGE: Reference to undeclared entity 'AMP'. Line 88074, position 16.

SYSTEM ERROR MESSAGE: 'doctype' is an unexpected token. The expected token is 'DOCTYPE'. Line 1, position 3. 

SYSTEM ERROR MESSAGE: Response contains invalid XML 

Was this article helpful?

1 out of 3 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.