Hi all, im getting an error when im trying to create an account in Expense app which uses a microflow SaveNewAccount . Can anypne please help? An error has occurred while handling the request. [User 'demo_administrator' with session id 'bdef04b8-XXXX-XXXX-XXXX-XXXXXXXX8501' and roles 'Administrator'] -------- com.mendix.webui.WebUIException: Exception while executing runtime operation at com.mendix.webui.actions.client.RuntimeOperationAction.apply(RuntimeOperationAction.scala:72) Caused by: com.mendix.modules.microflowengine.MicroflowException: Failed to commit at Administration.SaveNewAccount (Change : 'Set password and save account') Advanced stacktrace: at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:83) Caused by: com.mendix.core.CoreRuntimeException: Failed to commit at com.mendix.basis.component.TransactionCore.doCommit(TransactionCore.scala:164) 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: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.scala:30) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.basis.connectionbus.ConnectionBusException: Exception occurred while inserting data. (SQL State: 23503, Error Code: -177) Detail Message: org.hsqldb.HsqlException: integrity constraint violation: foreign key no parent ; "frn_expenses$teammember_profilepicture_expenses$profilepictureid" table: "expenses$teammember_profilepicture" value: 7599824371316450 at com.mendix.connectionbus.util.SqlExceptionUtils$.getDetailedException(SqlExceptionUtils.scala:18)
asked
Akshay Gajbhiye
1 answers
1
Did you change the association in your domain model from 1-* / *-* to 1-1? Is it happening on your local environment?
If it's happening local, I would suggest to clear your database, so you will start with new data. I think this will solve your problem. Stop your Mendix runtime. Go to 'App' in the topbar and select 'Show App Directory in Explorer'. Delete your deployment folder and run your app again.