topic Re: DBOutput Components: how to log errors without force it to fail in Talend Studio

DBOutput Components: how to log errors without force it to fail

Lorenzo5 — Mon, 16 Oct 2017 11:39:59 GMT

Hello,

I have a tPostgresqlOutput that perform some insert statements.

Sometime it fails because of different reasons (related to constraint violations), and I wouldn't previously filter rows that are not good to be inserted.

I have set the tPostgresqlOutput component NOT to fail on error, and I would now be able to catch all bad rows (to log them, at least).

Is it possible and how?

Regards,

Lorenzo

Re: DBOutput Components: how to log errors without force it to fail

Vinlogs — Mon, 16 Oct 2017 14:11:55 GMT

I know that we can catch tMap errors without having the job to fail.
https://www.rilhia.com/quicktips/quick-tip-how-debug-tmap-errors
See if this link can help.

Re: DBOutput Components: how to log errors without force it to fail

Anonymous — Mon, 23 Oct 2017 08:29:02 GMT

Hi,

@lorenzolucioni wrote:

Hello,

I have a tPostgresqlOutput that perform some insert statements.

Sometime it fails because of different reasons (related to constraint violations), and I wouldn't previously filter rows that are not good to be inserted.

I have set the tPostgresqlOutput component NOT to fail on error, and I would now be able to catch all bad rows (to log them, at least).

Is it possible and how?

Regards,

Lorenzo

Are you looking for "Rejects" row from tPostgresqlOutput?

Best regards

Sabrina

Re: DBOutput Components: how to log errors without force it to fail

Lorenzo5 — Tue, 24 Oct 2017 10:50:09 GMT

Hi @xdshi

YES! I'm looking for something like "row rejected". I don't find it in the tPostgresqlOutput Component.

Where is it?

Regards,

Lorenzo

Re: DBOutput Components: how to log errors without force it to fail

Anonymous — Tue, 24 Oct 2017 10:55:12 GMT

Hello,

The "Rejects" row will be available when you uncheck "Use Batch Size" option in advanced settings of tPostgresqlOutput component.

Best regards

Sabrina