Data in Error View

[Swatisree]

Hi,

I need to take the data in the error views into a file. I have mapped csv formatter and a file writer but there is no schema definition in error view. How do I get the failed records mapped into the csv?
I am comparatively new to snaplogic. Any help is much appreciated.

Thanks,
Swatisree

[shankarrao2]

Reference Implementation - Integration Pattern - Error Handling and Retry Pattern SnapLogic-specific Patterns

Error Handling and Retry Pattern This pipeline capture errors thrown by error view and invokes an error pipeline. The error pipeline captures the exception encountered and records all the data relating to the execution (Snap level and pipeline level) into a database schema. One could potentially use a database or Kafka or any JMS-compliant queuing mechanism to log the errors. [image] [image] [image] Video https://www.youtube.com/watch?v=tbCWh0uD17Q Pipelines Attached Error Handler Pipeli…

Please check this link, you have details about error handing patters.

Below screen shot, where i have created a simple error scenairo, which writes error to a txt file.

Hope this will help!!

[Swatisree]

I need rejected data from both the parser and the database. I have done it similarly but I am not getting the data preview option after validation as you have shown in the error link. I am not sure what I am doing wrong.

[Akash_Srivastav]

@Swatisree
Data preview will not show any data in Error View, if there is no Error in Parsing the data/loading in DB in your case.
Since you want to preview Errors for now, one thing you can do is- let’s say there a Not Null Field in DB, then do not map it in the mapper after csv parser. Also check the Execute during preview option in DB. Then records will start showing in the Error View for DB

Please note that all these changes need to be REVERTED later on & best approach would be to use an Error Pipeline framework as suggested by @shankarrao2