Database output writes all null records

[Anonymous]

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!  🙂

[Anonymous]

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

[Anonymous]

Hi Kiran,

How do I collect rejected records?

Thanks.

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi All,

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

Thanks.

[Anonymous]

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