Insert into PostgreSQL not working

[Anonymous]

Hey all,

I first thought it was a date formatting issue but it appears im unable to insert ANY data into my PostgreSQL database.

The situation:

- A delimited file that produces a String. Example:  "   209"

- A table with 1 column varchar(50)

Job + tMap

http://imgur.com/a/Xwqe0

The error:

Starting job testPostgreConnect at 15:10 13/04/2017.

[statistics] connecting to socket on port 3645
[statistics] connected
Batch entry 0 INSERT INTO "newtable" ("id") VALUES (  209) was aborted.  Call getNextException to see the cause.
[statistics] disconnected
Job testPostgreConnect ended at 15:10 13/04/2017. [exit code=0]

I went debugging and found this... only it doesnt tell me much. 

http://imgur.com/a/Gd1lx

FIXED. The database name and schema name weren't filled in...

[Anonymous]

The first solution in such cases is to switch off the batch mode in the advanced settings of the component.

The good news is, Talend will provide the "next exception" in one of the next releases - so you do not have to change your job to get the detailed error message.