Null pointer exception in tPostgresqlOutput

[SD29]

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?

[Denis_Segard]

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

[SD29]

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.