topic Reject handling in postgresSQL in Talend Studio

Reject handling in postgresSQL

gervit14 — Thu, 11 Jul 2019 11:04:22 GMT

Hi all,

I am doing reject handling in tmap and using tpostgresqlOutput component.

Problem is if any record got fail to load in target db,ideally this particular record should go to the reject flow and subsequent should go in the target but in my case if any record got rejected due to some constraint issue, subsequent all records (which are good records) are going to the reject flow.

Please help me in this.

Re: Reject handling in postgresSQL

Anonymous — Thu, 11 Jul 2019 11:54:00 GMT

I am not sure if this can be done. I think that only reject data can go to that file, you can make the job to fail if "some constraint issue" happens.

If you know which issue can happen you can add another output and put some filter.

Re: Reject handling in postgresSQL

Anonymous — Thu, 11 Jul 2019 12:27:00 GMT

The issue is not very clear for me.

Are you handling reject on tmap or tDBOutput or both?

Re: Reject handling in postgresSQL

gervit14 — Thu, 11 Jul 2019 12:38:08 GMT

I am taking reject flow from the tpostgresoutput component (keeping 'die on error' unchecked) and not at tmap side.

Re: Reject handling in postgresSQL

gervit14 — Thu, 11 Jul 2019 12:44:08 GMT

Thanks for your reply.

You are correct, ideally only the record having constraints violation should go to reject, but in my case if any one record got rejected by any constraint violation, all the subsequent record (which are not having constraint violation) are also going to the reject flow.