One Star

Talend Error - Batch entry 0 INSERT INTO "data"

connecting to socket on port 3435
connected
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.
disconnected
Job Src_Stg_Archiveddata_Xpress ended at 17:54 12/04/2016.

How to fix this issue ?
2 REPLIES
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"

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