Support Article
Data import fails when fields contain CR/LF chars
SA-16044
Summary
Unable to use the Data Explorer Load feature (data import from a file). The log file displays a java.lang.StringIndexOutOfBoundsException. A dialog box on the screen displays 'Uploading...', and then clears the input file name.
ERROR MESSAGE
No error on the UI side. Importing a file failed; the log file showed a java.lang.StringIndexOutOfBoundsException. On the end user side, the dialog box says briefly 'Uploading...' and then clears the input file name.
STEPS T REPRODUCE
Go to Data Explorer.
Create a new data type if necessary.
Click Records tab.
Click Actions > Import.
Load a CSV file similar to the attached example.
Root Cause
A defect in Pegasystems’ code or rules. If there is a new line character within the CSV fields, while importing the file, these new line characters are treated incorrectly and parsed as if it's the end of a row in CSV.
Resolution
Apply HFix-24318. The fields containing new line characters will be enclosed in double quotes while exporting. While importing, parsing logic is changed to handle new line characters within the fields.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.