DB Deadlock caused by changetracking trigger

(0) Share

Report

Posted on by CRSW

627

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?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Jim Ji Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Sunnyw Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No