Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

CSVParseException: Quotation is not closed



A dataset rule of type File is created which points to a CSV file with a new line character in its data value. Parsing error occurs on running a data flow using this dataset as the primary data source.

Error Messages

Caused by: com.pega.bigdata.dataset.parsers.CSVParseException: Quotation is not closed
    at com.pega.bigdata.dataset.parsers.CSV.parseRow(
    at com.pega.bigdata.dataset.parsers.CSVWithTargetPropertiesRowParser.parse(
    at com.pega.bigdata.dataset.parsers.CSVRowParser.parse(
    at com.pega.bigdata.dataset.parsers.CSVRowParser.parse(

Steps to Reproduce

  1. Create a file dataset which points to a simple CSV file stored in a repository.
  2. Ensure the CSV file is formatted to use double quotes around all fields in the file.
  3. Ensure the CSV file contains at least one text field.
  4. Add at least three records in the file.
  5. Ensure one of the records has a value in the text field which contains a new line.
    For example,

    userid, age, textfield,name

    "111","29","dummy text","name1"

    "222","33","dummy text with 


    line", "name2"

    "333","36","dummy text with no new lines","name333"

  6. Load a file such as the above sample in to the decision data store.

Root Cause

The failure occurs while the CSV parser parses the new line character. Parsing a new line character in CSV is not supported.


An enhancement request, FDBK-29713, is created for consideration by Pega Product Management.


Published January 19, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us