Schedule event XASinstance error

0
Hi, Schedule events are not working in our server. It says  ‘com.mendix.systemwideinterfaces.core.UserException: Object of type 'System.XASInstance' with guid '562949953651413' cannot be updated, as it does not exist anymore’ when we queried against db table the above object is not present, but the association table scheduledeventinformation_xasinstance has few rows with the 562949953651413 xasinstanceid we tried deleting that rows  from association table but  when the next time event runs again objects are associating with same 562949953651413  xasinstanceid Any idea when xasinstance object gets triggered and when it will associated to scheduledeventinformation entity   Below are the console errors: 2022-11-14 04:33:27.037 WARNING - Core: Failed node management action: node heart-beat. 2022-11-14 04:33:27.037 WARNING - Core: com.mendix.core.CoreRuntimeException: Failed to commit     at com.mendix.basis.component.TransactionCore.commit(TransactionCore.scala:149)   Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: com.mendix.systemwideinterfaces.core.UserException: Object of type 'System.XASInstance' with guid '562949953651413' cannot be updated, as it does not exist anymore     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: com.mendix.systemwideinterfaces.core.UserException: Object of type 'System.XASInstance' with guid '562949953651413' cannot be updated, as it does not exist anymore     at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)
asked
1 answers
1

Did you manually delete records from the database. Not using the mendix action, but directly through the database viewer/manager?

 

//Edit//

When deleting objects directly using the database manager, you will run into data corruption.

Since associations are maintained by the Mendix runtime, when deleting an associated record, the record of the association will stay in the database, when deleting data manually. When executing a delete through the Mendix runtime, Mendix will delete association records as well.

 

Thus in short: never manage the data in the database using the database manager (unless you must and know what you are doing) always use the Mendix runtime. by using microflows or a overview page for an sys admin.

 

To fix your issue, delete the records in the association table manually, to fix your issue created manually.

answered