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.
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.