DSXchange

When I am executing the Job at first run i am facing the Error.
The Error is as follows.
SQLSTATE =23505 NATIVE ERROR=-803
"One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "STATEINFO" from having duplicate values for the index key."

The situation is If the key is matched then update the record.
If it is not matched then insert it.
At this point of time i am facing the error.
The job is getting aborted but if i load it again then I am not facing the error.
So for the second run i am not facing any error.

Thanks in advance

I think it is Unique index violation. There are duplicates in the data. Check the data for the Uniqueness.

Just try with disable Unique index and check whether the job gets successeded without any errors.it concludes whether the job is really getting abort with Unique index violation or not.