ABORTed due to deadlock

[srini.dw]

Hi,

My Design => TPT Stage -> Transformer -> TPT Stage

Most of the times job gets successfully finished, but sometimes job gets aborted with below reason.
RDBMS code 2631: Transaction ABORTed due to deadlock.

The no. of records which gets inserted is very less, its around 1000 rows.
Any suggestions please.

Thank you,

[chulett]

Suggest you talk to your DBA. Find out why deadlocks happen and what you can do to prevent them.