One Star

Talend Error - Batch entry 0 INSERT INTO "data"

connecting to socket on port 3435
Batch entry 0 INSERT INTO "data" ("type","id","created_at","updated_at","data") VALUES ('mail',?,'2015-09-28 10:16:07.074000 +05:30:00','2015-09-28 10:16:07.074000 +05:30:00','{"id":"10d49f75-7da7-4873-aa56-6b2e53a09504","user":{"id":"936ec771-37ec-4e1c-b990-d92282c0d074","createdAt":"Sep 14, 2015 9:26:40 AM","updatedAt":"Sep 14, 2015 9:26:40 AM"},"externalUserId":"+446756756765","credential":{"grantedPermissions":[]},"profile":{"externalUserId":"+446756756765","name":"FF F","channelType":"com.fastacash.user.whitelistchannel.entity.WeChatChannel"},"invalid":false,"channelType":"wechat","createdAt":"Sep 28, 2015 7:22:47 AM","updatedAt":"Sep 28, 2015 7:22:47 AM"}') was aborted.  Call getNextException to see the cause.
Job Src_Stg_Archiveddata_Xpress ended at 17:54 12/04/2016.

How to fix this issue ?
Four Stars

Re: Talend Error - Batch entry 0 INSERT INTO "data"

In TOS/TIS  you would Switch of "useBatch" of the insertcomponent, then you will get the erromessages.
You could also look into the errorlog of the DBMS you are writing to, sometimes the error is displayed there also.
Community Manager

Re: Talend Error - Batch entry 0 INSERT INTO "data"

Which components do you use in the job? Can you please upload a screenshot of your job?
Talend | Data Agility for Modern Business