topic Talend Error - Batch entry 0 INSERT INTO "data" in Talend Studio

Talend Error - Batch entry 0 INSERT INTO "data"

Anonymous — Tue, 12 Apr 2016 13:33:44 GMT

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 ?

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

Anonymous — Tue, 12 Apr 2016 15:52:05 GMT

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.

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

Anonymous — Wed, 13 Apr 2016 04:39:30 GMT

Hello
Which components do you use in the job? Can you please upload a screenshot of your job?
Regards
Shong