cancel
Showing results for 
Search instead for 
Did you mean: 

Primary key violation and Deadlock issue

siba_pkd21
Participant
0 Kudos

Hi All

There were some jobs fetches Primary Key violation error and some other jobs fetches Dead lock error, Can anyone please help me with the possible Root Cause-RCA for this.

View Entire Topic
Sruti_P
Participant
0 Kudos

Hi Siba,

If you enable bulk loader it will grey out the 2nd tab options " delete data from table before loading", only one tab can be workable here.

As both the options does same this while bulk loader being truncate. So you can go for the it - truncate.

Regards,

Sruti

siba_pkd21
Participant
0 Kudos
Hello Sruti, This truncate option can be applicable to nonrecurring jobs but what to do for recurring jobs ? Regards, Siba