Issue with tMSSqlOutput - Primary key violation

Anonymous — Wed, 04 May 2016 10:10:08 GMT

hi,

As i try to insert data, im havving the error;

[statistics] connecting to socket on port 3844
[statistics] connected
Violation of PRIMARY KEY constraint 'PK_B_EQ1996'. Cannot insert duplicate key in object 'dbo.B_EQ1996'. The duplicate key value is (0).
[statistics] disconnected
Job asdasd ended at 04:34 04/05/2016. [exit code=0]

But the component explanation says job will continue;

Insert
[font='Helvetica Neue', Helvetica, Arial, sans-serif]With the Insert action, data will be inserted. If a Primary Key violation occurs, this will be reported, but the Job will continue.[/font]

How can i continue tracnsation even primary key violation occurs?

thanks!

Re: Issue with tMSSqlOutput - Primary key violation

Anonymous — Wed, 04 May 2016 10:11:42 GMT

attached the job

Re: Issue with tMSSqlOutput - Primary key violation

Anonymous — Tue, 07 Jun 2016 03:23:31 GMT

Do you want to terminate and expect the job to fail? If so, go ahead and make check mark on "Die on error" check box.

Hope it helps

Thanks
Rohan Suresh

topic Re: Issue with tMSSqlOutput - Primary key violation in Talend Studio

Issue with tMSSqlOutput - Primary key violation

Re: Issue with tMSSqlOutput - Primary key violation

Re: Issue with tMSSqlOutput - Primary key violation