WES full sync package application in scale unit can trigger InventDim change tracking deadlock

[AndreasHassing]

During WES full sync package application in a scale unit, the environment can get into a InventDim change tracking deadlock (undetectable by SQL).

It does not help that InventDim table has lock escalation disabled - this locking apparently occurs on some change tracking details system(?) tables.

The issue seems to occur at around 20,000 added InventDim row's during the package application (I'm guessing SQL decides to try and take a full table lock on InventDim's change tracking table).

A mitigation for this issue is to run the following SQL before WES full sync package starts applying on scale unit:

ALTER TABLE InventDim DISABLE CHANGE_TRACKING;

Then, after WES is applied on the scale unit, run:

ALTER TABLE InventDim ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON);

More details needed.