2020-10-16 15:31:51,039 [http-8] WARN org.openbravo.client.application.process.BaseProcessActionHandler - Process Copy Retail Store is marked as Grid Legacy, you should consider migrating it to prevent parameter conversion 2020-10-16 15:31:51,039 [http-8] INFO org.openbravo.client.application.process.BaseProcessActionHandler - There is no grid parameter in proces Copy Retail Store. No conversion is needed so Grid Legacy can be safelly unflagged. 2020-10-16 15:31:52,947 [http-8] ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch - HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 update AD_Sequence set Updated='2020-10-16 15:31:52.892+08', Name='702888 - 7iX', Description='702888 - 7iX', CurrentNext=1 where AD_Sequence_ID='263FA0D76D71496BA1358F11A235132E' was aborted: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. Call getNextException to see other errors in the batch.], SQL: update AD_Sequence set Updated=?, Name=?, Description=?, CurrentNext=? where AD_Sequence_ID=? 2020-10-16 15:31:52,947 [http-8] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Batch entry 0 update AD_Sequence set Updated='2020-10-16 15:31:52.892+08', Name='702888 - 7iX', Description='702888 - 7iX', CurrentNext=1 where AD_Sequence_ID='263FA0D76D71496BA1358F11A235132E' was aborted: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. Call getNextException to see other errors in the batch. 2020-10-16 15:31:52,947 [http-8] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. 2020-10-16 15:31:52,949 [http-8] ERROR org.openbravo.retail.copystore.process.CopyStoreProcess - Error in process javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1490) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1470) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.openbravo.dal.service.OBDal.flush(OBDal.java:265) ~[classes/:?] at org.openbravo.erpCommon.businessUtility.InitialSetupUtility.updateOrgTree(InitialSetupUtility.java:2137) ~[classes/:?] at org.openbravo.retail.copystore.process.CopyStoreProcess.setOrgInTree(CopyStoreProcess.java:971) [classes/:?] at org.openbravo.retail.copystore.process.CopyStoreProcess.execute(CopyStoreProcess.java:324) [classes/:?] at org.openbravo.retail.copystore.process.CopyActionHandler.executeProcess(CopyActionHandler.java:25) [classes/:?] at org.openbravo.retail.copystore.process.CopyBaseActionHandler.doExecute(CopyBaseActionHandler.java:125) [classes/:?] at org.openbravo.client.application.process.BaseProcessActionHandler.execute(BaseProcessActionHandler.java:150) [classes/:?] at org.openbravo.retail.copystore.process.CopyBaseActionHandler.execute(CopyBaseActionHandler.java:62) [classes/:?] at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:317) [classes/:?] at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:207) [classes/:?] at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:289) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [tomcat8-servlet-api.jar:?] at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:200) [openbravo-core.jar:?] at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:459) [classes/:?] at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89) [classes/:?] at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:60) [classes/:?] at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:169) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [tomcat8-servlet-api.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat8-websocket-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:69) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:38) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:65) [classes/:?] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?] at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:74) [classes/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:86) [classes/:?] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?] at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:108) [classes/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.1.jar:2.11.1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat8-coyote-8.5.39.jar:8.5.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat8-util-8.5.39.jar:8.5.39] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:129) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more Caused by: java.sql.BatchUpdateException: Batch entry 0 update AD_Sequence set Updated='2020-10-16 15:31:52.892+08', Name='702888 - 7iX', Description='702888 - 7iX', CurrentNext=1 where AD_Sequence_ID='263FA0D76D71496BA1358F11A235132E' was aborted: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. Call getNextException to see other errors in the batch. at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:145) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2179) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at jdk.internal.reflect.GeneratedMethodAccessor389.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) ~[tomcat-jdbc.jar:?] at com.sun.proxy.$Proxy61.executeBatch(Unknown Source) ~[?:?] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at jdk.internal.reflect.GeneratedMethodAccessor389.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) ~[tomcat-jdbc.jar:?] at com.sun.proxy.$Proxy61.executeBatch(Unknown Source) ~[?:?] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more 2020-10-16 15:31:52,951 [http-8] ERROR org.openbravo.retail.copystore.process.CopyStoreProcess - org.hibernate.exception.ConstraintViolationException: could not execute batch javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute batch at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1490) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1470) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.openbravo.dal.service.OBDal.flush(OBDal.java:265) ~[classes/:?] at org.openbravo.erpCommon.businessUtility.InitialSetupUtility.updateOrgTree(InitialSetupUtility.java:2137) ~[classes/:?] at org.openbravo.retail.copystore.process.CopyStoreProcess.setOrgInTree(CopyStoreProcess.java:971) [classes/:?] at org.openbravo.retail.copystore.process.CopyStoreProcess.execute(CopyStoreProcess.java:324) [classes/:?] at org.openbravo.retail.copystore.process.CopyActionHandler.executeProcess(CopyActionHandler.java:25) [classes/:?] at org.openbravo.retail.copystore.process.CopyBaseActionHandler.doExecute(CopyBaseActionHandler.java:125) [classes/:?] at org.openbravo.client.application.process.BaseProcessActionHandler.execute(BaseProcessActionHandler.java:150) [classes/:?] at org.openbravo.retail.copystore.process.CopyBaseActionHandler.execute(CopyBaseActionHandler.java:62) [classes/:?] at org.openbravo.client.kernel.KernelServlet.processActionRequest(KernelServlet.java:317) [classes/:?] at org.openbravo.client.kernel.KernelServlet.doGet(KernelServlet.java:207) [classes/:?] at org.openbravo.client.kernel.KernelServlet.doPost(KernelServlet.java:289) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [tomcat8-servlet-api.jar:?] at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:200) [openbravo-core.jar:?] at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:459) [classes/:?] at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89) [classes/:?] at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:60) [classes/:?] at org.openbravo.client.kernel.KernelServlet.service(KernelServlet.java:169) [classes/:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [tomcat8-servlet-api.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat8-websocket-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:69) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:38) [openbravo-core.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:65) [classes/:?] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?] at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:74) [classes/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:86) [classes/:?] at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:47) [classes/:?] at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:108) [classes/:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:71) [log4j-web-2.11.1.jar:2.11.1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat8-catalina-8.5.39.jar:8.5.39] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:476) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat8-coyote-8.5.39.jar:8.5.39] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat8-coyote-8.5.39.jar:8.5.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat8-util-8.5.39.jar:8.5.39] at java.lang.Thread.run(Thread.java:834) [?:?] Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:129) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more Caused by: java.sql.BatchUpdateException: Batch entry 0 update AD_Sequence set Updated='2020-10-16 15:31:52.892+08', Name='702888 - 7iX', Description='702888 - 7iX', CurrentNext=1 where AD_Sequence_ID='263FA0D76D71496BA1358F11A235132E' was aborted: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. Call getNextException to see other errors in the batch. at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:145) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2179) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at jdk.internal.reflect.GeneratedMethodAccessor389.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) ~[tomcat-jdbc.jar:?] at com.sun.proxy.$Proxy61.executeBatch(Unknown Source) ~[?:?] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_sequence_name" Detail: Key (ad_client_id, ad_org_id, name)=(4152461E06624BFE87610E237EA554EC, 3CC27E8583724063B29D02AA272D6E62, 702888 - 7iX) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) ~[postgresql-42.2.2.jre7.jar:42.2.2.jre7] at jdk.internal.reflect.GeneratedMethodAccessor389.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138) ~[tomcat-jdbc.jar:?] at com.sun.proxy.$Proxy61.executeBatch(Unknown Source) ~[?:?] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:105) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:201) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3302) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3238) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3640) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] ... 59 more 2020-10-16 15:31:52,976 [http-8] ERROR org.openbravo.retail.copystore.process.CopyStoreProcess - Error in copy store:There is already a Sequence with the same (Client, Organization, Name). (Client, Organization, Name) must be unique. You must change the values entered.