I am writing to ask for your help.
I have a job structured as follows:
Code: Select all
DS -> RD -> CONNECTOR (ONLY UPDATE)
Key of update is a subset of primary key, hence the presence of Remove Duplicate to which I added a HASH / SORT for the same subkey.
I was able to verify that there are no duplicates with respect to the key update.
The target table has many indexes, which cover various fields for various usage needs (we are in DWH environment).
I haven't deadlock when job runs on development test, where degree of parallelism is 2.
Otherwise, I obtain deadlock when job runs on test environment, where DOP is set to 4.
The connector has the default configuration.
I repeat execution of job many times, both on develop and test, avoiding execution of other jobs.
Target table on test env is exposed to test-user throw BO Universe.
I don't understand what is the reason of this behavior.
What I'm missing?
What can cause a deadlock?
Thank you for your help,
Sandro