topic Database output writes all null records in Talend Studio

Database output writes all null records

Anonymous — Wed, 03 Oct 2018 05:39:59 GMT

Hello All,

I have a job that reads from PostgreSQL and writes to Netezza.

But all the records are NULL.

The connection option has been set to AutoCommit = ON

The DB output object is set to Die On Error = On

I get no errors. Unless I add a tLogRow object. Then every time I run it I get a the same error, but the column is different every time.

The error with the tLogRow object is:

{random_field_name} cannot be resolved or is not a field.

My questions are:
1) Why aren't the records getting written with any data?

2) Why do I get that error when I attach a tLogRow, but the error goes away when I remove it?

I am still very much a n00b so any pointers you can give me would be appreciated! 🙂

Re: Database output writes all null records

Anonymous — Wed, 03 Oct 2018 05:48:35 GMT

Hi ,

Could you please try disabling the die on error option and collect the rejected records to a file and see whats the issue?

Thanks,

Kiran

Re: Database output writes all null records

Anonymous — Wed, 03 Oct 2018 06:16:50 GMT

Hi Kiran,

How do I collect rejected records?

Thanks.

Re: Database output writes all null records

Anonymous — Thu, 04 Oct 2018 19:32:36 GMT

Hello,

I looked up the instructions on how to do that and made sure that "Die on error" was not checked.

However, I can't find an option for Run=>Reject when I right click on the object.

Any ideas where I may be going wrong?

Thanks.

Re: Database output writes all null records

Anonymous — Thu, 04 Oct 2018 19:35:43 GMT

On the tdboutput component go to advanced settings and disbale batch size
as well ..then right click on output component and u will find link called
rejects

Re: Database output writes all null records

Anonymous — Thu, 04 Oct 2018 19:40:32 GMT

Hi Kiran,

Thanks, that worked. But I am getting the attached error.

It is a different column nearly every time I run it.

Thanks.

Screen Shot 2018-10-04 at 1.39.22 PM.png

Re: Database output writes all null records

Anonymous — Mon, 08 Oct 2018 16:34:17 GMT

Hi All,

Anyone have any thoughts as to what I am doing wrong that would cause this error?

Thanks.

Re: Database output writes all null records

Anonymous — Wed, 17 Oct 2018 08:22:53 GMT

Hello,

Could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line? What's JDK version are you using?

Best regards

Sabrina