Cannot insert duplicate key in object dbo.audittrail$audittrailsuperclass
Hi , I am getting below error while commiting my objects. all my entity hasgenralisation as Audittrial superclass as I need to track all activities in my app. While creating an object I am getting below error.Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: Violation of PRIMARY KEY constraint 'PK__audittra__3213E83FF97FDF6B'. Cannot insert duplicate key in object 'dbo.audittrail$audittrailsuperclass'. The duplicate key value is (2533274790397005). (SQL State: 23000, Error Code: 2627) at com.mendix.basis.actionmanagement.ActionManagerBase.executeSync(ActionManagerBase.java:159) Anyone has any idea in this issue?
Nirmal Kumar Moodbidri Thilakraj
The issue popped up several times recently, have a look at the question and answers of this forum post;