Ecrasement des "Activity data" à la création d'un process

Version=4.0.P24
BuiltOn=2020-08-20 13:07 (revision 0c0dabe53d5046d5e4d8bb9591ae1a8ef0359b09)

A la création d’une activité pour un Business process (Tuto W010) j’ai l’impression que les données de l’activité précédente sont écrasées.
Je les trouve dans bpm_date à la création de mon étape 1 (Créer client) et elles disparaissent à la création de mon étape 2 (Associer les intérêts)

Dans les logs je vois cette erreur

2020-08-20 16:02:35,710 ERROR [com.simplicite.util.ObjectDirect] SIMPLICITE|http://demo.simplicite.io:18308||ECORED0001|system|com.simplicite.util.ObjectDirect|save||Error BPMData
java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: BPM_DATA_UK
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
at com.simplicite.util.engine.DBAccess.update(DBAccess.java:1706)
at com.simplicite.util.engine.ObjectManager.create(ObjectManager.java:1860)
at com.simplicite.util.engine.ObjectManager.save(ObjectManager.java:2922)
at com.simplicite.util.ObjectDirect.save(ObjectDirect.java:441)
at com.simplicite.util.ObjectDB.save(ObjectDB.java:1135)
at com.simplicite.util.ObjectDB.save(ObjectDB.java:1122)
at com.simplicite.objects.Workflow.BPMActivity.createData(BPMActivity.java:223)
at com.simplicite.objects.Workflow.BPMActivity.templateData(BPMActivity.java:162)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at com.simplicite.util.engine.ObjectManager.invokeActionSync(ObjectManager.java:3734)
at com.simplicite.util.ObjectDirect.invokeAction(ObjectDirect.java:669)
at com.simplicite.util.ObjectDB.invokeAction(ObjectDB.java:1952)
at com.simplicite.util.ScriptedObjectDB.invokeAction(ScriptedObjectDB.java:1031)
at com.simplicite.util.ObjectDB.invokeAction(ObjectDB.java:1929)
at com.simplicite.util.ObjectDB.invokeAction(ObjectDB.java:1909)
at com.simplicite.workflows.WorkflowUser.CreateActivity.postValidate(CreateActivity.java:106)
at com.simplicite.util.engine.ProcessManager.validate(ProcessManager.java:440)
at com.simplicite.bpm.ProcessusDirect.validate(ProcessusDirect.java:277)
at com.simplicite.bpm.Processus.validate(Processus.java:280)
at com.simplicite.webapp.ProcessJson.validate(ProcessJson.java:389)
at com.simplicite.webapp.tools.JSONServletTool.businessProcessService(JSONServletTool.java:636)
at com.simplicite.webapp.servlets.AbstractJSONServlet.service(AbstractJSONServlet.java:72)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
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:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.simplicite.webapp.filters.AuthMethodFilter.doFilter(AuthMethodFilter.java:137)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.simplicite.webapp.filters.RewriteFilter.doFilter(RewriteFilter.java:77)
at com.simplicite.webapp.filters.AbstractFilter.doFilter(AbstractFilter.java:37)
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:188)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at com.simplicite.tomcat.valves.APISessionValve.invoke(APISessionValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:832)
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: BPM_DATA_UK
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.index.IndexAVL.insert(Unknown Source)
at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
at org.hsqldb.TransactionManagerMV2PL.addInsertAction(Unknown Source)
at org.hsqldb.Session.addInsertAction(Unknown Source)
at org.hsqldb.Table.insertSingleRow(Unknown Source)
at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
at org.hsqldb.StatementInsert.getResult(Unknown Source)
at org.hsqldb.StatementDMQL.execute(Unknown Source)
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)

Je ne sais pas si j’avais fait une mauvaise manip ou si il y a eu un correctif cette nuit mais je n’ai plus l’erreur ni le problème ce matin

La seule MAJ qui s’est installée cette nuit est celle qui concerne la valeur par défaut du user sur un param utilisateur. Cela n’a donc pas de lien avec le pb de processus que vous décrivez ici.

Ce pb de violation d’unique key sur BPMData ne me dit rien, j’ai sollicité les personnes en interne qui ont mis en place la formation et ça ne leur dit rien non plus.

On va essayer de reproduire.