topic Re: Null pointer exception in tPostgresqlOutput in Talend Studio

Null pointer exception in tPostgresqlOutput

SD29 — Tue, 20 May 2025 11:27:15 GMT

Hi,

I am trying to toad data from csv file to postgres table. There is no null data in input file still i am getting Null pointer exception.

Here is the Error :

Exception in component tPostgresqlOutput_3 (emp_filter)
java.lang.NullPointerException
at my_practice_test.emp_filter_0_1.emp_filter.tFileInputDelimited_2Process(emp_filter.java:652)
at my_practice_test.emp_filter_0_1.emp_filter.runJobInTOS(emp_filter.java:1461)
at my_practice_test.emp_filter_0_1.emp_filter.main(emp_filter.java:1310)

Any Idea how to resolve?

Re: Null pointer exception in tPostgresqlOutput

Denis_Segard — Tue, 20 May 2025 17:50:51 GMT

Hello,

You can go in the "Code" panel and check the line 652
emp_filter.java:652
It may help you to understand what is happening ...

https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/code-viewer

kind regards
Denis

Re: Null pointer exception in tPostgresqlOutput

SD29 — Thu, 22 May 2025 07:48:47 GMT

Hello,

Hi have tried multiple workarounds. In tPostgresqlOutput component, 'Action on Table' is 'Default' or 'Action on Table' is set to 'Drop and Create Table' job runs successfully and fails if 'Action on Table' is set to 'Create Table if does not exists'

Thank You.