AnsweredAssumed Answered

Why is my process treating trailer like a data row?

Question asked by mickey on Mar 29, 2017
Latest reply on Mar 30, 2017 by DarrellFlenniken9941

Adam Arrowsmith

 

I have created a data-positioned flat file profile as illustrated below.

I have attached the file that I am attempting to process using the above flat file profile.  The process is erroring out on the last (TRAILER) row in the attached file.  It is complaining that the required third profile element is empty.(Please see below screen shot of run-time error).

 

 

However, the process should not be treating the TRAILER row like a product row.  Moreover, the process is rolling back the entire file even though the first 6,406 rows process without error.  What I would expect is  that the first 6,406 product rows should be loaded into SFDC and an error file should be generated.  Below is a screen shot of the relevant shapes within the process.  As you may see, the Catch branch should call an error sub process, but the Process Call shape is never invoked.  Any idea why my process is behaving this way?

 

Outcomes