Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 ?
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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