Log and Ignore Row Error

From Starfish ETL
Revision as of 17:54, 7 December 2020 by Jkuehlthau (talk | contribs) (Created page with "To log an error on a Row, we must ues the Starfish.ErrorMessage property. To continue running a job when a row errors, we need to set Starfish.SuppressError=true; in an "On R...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

To log an error on a Row, we must ues the Starfish.ErrorMessage property. To continue running a job when a row errors, we need to set Starfish.SuppressError=true; in an "On Row Error" POST-PROCESS.

First, create an "On Row Error" POST-PROCESS. In my post process, I use a globally created C# variable so I can use the Error Message later in the job.

void CSharpProcedure()
{
    sQuoteToNSError = Starfish.ErrorMessage;
    //Starfish.LogMessage(sQuoteToNSError);
    //There's also a boolean you can set called "SuppressError" which will swallow the error and allwo the process to continue
    //I could check the error message for something and then set that to true if I want to ignore it.
    Starfish.SuppressError=true;
}