Odd Error Duplicate Column Values

0
I keep getting this error in my log in production environment: ------ May  5 11:32:51.975 - ERROR - Connector: An error has occurred while handling the request. [User 'user@domain.com' with session id '7bcbb92d-6dd3-4d6e-b3f7-f460c6912b29' and roles 'AdvanceSettlement, Advance'] May  5 11:32:51.983 - ERROR - Connector: (1/104) com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (2/104) #011at Catering.Btn_SaveMealRequest (Commit : 'Commit 'MealRequest' ') May  5 11:32:51.983 - ERROR - Connector: (3/104)  May  5 11:32:51.983 - ERROR - Connector: (4/104) Advanced stacktrace: May  5 11:32:51.983 - ERROR - Connector: (5/104) #011at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143) May  5 11:32:51.983 - ERROR - Connector: (6/104)  May  5 11:32:51.983 - ERROR - Connector: (7/104) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (8/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeInTransactionSync(ActionManager.java:145) May  5 11:32:51.983 - ERROR - Connector: (9/104)  May  5 11:32:51.983 - ERROR - Connector: (10/104) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (11/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) May  5 11:32:51.983 - ERROR - Connector: (12/104)  May  5 11:32:51.983 - ERROR - Connector: (13/104) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (14/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) May  5 11:32:51.983 - ERROR - Connector: (15/104)  May  5 11:32:51.983 - ERROR - Connector: (16/104) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (17/104) #011at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.java:43) May  5 11:32:51.983 - ERROR - Connector: (18/104)  May  5 11:32:51.983 - ERROR - Connector: (19/104) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (20/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) May  5 11:32:51.983 - ERROR - Connector: (21/104)  May  5 11:32:51.983 - ERROR - Connector: (22/104) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (23/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) May  5 11:32:51.983 - ERROR - Connector: (24/104)  May  5 11:32:51.983 - ERROR - Connector: (25/104) Caused by: com.mendix.datastorage.UniqueConstraintViolationException: Duplicate column value violates its unique constraint: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) May  5 11:32:51.983 - ERROR - Connector: (26/104) #011at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.getCorrectException(JdbcDataStore.java:1240) May  5 11:32:51.983 - ERROR - Connector: (27/104) #011at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.execCreateQueries(JdbcDataStore.java:552) May  5 11:32:51.983 - ERROR - Connector: (28/104) #011at com.mendix.connectionbus.connections.jdbc.JdbcDataStore.store(JdbcDataStore.java:501) May  5 11:32:51.983 - ERROR - Connector: (29/104) #011at com.mendix.connectionbus.store.EntityStorer.storeDataSetInstance(EntityStorer.java:250) May  5 11:32:51.983 - ERROR - Connector: (30/104) #011at com.mendix.connectionbus.store.EntityStorer.handleCreateRequest(EntityStorer.java:202) May  5 11:32:51.983 - ERROR - Connector: (31/104) #011at com.mendix.connectionbus.store.EntityStorer.handleRequest(EntityStorer.java:140) May  5 11:32:51.983 - ERROR - Connector: (32/104) #011at com.mendix.connectionbus.store.EntityStorer.store(EntityStorer.java:69) May  5 11:32:51.983 - ERROR - Connector: (33/104) #011at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:70) May  5 11:32:51.983 - ERROR - Connector: (34/104) #011at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:478) May  5 11:32:51.983 - ERROR - Connector: (35/104) #011at com.mendix.basis.action.user.CommitAction.commit(CommitAction.scala:75) May  5 11:32:51.983 - ERROR - Connector: (36/104) #011at com.mendix.basis.action.user.CommitAction.commitPersistableObjects(CommitAction.scala:65) May  5 11:32:51.983 - ERROR - Connector: (37/104) #011at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:44) May  5 11:32:51.983 - ERROR - Connector: (38/104) #011at com.mendix.basis.action.user.CommitAction.executeAction(CommitAction.scala:21) May  5 11:32:51.983 - ERROR - Connector: (39/104) #011at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50) May  5 11:32:51.983 - ERROR - Connector: (40/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73) May  5 11:32:51.983 - ERROR - Connector: (41/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53) May  5 11:32:51.983 - ERROR - Connector: (42/104) #011at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51) May  5 11:32:51.983 - ERROR - Connector: (43/104) #011at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170) May  5 11:32:51.983 - ERROR - Connector: (44/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) May  5 11:32:51.983 - ERROR - Connector: (45/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174) May  5 11:32:51.983 - ERROR - Connector: (46/104) #011at com.mendix.basis.actionmanagement.SyncEventExtendedAction.executeAction(SyncEventExtendedAction.java:41) May  5 11:32:51.983 - ERROR - Connector: (47/104) #011at com.mendix.basis.actionmanagement.EventExtendedAction.execute(EventExtendedAction.java:89) May  5 11:32:51.983 - ERROR - Connector: (48/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73) May  5 11:32:51.983 - ERROR - Connector: (49/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53) May  5 11:32:51.983 - ERROR - Connector: (50/104) #011at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51) May  5 11:32:51.983 - ERROR - Connector: (51/104) #011at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:172) May  5 11:32:51.983 - ERROR - Connector: (52/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) May  5 11:32:51.983 - ERROR - Connector: (53/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174) May  5 11:32:51.983 - ERROR - Connector: (54/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeInTransactionSync(ActionManager.java:138) May  5 11:32:51.983 - ERROR - Connector: (55/104) #011at com.mendix.basis.component.InternalCore.commit(InternalCore.java:303) May  5 11:32:51.983 - ERROR - Connector: (56/104) #011at com.mendix.basis.component.InternalCore.commit(InternalCore.java:188) May  5 11:32:51.983 - ERROR - Connector: (57/104) #011at com.mendix.basis.component.InternalCore.commit(InternalCore.java:157) May  5 11:32:51.983 - ERROR - Connector: (58/104) #011at com.mendix.modules.microflowengine.actions.mxobject.CommitAction.execute(CommitAction.scala:30) May  5 11:32:51.983 - ERROR - Connector: (59/104) #011at com.mendix.modules.microflowengine.actions.mxobject.CommitAction.execute(CommitAction.scala:15) May  5 11:32:51.983 - ERROR - Connector: (60/104) #011at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) May  5 11:32:51.983 - ERROR - Connector: (61/104) #011at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200) May  5 11:32:51.983 - ERROR - Connector: (62/104) #011at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157) May  5 11:32:51.983 - ERROR - Connector: (63/104) #011at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50) May  5 11:32:51.983 - ERROR - Connector: (64/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73) May  5 11:32:51.983 - ERROR - Connector: (65/104) #011at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53) May  5 11:32:51.983 - ERROR - Connector: (66/104) #011at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51) May  5 11:32:51.983 - ERROR - Connector: (67/104) #011at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170) May  5 11:32:51.983 - ERROR - Connector: (68/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) May  5 11:32:51.983 - ERROR - Connector: (69/104) #011at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174) May  5 11:32:51.983 - ERROR - Connector: (70/104) #011at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531) May  5 11:32:51.983 - ERROR - Connector: (71/104) #011at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:143) May  5 11:32:51.983 - ERROR - Connector: (72/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:307) May  5 11:32:51.983 - ERROR - Connector: (73/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293) May  5 11:32:51.983 - ERROR - Connector: (74/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293) May  5 11:32:51.983 - ERROR - Connector: (75/104) #011at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47) May  5 11:32:51.983 - ERROR - Connector: (76/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) May  5 11:32:51.983 - ERROR - Connector: (77/104) #011at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49) May  5 11:32:51.983 - ERROR - Connector: (78/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:408) May  5 11:32:51.983 - ERROR - Connector: (79/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:293) May  5 11:32:51.983 - ERROR - Connector: (80/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235) May  5 11:32:51.983 - ERROR - Connector: (81/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202) May  5 11:32:51.983 - ERROR - Connector: (82/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101) May  5 11:32:51.983 - ERROR - Connector: (83/104) #011at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93) May  5 11:32:51.983 - ERROR - Connector: (84/104) #011at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40) May  5 11:32:51.983 - ERROR - Connector: (85/104) #011at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70) May  5 11:32:51.983 - ERROR - Connector: (86/104) #011at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67) May  5 11:32:51.983 - ERROR - Connector: (87/104) #011at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33) May  5 11:32:51.983 - ERROR - Connector: (88/104) #011at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73) May  5 11:32:51.983 - ERROR - Connector: (89/104) #011at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:885) May  5 11:32:51.983 - ERROR - Connector: (90/104) #011at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41) May  5 11:32:51.983 - ERROR - Connector: (91/104) #011at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) May  5 11:32:51.983 - ERROR - Connector: (92/104) #011at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) May  5 11:32:51.983 - ERROR - Connector: (93/104) #011at org.eclipse.jetty.server.Server.handle(Server.java:368) May  5 11:32:51.983 - ERROR - Connector: (94/104) #011at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489) May  5 11:32:51.983 - ERROR - Connector: (95/104) #011at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953) May  5 11:32:51.983 - ERROR - Connector: (96/104) #011at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014) May  5 11:32:51.983 - ERROR - Connector: (97/104) #011at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861) May  5 11:32:51.983 - ERROR - Connector: (98/104) #011at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240) May  5 11:32:51.983 - ERROR - Connector: (99/104) #011at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) May  5 11:32:51.983 - ERROR - Connector: (100/104) #011at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628) May  5 11:32:51.983 - ERROR - Connector: (101/104) #011at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52) May  5 11:32:51.983 - ERROR - Connector: (102/104) #011at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) May  5 11:32:51.983 - ERROR - Connector: (103/104) #011at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) May  5 11:32:51.983 - ERROR - Connector: (104/104) #011at java.lang.Thread.run(Thread.java:745) -------- This entity has no AutoNumbers and has no validation rules on it at all.   Any ideas?
asked
1 answers
1

Jonathan,

As there are no unique validations in place, I assume there are no checks on a generalization involved as well.

Then the only unique violation I can think of is the id of the object. Maybe a database copy was restored incorrectly and the id sequence and id's in the object table are out of sync? Have a look at the tables in the database to check this.

answered