One Star

batch entry 0 INSERT STATEMENT error

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.  
2 REPLIES
One Star

Re: batch entry 0 INSERT STATEMENT error

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

Re: batch entry 0 INSERT STATEMENT error

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.