topic Re: batch entry 0 INSERT STATEMENT error in Talend Studio

batch entry 0 INSERT STATEMENT error

Anonymous — Wed, 05 Apr 2017 03:26:22 GMT

I am trying to load data from load.xlsx file to a table in postgres load table. It shows that it is insert all rows and at last i get an error : batch entry 0 INSERT INTO "cons"."load"("id", "name", ...., "active") VAUES (1, 'srujan', ....'Y') was aborted. Call getNextException to see the cause.
I tried to debug the issue, but i could not find out what the issue was.

Re: batch entry 0 INSERT STATEMENT error

TRF — Wed, 05 Apr 2017 09:33:00 GMT

What if you try the same insert without TOS (using SQL)?

Re: batch entry 0 INSERT STATEMENT error

Anonymous — Wed, 05 Apr 2017 17:44:22 GMT

I need to handle null checks and data format conversions using routines within tMap. I use to do this before and it worked fine. Recently this is showing such kind of exception for which i am unable to back track/trace.