[resolved]ERROR: column "null" specified more than once

[Soumya_M]

Hi all, I've a talend job

need help in rectifying this error:

Exception in component tDBOutput_1 (first_left_join)

org.postgresql.util.PSQLException: ERROR: column "null" specified more than once

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)

at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)

at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)

at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)

at local_project_1.first_left_join_0_1.first_left_join.tDBInput_1Process(first_left_join.java:2271)

at local_project_1.first_left_join_0_1.first_left_join.runJobInTOS(first_left_join.java:4621)

at local_project_1.first_left_join_0_1.first_left_join.main(first_left_join.java:4459)

It's a recurring error, any help would be appreciated

[Anonymous]

Can you show us your tDBOutput_1 config and show us the schema as well. My suspicion is that you may be trying to load more columns than are in the schema of the DB.

[Soumya_M]

This is how my tmap looks like The DB schema looks like this

[Anonymous · Accepted solution]

I think I know why this is happening. Take a look at the screenshot I have copied from yours. You will see a blue box. This field holds the DB column names. It needs to be populated.

I forgot to highlight the DB Type fields as well. These need to be populated.

[Soumya_M]

Got it rectified!

Thank you 🙂