unique constraint or index violation while inserting data

0
We are occasionally getting the error below. It does not seem to hold up any processing and does not happen consistently. If I try to perform the same exact operation right after getting this it generally will not occur. Can anyone help decipher what the issue is? Thank you!    com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_11189 table: "esat$departmentline_employeeremote"     at ESAT.GetEmployeeRemoteInfo (Change : 'Change 'DepartmentLine' (DepartmentLine_EmployeeRemote)') Advanced stacktrace:     at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_11189 table: "esat$departmentline_employeeremote"
asked
1 answers
0

I had this error before. On what Mendix version are you running? Are you using high volume processing of data with for instance run in background / separate Java transaction logic?

The error states that an association can not be set because it violates the database constraint. This can happen in above scenario when there already is for instance a 1-1 association to the same object and in a separate not coupled, probably with separate Java transaction logic this association was not found yet and the association is put in the database.

 

answered