06-30-2021 12:37 PM
I have a pipeline that creates files based upon 490 records in an Oracle table. I create the output by doing a select on static headings that I create and union it with actual records from the table and then I sftp the file. I wanted to also be able to email the file, so snapLogic support suggested adding a Copy snap and sending one to sftp and the other to email, so I added a Copy snap right after the Oracle Execute snap that then went to a CSV Formatter snap and then to a File Writer snap to sftp. The copy also went to a CSV Formatter and then a File Writer to create a file in my directory and finally an email snap to send the file. All of this worked EXCEPT that the listing I received was 491 records (which included a header) TIMES 490!!! For whatever reason, it repeated the copy 490 times!!! Any ideas as to why???
07-01-2021 07:11 AM
The view names are simply a way to reference the data as it streams - it doesn’t affect the data as it moves.
If you could provide a screenshot of the Pipeline Execution Statistics for this job, that might help me explain to you what is happening within the pipeline. You can get this either from Designer (if you are running manually), from this button in the toolbar:
Or by clicking the Status text from Dashboard:
07-01-2021 07:42 AM
SLPL.docx (1.2 MB)
07-01-2021 07:43 AM
It looks like the Oracle - Execute3 is taking the input 490 records and multiplying it by 491 (includes the header). But why?
07-01-2021 07:45 AM
So, when I add the Tail snap in, it only delivers 1 record - the header!
07-01-2021 08:49 AM
Interesting…when I pull it out of the pipeline and create a new pipeline, it works as it should: