Error when duplicating a record having a validation rule of unique
0
An administrator error is appearing when an attempt is made to duplicate a record that has the validation rule to be unique. Instead of displaying the text message warning that it must be unique, an administrator error appears. The button action is a save changes and the error is the following: Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: violación del restricción de integridad: violación de índice o clave única ; "uniq_dmm$productionprocesses_name" table: "dmm$productionprocesses" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: violación del restricción de integridad: violación de índice o clave única ; "uniq_dmm$productionprocesses_name" table: "dmm$productionprocesses" at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23) Caused by: com.mendix.systemwideinterfaces.connectionbus.data.UniqueConstraintViolationRuntimeException: Duplicate column value violates its unique constraint: violación del restricción de integridad: violación de índice o clave única ; "uniq_dmm$productionprocesses_name" table: "dmm$productionprocesses" (SQL State: 23505, Error Code: -104) Detail Message: org.hsqldb.HsqlException: violación del restricción de integridad: violación de índice o clave única ; "uniq_dmm$productionprocesses_name" table: "dmm$productionprocesses"
asked
Jorge Gómez
1 answers
0
Hi,
You will have to change your save action to a microflow save action and then place error handling on your commit action in the microflow so that you can catch the error and then display your message.