tDBOuput Reject Rows Being Logged Twice

ml1662663516 — Thu, 21 Nov 2024 22:21:28 GMT

We are outputting some records to Snowflake.

We have a Reject trigger than logs the error message of any rejected records.

However, the error message is logged twice no matter how many rejected rows we have.

Here is a snippet from the logs:

Records Processed: 5
Records Sent: 4
Records Rejected: 1
Reject Reason: Timestamp '0001-12-31 18:09:24-05:50:36 BC' is not recognized
Reject Reason: Timestamp '0001-12-31 18:09:24-05:50:36 BC' is not recognized

As you can see, there is only one rejected record but the error is logged twice (in this case a bad date). I have verified all this in the source and target tables. That all works as expected.

Here is a screenshot of the subjob.
tJava_23 is what is doing the reject logging.
tJava_14 is what is doing the processed, sent, and rejected logging.

Pretty basic. I am at a loss as to why this would be logged out twice.

Any insight is appreciated.

Thank you!

Re: tDBOuput Reject Rows Being Logged Twice

ml1662663516 — Fri, 22 Nov 2024 20:43:11 GMT

I solved my own question.

There were two columns in the same row with the exact same "bad" date.

I originally thought this odd since everything points to rejected "rows" so I assumed there should be one error. But, it is clearly every rejection; not rows specifically.

This might help someone in the future.

topic Re: tDBOuput Reject Rows Being Logged Twice in Talend Studio

tDBOuput Reject Rows Being Logged Twice

Re: tDBOuput Reject Rows Being Logged Twice