The data flow run fails with an error while results are being written in a database data set.

Cause

There was a problem with processing input records. The solution below helps you narrow down the number of possible root causes of the problem by analyzing the stack trace and the problematic records. 

Solution

Perform the following actions to find the root cause and eliminate errors while processing input records:

• Analyze the stack trace that contains the error. For more information, see Tips for troubleshooting data flow rules.
• Save the object that causes the error to a database by calling the Obj-Save method from an activity. Investigate any errors that are encountered as a result of the activity processing. If this activity is processed without any errors, it might point to a system issue that is independent of the Pega 7 Platform. For more information, see Obj-Save method.
  To process multiple records, you can use the default commit method to accumulate the records and process them all at once.