Duplicate key value violation?!

1
I have a default datagrid with a default export to Excel button. Why do I get to following stacktrace when I press the button for exporting to excel. This happens to all default export to excel buttons. Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: An error has occurred while handling the request. [User 'MxAdmin' with roles 'MxAdmin, Beheerder'] Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (1/55) com.mendix.core.CoreException: Exception occurred in action '[CreateAction:: Context:Context::[Session [1a67ef80-f9be-42c6-91a8-7e12fb30335c]], objectType: +System.FileDocument]', all database changes executed by this action were rolled back Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (2/55) at com.mendix.core.actionmanagement.CoreAction.d(SourceFile:553) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (3/55) Caused by: com.mendix.core.CoreRuntimeException: af: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (4/55) at it.b(SourceFile:213) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (5/55) Caused by: af: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (6/55) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "system$filedocument_pkey" Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (7/55) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (8/55) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (9/55) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (10/55) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (11/55) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (12/55) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (13/55) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (14/55) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (15/55) at aA.a(SourceFile:767) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (16/55) at aA.a(SourceFile:707) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (17/55) at aA.a(SourceFile:616) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (18/55) at aA.a(SourceFile:564) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (19/55) at iB.a(SourceFile:61) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (20/55) at at.a(SourceFile:249) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (21/55) at at.a(SourceFile:233) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (22/55) at at.a(SourceFile:183) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (23/55) at at.a(SourceFile:101) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (24/55) at jC.a(SourceFile:96) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (25/55) at jm.a(SourceFile:241) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (26/55) at bY.a(SourceFile:81) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (27/55) at bY.executeAction(SourceFile:26) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (28/55) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (29/55) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (30/55) at it.b(SourceFile:209) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (31/55) at bS.a(SourceFile:113) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (32/55) at bS.executeAction(SourceFile:30) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (33/55) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (34/55) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (35/55) at it.b(SourceFile:155) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (36/55) at com.mendix.core.Core.create(SourceFile:512) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (37/55) at eq.b(SourceFile:208) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (38/55) at eq.a(SourceFile:111) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (39/55) at eq.execute(SourceFile:83) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (40/55) at ju.a(SourceFile:299) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (41/55) at ju.a(SourceFile:230) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (42/55) at ju.processRequest(SourceFile:174) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (43/55) at fF.a(SourceFile:71) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (44/55) at com.mendix.core.MxRuntime.processRequest(SourceFile:938) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (45/55) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (46/55) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (47/55) at org.eclipse.jetty.server.Server.handle(Server.java:334) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (48/55) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (49/55) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (50/55) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (51/55) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (52/55) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (53/55) at org.eclipse.jetty.server.nio.BlockingChannelConnector$ConnectorEndPoint.run(BlockingChannelConnector.java:187) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (54/55) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) Nov 29 12:23:15 127.0.0.1 dsiprod: ERROR - Connector: (55/55) at java.lang.Thread.run(Thread.java:662) At this point when I run a random microflow I get to following stacktrace: Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (1/84) com.mendix.core.CoreException: Exception occurred in microflow 'MigratieWalvis.Inlezen_Reg' for activity 'Create Aanvraag', all database changes executed by this microflow were rolled back Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (2/84) at kM.b(SourceFile:252) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (3/84) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: af: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (4/84) at it.b(SourceFile:167) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (5/84) Caused by: com.mendix.core.CoreRuntimeException: af: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (6/84) at it.b(SourceFile:213) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (7/84) Caused by: af: Exception occurred while inserting data. (SQL State: 23505, Error Code: 0) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (8/84) Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "taken$techeckenobject_pkey" Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (9/84) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (10/84) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (11/84) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (12/84) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (13/84) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (14/84) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (15/84) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (16/84) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (17/84) at aA.a(SourceFile:767) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (18/84) at aA.a(SourceFile:707) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (19/84) at aA.a(SourceFile:616) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (20/84) at aA.a(SourceFile:564) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (21/84) at iB.a(SourceFile:61) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (22/84) at at.a(SourceFile:249) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (23/84) at at.a(SourceFile:233) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (24/84) at at.a(SourceFile:183) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (25/84) at at.a(SourceFile:101) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (26/84) at jC.a(SourceFile:96) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (27/84) at jm.a(SourceFile:241) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (28/84) at bY.a(SourceFile:81) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (29/84) at bY.executeAction(SourceFile:26) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (30/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (31/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (32/84) at it.b(SourceFile:209) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (33/84) at bS.a(SourceFile:113) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (34/84) at bS.executeAction(SourceFile:30) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (35/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (36/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (37/84) at it.b(SourceFile:155) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (38/84) at com.mendix.core.Core.create(SourceFile:512) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (39/84) at lM.b(SourceFile:40) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (40/84) at lM.a(SourceFile:17) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (41/84) at kM.a(SourceFile:67) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (42/84) at eR.executeAction(SourceFile:96) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (43/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (44/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (45/84) at it.b(SourceFile:155) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (46/84) at com.mendix.core.Core.executeSync(SourceFile:167) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (47/84) at is.a(SourceFile:71) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (48/84) at kM.a(SourceFile:67) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (49/84) at eR.executeAction(SourceFile:96) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (50/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (51/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (52/84) at it.b(SourceFile:155) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (53/84) at com.mendix.core.Core.executeSync(SourceFile:167) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (54/84) at is.a(SourceFile:71) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (55/84) at kM.a(SourceFile:67) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (56/84) at eR.executeAction(SourceFile:96) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (57/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (58/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (59/84) at it.b(SourceFile:155) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (60/84) at com.mendix.core.Core.executeSync(SourceFile:167) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (61/84) at dK.a(SourceFile:68) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (62/84) at kM.a(SourceFile:67) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (63/84) at eR.executeAction(SourceFile:96) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (64/84) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (65/84) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:473) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (66/84) at it.b(SourceFile:155) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (67/84) at com.mendix.core.Core.execute(SourceFile:191) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (68/84) at dB.execute(SourceFile:183) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (69/84) at ju.a(SourceFile:299) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (70/84) at ju.a(SourceFile:230) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (71/84) at ju.processRequest(SourceFile:174) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (72/84) at fF.a(SourceFile:71) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (73/84) at com.mendix.core.MxRuntime.processRequest(SourceFile:938) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (74/84) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:42) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (75/84) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (76/84) at org.eclipse.jetty.server.Server.handle(Server.java:334) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (77/84) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (78/84) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (79/84) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (80/84) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (81/84) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (82/84) at org.eclipse.jetty.server.nio.BlockingChannelConnector$ConnectorEndPoint.run(BlockingChannelConnector.java:187) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (83/84) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) Nov 29 13:31:51 127.0.0.1 dsiprod: INFO - Reggen: (84/84) at java.lang.Thread.run(Thread.java:662) This isn't only happening at one project I got 2 projects with the same problem.
asked
0 answers