Table of Contents

The data flow cannot parse JSON records

The following exception occurs when you start processing a data flow run:

Cannot parse JSON <specific information about a data flow shape>

The error message usually points at the Source shape of type Stream in the data flow rule as the place where the error occurred.


This error is caused by incorrectly formatted JSON input records in the data set.


To eliminate this error, perform the following steps:

  1. Review the error details to find which shape in the data flow contains the incorrectly formatted JSON input records that caused the error. For more information, see Tips for troubleshooting data flow rules.
    Click View input record to view the record that caused the error.
  2. Update the JSON formatting based on the root cause of the error.


The following example input record contains incorrectly formatted JSON:

  { "CellIdCaller": "1", "CallRecipient": "1", "CellIDRecipient": "1", "CallDirection": "1", "SubscriptionID": "S-892","TerminationCode": "1", "CallDuration": "20", "CDRMapping": {} "CallID": "1"

The following example error message identifies the root cause of the incorrect formatting:

Caused by: com.fasterxml.jackson.core.JsonParseException: Unexpected character ('"' (code 34): was expecting comma to separate OBJECT entries
at [Source: com.pega.dsm.dnode.util.ClipboardPageJsonConverter$ByteBufferInputStream7158ccb7; line: 1, column: 185]

Based on the above examples, you can conclude that the error is caused by a missing comma between the CDRMapping and CallID properties in the JSON input record.

100% found this useful

Related Content

Have a question? Get answers now.

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