Error pipelines and pipeline execute
I am currently working on redesigning our error handling functionality. My basic design was to write all errors to a sql server so we can have a dashboard of pipeline issues in the last 24 hours. As a proof of concept I set this up on one of our more complex pipelines that has multiple calls to several different child pipelines in order to perform some processes in parallel.
I know the data set I'm working with and know it has exactly 5 errors in it so when I added the error pipeline to everything I was expecting to see 5 lines, but instead I had 40. I'm guessing this happened because I put the error pipeline on both the parent pipeline and the child pipelines. I think the obvious solution would be to only have the error pipeline on the parent pipeline and have the child pipelines just ignore errors, but I was hoping the community could inform me of what best practice on this truly is since I can't seem to find any document that says how you should configure error pipelines when you are working with pipeline execute snaps.
Also a secondary question, if I only have the error pipeline in on the parent is there any good way for me to pass the actual name of the snap that caused the error back to the parent so it can be sent to the error pipeline as well? currently it looks like the error documents loaded to my table only get the name of the pipeline execute snap returned, but I'd really like to get the name of the snap in the child pipeline that caused the error since I think it will make debugging much simpler.