DB Deadlock caused by changetracking trigger

(0) Share

Report

Posted on by CRSW

593

Hi I tried to Setup the changetracking inside Dynamics AX2012. Therefore I enabled the changetracking on the databases I want and created the triggers in the related tables.

My triggers are set on the following table:

ECORESPRODUCT
EcoResProductTranslation
InventDimCombination
RetailAssortmentLookup
EcoResProductCategory
EcoResProductMasterDimensionValue
EcoResInstanceValue
EcoResAttributeValue
EcoResValue

For all these tables I do have an update, insert and delete trigger.

since the changetracking is running I am not able tocreate values in the EcoResValue table. There is always a deadlock on the DB

The error message Looks like

Cannot add arecord in The base table for other value tables that each stores values of a different data type (EcoResValue), RelationTypeField: xxxx, xxxxxxx. Deadlock, one or more users try….

Any suggestions why this happens and how I can track changes in the EcoRes Tables?

All responses (2)

Answers (0)

Sunnyw on at

Like (0)

Report

RE: DB Deadlock caused by changetracking trigger

Hello CRSW,

In addition, you may want to work with DBA to gather deadlock event or report to understand what SQL statements involved with deadlock to troubleshoot further. You can also obtain yourself using existing tools like extended event, see www.mssqltips.com/.../. It would also be easy to troubleshoot in isolated environment with replication step as well.
Jim Ji on at

Like (0)

Report

RE: DB Deadlock caused by changetracking trigger

How did you insert the records(SQL script / X++ / UI)? would you share your code or provide more information.

Change tracking won't cuase deadlock issue normally.