Unable to store data, error copying stream. Caused by: Failed generating xml document Caused by: Invalid white space character (0x3) in text to output

Document created by Pavan_Sirasanambedu Employee on Oct 28, 2015Last modified by luis_nevarez on Mar 1, 2016
Version 2Show Document
  • View in full screen mode
While parsing Flat file to XML, you got below error, if you have special white space characters.

 

Unable to store data, error copying stream.; Caused by: Failed generating xml document; Caused by: Invalid white space character (0x3) in text to output
To solve the issue, use data process step after getting the data from source system(Disk, FTP, SFTP).

 

Select search/replace option and use below syntax,

 

Search : \u0001
Replace :

 

Search : \u0003
Replace :

 

Replace with empty space then you won't see that error.

 

Attachments

    Outcomes