# Error Duplicate entry for key 'process\_content.PRIMARY'

**URL:** <https://community.ofelia.com/t/error-duplicate-entry-for-key-process-content-primary/11317>\
**Category:** Q&A\
**Created:** [19 August 2022 17:46 UTC](https://community.ofelia.com/t/error-duplicate-entry-for-key-process-content-primary/11317 "2022-08-19T17:46:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![remoncristian](https://avatars.discourse-cdn.com/v4/letter/r/65b543/32.png) [@remoncristian](https://community.ofelia.com/u/remoncristian)\
**Post date:** [19 August 2022 17:46 UTC](https://community.ofelia.com/t/error-duplicate-entry-for-key-process-content-primary/11317/1 "2022-08-19T17:46:26Z")

</div>

Hi

I have been trying to install or update a process on bonitasoft 7.10 community edition but i got this error message:

_ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Duplicate entry '1-2002' for key 'process\_content.PRIMARY'_

This is the log:

_022-08-16 08:48:11.944 -0300 WARN: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Error: 1062, SQLState: 23000  
2022-08-16 08:48:11.944 -0300 ERROR: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Duplicate entry '1-2002' for key 'process\_content.PRIMARY'  
2022-08-16 08:48:11.944 -0300 WARN: org.hibernate.engine.jdbc.spi.SqlExceptionHelper SQL Warning Code: 1062, SQLState: 23000  
2022-08-16 08:48:11.944 -0300 WARN: org.hibernate.engine.jdbc.spi.SqlExceptionHelper Duplicate entry '1-2002' for key 'process\_content.PRIMARY'  
2022-08-16 08:48:11.944 -0300 GRAVE: org.bonitasoft.engine.api.impl.resolver.BusinessArchiveArtifactsManager THREAD\_ID=47 | HOSTNAME=BONITA-BPM-WS | TENANT\_ID=1 | Unable to deploy process  
org.bonitasoft.engine.filter.UserFilterException: org.bonitasoft.engine.core.filter.exception.SUserFilterLoadingException: Unable to list the user filter implementations  
at org.bonitasoft.engine.api.impl.resolver.UserFilterBusinessArchiveArtifactManager.deploy(UserFilterBusinessArchiveArtifactManager.java:54)  
at org.bonitasoft.engine.api.impl.resolver.BusinessArchiveArtifactsManager.resolveDependencies(BusinessArchiveArtifactsManager.java:66)  
at org.bonitasoft.engine.bar.BusinessArchiveServiceImpl.deploy(BusinessArchiveServiceImpl.java:76)  
at org.bonitasoft.engine.api.impl.ProcessAPIImpl.deploy(ProcessAPIImpl.java:571)  
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)  
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)  
at java.lang.reflect.Method.invoke(Unknown Source)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:399)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.lambda$invokeAPIInTransaction$1(ServerAPIImpl.java:371)  
at org.bonitasoft.engine.transaction.JTATransactionServiceImpl.executeInTransaction(JTATransactionServiceImpl.java:274)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPIInTransaction(ServerAPIImpl.java:368)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeAPI(ServerAPIImpl.java:256)  
at org.bonitasoft.engine.api.impl.ServerAPIImpl.invokeMethod(ServerAPIImpl.java:120)  
at org.bonitasoft.engine.api.impl.ClientInterceptor.invoke(ClientInterceptor.java:82)  
at com.sun.proxy.$Proxy94.deploy(Unknown Source)  
at org.bonitasoft.web.rest.server.engineclient.ProcessEngineClient.deploy(ProcessEngineClient.java:79)  
at org.bonitasoft.web.rest.server.datastore.bpm.process.ProcessDatastore.add(ProcessDatastore.java:101)  
at org.bonitasoft.web.rest.server.api.bpm.process.APIProcess.add(APIProcess.java:73)  
at org.bonitasoft.web.rest.server.api.bpm.process.APIProcess.add(APIProcess.java:45)  
at org.bonitasoft.web.rest.server.framework.API.runAdd(API.java:150)  
at org.bonitasoft.web.rest.server.framework.APIServletCall.doPost(APIServletCall.java:204)  
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.doPost(ToolkitHttpServlet.java:213)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)  
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:76)  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)  
at org.bonitasoft.web.toolkit.server.servlet.ToolkitHttpServlet.service(ToolkitHttpServlet.java:251)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)  
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)  
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)  
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.filter.NoCacheFilter.doFilter(NoCacheFilter.java:51)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:728)  
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:470)  
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)  
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:316)  
at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213)  
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171)  
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)  
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)  
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.login.filter.AbstractAuthorizationFilter.doFilter(AbstractAuthorizationFilter.java:61)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.bonitasoft.console.common.server.filter.NoCacheFilter.doFilter(NoCacheFilter.java:51)  
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)  
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)  
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)  
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)  
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528)  
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)  
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)  
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)  
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)  
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)  
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)  
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:810)  
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)  
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)  
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)  
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)  
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)  
at java.lang.Thread.run(Unknown Source)  
Caused by: org.bonitasoft.engine.core.filter.exception.SUserFilterLoadingException: Unable to list the user filter implementations  
at org.bonitasoft.engine.core.filter.impl.UserFilterServiceImpl.loadUserFilters(UserFilterServiceImpl.java:254)  
at org.bonitasoft.engine.userfilter.UserFilterServiceDecorator.loadUserFilters(UserFilterServiceDecorator.java:73)  
at org.bonitasoft.engine.api.impl.resolver.UserFilterBusinessArchiveArtifactManager.deploy(UserFilterBusinessArchiveArtifactManager.java:52)  
... 79 more  
Caused by: org.bonitasoft.engine.persistence.SBonitaReadException: org.hibernate.exception.ConstraintViolationException: could not execute statement  
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:457)  
at org.bonitasoft.engine.resources.ProcessResourcesServiceImpl.get(ProcessResourcesServiceImpl.java:80)  
at org.bonitasoft.engine.core.filter.impl.UserFilterServiceImpl.loadUserFilters(UserFilterServiceImpl.java:230)  
... 81 more  
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement  
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)  
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)  
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)  
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)  
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)  
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)  
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)  
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)  
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)  
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)  
at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)  
at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227)  
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293)  
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)  
at org.bonitasoft.engine.persistence.AbstractHibernatePersistenceService.selectList(AbstractHibernatePersistenceService.java:448)  
... 83 more  
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1-2002' for key 'process\_content.PRIMARY'  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1057)  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1377)  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1042)  
at com.mysql.cj.jdbc.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:595)  
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)  
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)  
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)  
... 95 more_

&nbsp;

Can anyone help me please?

I did realize that the table process\_content has two columns on its primary key.

And theres is not duplicate key..

&nbsp;

Thanks

&nbsp;