+[

+  {

+    "name": "Application",

+    "filename": "observe-7.0.7.zip",

+    "url": "http://repo1.maven.org/maven2/fr/ird/observe/observe/7.0.7/observe-7.0.7.zip"

+  },

+  {

+    "name": "Serveur",

+    "filename": "observe-7.0.7.war",

+    "url": "http://repo1.maven.org/maven2/fr/ird/observe/observe/7.0.7/observe-7.0.7.war"

+  }

+]

+    "id": 20727608,

+    "iid": 1270,

+    "title": "[SYNCHRO SIMPLE] Une requête DELETE échoue pour cause de violation de contrainte FK",

+    "description": "Nous avons une base locale dans laquelle une espèce n\u0027existe plus dans le référentiel de la base centrale.\n\nCette espèce ayant été utilisée par l\u0027observateur, ObServe présente l\u0027UI de remplacement de code. On s\u0027exécute et le processus se déroulement correctement. La synchro du référentiel se termine sans erreur. A l\u0027issue de la synchro du référentiel toutefois, l\u0027espèce DYL (fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189) reste dans le référentiel de la base locale alors qu\u0027elle n\u0027existe pas dans la base centrale (est-ce normal ?)\n\nEnsuite, lors de l\u0027étape d\u0027envoi de la marée dans la base centrale, il semble que le système essaie d\u0027abord de supprimer cette espèce du référentiel local avant d\u0027envoyer la marée (qui ne l\u0027utilise plus suite au remplacement de code), mais cela échoue. Le message indique que l\u0027espèce est encore présente dans les associations espèces/océans :\n\nEspèce concernée : DYL / fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189\n\n```\nSauvegarde de la base locale vers C:\\Users\\pcauquil\\.observe\\backup\\obstuna-local-2019-05-09--13-46-42.sql.gz\nSauvegarde du référentiel.\norg.nuiton.topia.persistence.TopiaException: Could not execute sql code\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:168)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.legacy.UnidirectionalReferentialSynchronizeLocalServiceLocal.applySqlRequests(UnidirectionalReferentialSynchronizeLocalServiceLocal.java:158)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\n\tat java.lang.reflect.Method.invoke(Unknown Source)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethod(ObserveServiceFactoryLocal.java:242)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethodWithTransaction(ObserveServiceFactoryLocal.java:263)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invoke(ObserveServiceFactoryLocal.java:230)\n\tat com.sun.proxy.$Proxy75.applySqlRequests(Unknown Source)\n\tat fr.ird.observe.services.service.actions.synchro.referential.legacy.UnidirectionalReferentialSynchronizeEngine.finish(UnidirectionalReferentialSynchronizeEngine.java:159)\n\tat fr.ird.observe.client.ui.admin.save.SaveLocalUIHandler.saveUnidirectionalSynchronizeReferential(SaveLocalUIHandler.java:163)\n\tat fr.ird.observe.client.ui.admin.save.SaveLocalUIHandler.doAction(SaveLocalUIHandler.java:149)\n\tat org.nuiton.jaxx.runtime.swing.application.ActionWorker.doInBackground(ActionWorker.java:91)\n\tat javax.swing.SwingWorker$1.call(Unknown Source)\n\tat java.util.concurrent.FutureTask.run(Unknown Source)\n\tat javax.swing.SwingWorker.run(Unknown Source)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\n\tat java.lang.Thread.run(Unknown Source)\nCaused by: org.hibernate.exception.ConstraintViolationException: error executing work\n\tat org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)\n\tat org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:325)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2448)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2433)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:166)\n\t... 19 more\nCaused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: \"FK_OCEAN_SPECIES_SPECIES: OBSERVE_COMMON.OCEAN_SPECIES FOREIGN KEY(SPECIES) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) (\u0027fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189\u0027)\"; SQL statement:\nDELETE FROM OBSERVE_COMMON.species WHERE topiaId \u003d \u0027fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189\u0027;\n [23503-196]\n\tat org.h2.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:688)\n\tat com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)\n\tat com.zaxxer.hikari.pool.HikariProxyStatement.executeBatch(HikariProxyStatement.java)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.sql.ApplySqlRequestWork.flush(ApplySqlRequestWork.java:62)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.sql.ApplySqlRequestWork.execute(ApplySqlRequestWork.java:57)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport$HibernateTopiaSqlWork.execute(HibernateTopiaSqlSupport.java:91)\n\tat org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2429)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2426)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:320)\n\t... 22 more\n\norg.nuiton.topia.persistence.TopiaException: Could not execute sql code\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:168)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.legacy.UnidirectionalReferentialSynchronizeLocalServiceLocal.applySqlRequests(UnidirectionalReferentialSynchronizeLocalServiceLocal.java:158)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)\n\tat java.lang.reflect.Method.invoke(Unknown Source)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethod(ObserveServiceFactoryLocal.java:242)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invokeMethodWithTransaction(ObserveServiceFactoryLocal.java:263)\n\tat fr.ird.observe.services.local.ObserveServiceFactoryLocal$ObserveServiceInvocationHandler.invoke(ObserveServiceFactoryLocal.java:230)\n\tat com.sun.proxy.$Proxy75.applySqlRequests(Unknown Source)\n\tat fr.ird.observe.services.service.actions.synchro.referential.legacy.UnidirectionalReferentialSynchronizeEngine.finish(UnidirectionalReferentialSynchronizeEngine.java:159)\n\tat fr.ird.observe.client.ui.admin.save.SaveLocalUIHandler.saveUnidirectionalSynchronizeReferential(SaveLocalUIHandler.java:163)\n\tat fr.ird.observe.client.ui.admin.save.SaveLocalUIHandler.doAction(SaveLocalUIHandler.java:149)\n\tat org.nuiton.jaxx.runtime.swing.application.ActionWorker.doInBackground(ActionWorker.java:91)\n\tat javax.swing.SwingWorker$1.call(Unknown Source)\n\tat java.util.concurrent.FutureTask.run(Unknown Source)\n\tat javax.swing.SwingWorker.run(Unknown Source)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)\n\tat java.lang.Thread.run(Unknown Source)\nCaused by: org.hibernate.exception.ConstraintViolationException: error executing work\n\tat org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)\n\tat org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)\n\tat org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:325)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2448)\n\tat org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2433)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport.doSqlWork(HibernateTopiaSqlSupport.java:166)\n\t... 19 more\nCaused by: org.h2.jdbc.JdbcBatchUpdateException: Referential integrity constraint violation: \"FK_OCEAN_SPECIES_SPECIES: OBSERVE_COMMON.OCEAN_SPECIES FOREIGN KEY(SPECIES) REFERENCES OBSERVE_COMMON.SPECIES(TOPIAID) (\u0027fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189\u0027)\"; SQL statement:\nDELETE FROM OBSERVE_COMMON.species WHERE topiaId \u003d \u0027fr.ird.observe.entities.referentiel.Species#1551868196804#0.09929351272816189\u0027;\n [23503-196]\n\tat org.h2.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:688)\n\tat com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)\n\tat com.zaxxer.hikari.pool.HikariProxyStatement.executeBatch(HikariProxyStatement.java)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.sql.ApplySqlRequestWork.flush(ApplySqlRequestWork.java:62)\n\tat fr.ird.observe.services.local.service.actions.synchro.referential.sql.ApplySqlRequestWork.execute(ApplySqlRequestWork.java:57)\n\tat org.nuiton.topia.persistence.internal.support.HibernateTopiaSqlSupport$HibernateTopiaSqlWork.execute(HibernateTopiaSqlSupport.java:91)\n\tat org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2429)\n\tat org.hibernate.internal.SessionImpl$1.accept(SessionImpl.java:2426)\n\tat org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:320)\n\t... 22 more\n```\n\nIl semble donc que l\u0027application oublie de supprimer les associations espèce/océan avant de tenter de supprimer l\u0027espèce.\n\nLa base est celle-ci : [obstuna-local-2019-05-09--14-14-16-issue-species-DYL.sql.gz](/uploads/cc2236a31941ada3891b066ed0ef433e/obstuna-local-2019-05-09--14-14-16-issue-species-DYL.sql.gz)\n\nNote : Dans cette archive l\u0027espèce DYL n\u0027est plus utilisée par la marée, mais reste présente dans le référentiel, de même que son association à un océan.\n\nNote : Les espèces peuvent aussi être listées dans les tables suivantes :\n* OBSERVE_COMMON.OCEAN_SPECIES [cas vu ci-dessus]\n* OBSERVE_COMMON.SPECIES_SPECIESLIST\n* OBSERVE_COMMON.LENGTHLENGTHPARAMETER\n* OBSERVE_COMMON.LENGTHWEIGHTPARAMETER\nIl faut s\u0027assurer que le code gère bien le désenregistrement de l\u0027espèce dans toutes ces tables avant de supprimer l\u0027espèce elle-même.",

+    "labels": [

+      "Anomalie",

+      "Haut"

+    ],

+      "dueDate": "May 13, 2019 2:00:00 AM",

+      "state": "closed"

+        "_id": 166231,

+        "_username": "tchemit",

+        "_name": "Tony CHEMIT",

+        "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"

+      "_id": 166231,

+      "_username": "tchemit",

+      "_name": "Tony CHEMIT",

+      "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"

+    "confidential": true,

+    "discussionLocked": true,

+    "state": "closed",

+    "updatedAt": "May 13, 2019 5:36:15 PM",

+    "createdAt": "May 9, 2019 2:20:56 PM",

+    "closedAt": "May 13, 2019 2:26:10 PM",

+    "webUrl": "https://gitlab.com/ultreiaio/ird-observe/issues/1270"

+  "dueDate": "May 13, 2019 2:00:00 AM",

+  "state": "closed"

+[

+  {

+    "id": 20731753,

+    "iid": 1271,

+    "projectId": 2722779,

+    "title": "[SYNCHRO SIMPLE] Le référentiel SPECIESGROUP_SPECIESGROUPRELEASEMODE n\u0027est pas mis à jour",

+    "description": "Dans une base locale, en mode serveur embarqué, on supprime le contenu de la table OBSERVE_COMMON.SPECIESGROUP_SPECIESGROUPRELEASEMODE (les couples groupe d\u0027espèce/mode de libération disponible).\n\nOn réalise une synchro simple depuis un service web.\n\nLa table OBSERVE_COMMON.SPECIESGROUP_SPECIESGROUPRELEASEMODE reste vide.",

+    "labels": [

+      "Anomalie",

+      "Haut"

+    ],

+    "milestone": {

+      "id": 873393,

+      "iid": 141,

+      "projectId": 2722779,

+      "groupId": 0,

+      "title": "L.T.S 7.x",

+      "description": "This milestone should contains any feature or bug to fix in version 7.x",

+      "state": "active"

+    },

+    "assignees": [

+      {

+        "_id": 166231,

+        "_username": "tchemit",

+        "_name": "Tony CHEMIT",

+        "_state": "active",

+        "_external": false,

+        "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"

+      }

+    ],

+    "assignee": {

+      "_id": 166231,

+      "_username": "tchemit",

+      "_name": "Tony CHEMIT",

+      "_state": "active",

+      "_external": false,

+      "_avatarUrl": "https://secure.gravatar.com/avatar/2a915aa9a1df35c8b609ff2f750d5dac?s\u003d80\u0026d\u003didenticon"

+    },

+    "author": {

+      "_id": 1111318,

+      "_username": "pcauquil",

+      "_name": "Pascal Cauquil",

+      "_state": "active",

+      "_external": false,

+      "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"

+    },

+    "userNotesCount": 1,

+    "upVotes": 0,

+    "downVotes": 0,

+    "confidential": false,

+    "timeStats": {

+      "timeEstimate": 0,

+      "totalTimeSpent": 0

+    },

+    "state": "opened",

+    "updatedAt": "May 13, 2019 3:09:30 PM",

+    "createdAt": "May 9, 2019 4:06:41 PM",

+    "webUrl": "https://gitlab.com/ultreiaio/ird-observe/issues/1271"

+  },

+  {

+    "id": 20078138,

+    "iid": 1269,

+    "projectId": 2722779,

+    "title": "[TREE] Parfois un affichage tronqué sans raison",

+    "description": "Vu avec la v7.0.5 et v7.0.6 :\n\n![image](/uploads/0340bff3be051a10bfbbd47cbc312230/image.png)\n\n![image](/uploads/4c6f4de473bae2e152345b780d43fac6/image.png)",

+    "labels": [],

+    "milestone": {

+      "id": 873393,

+      "iid": 141,

+      "projectId": 2722779,

+      "groupId": 0,

+      "title": "L.T.S 7.x",

+      "description": "This milestone should contains any feature or bug to fix in version 7.x",

+      "state": "active"

+    },

+    "assignees": [

+      {

+        "_id": 1111318,

+        "_username": "pcauquil",

+        "_name": "Pascal Cauquil",

+        "_state": "active",

+        "_external": false,

+        "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"

+      }

+    ],

+    "assignee": {

+      "_id": 1111318,

+      "_username": "pcauquil",

+      "_name": "Pascal Cauquil",

+      "_state": "active",

+      "_external": false,

+      "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"

+    },

+    "author": {

+      "_id": 1111318,

+      "_username": "pcauquil",

+      "_name": "Pascal Cauquil",

+      "_state": "active",

+      "_external": false,

+      "_avatarUrl": "https://secure.gravatar.com/avatar/b4ae117bd93e10d96298fa4d885208ea?s\u003d80\u0026d\u003didenticon"

+    },

+    "userNotesCount": 2,

+    "upVotes": 0,

+    "downVotes": 0,

+    "confidential": false,

+    "timeStats": {

+      "timeEstimate": 0,

+      "totalTimeSpent": 0

+    },

+    "state": "opened",

+    "updatedAt": "May 13, 2019 3:10:22 PM",

+    "createdAt": "Apr 15, 2019 6:27:13 PM",

+    "webUrl": "https://gitlab.com/ultreiaio/ird-observe/issues/1269"

+  }

+]

+{

+  "id": 873393,

+  "iid": 141,

+  "projectId": 2722779,

+  "groupId": 0,

+  "title": "L.T.S 7.x",

+  "description": "This milestone should contains any feature or bug to fix in version 7.x",

+  "state": "active"

+}

+ * Last generated at 2019-05-14 00:13.

+## Version [7.0.7](https://gitlab.com/ultreiaio/ird-observe/milestones/140)

+

+**Closed at 2019-05-13.**

+

+### Download

+* [Application (observe-7.0.7.zip)](http://repo1.maven.org/maven2/fr/ird/observe/observe/7.0.7/observe-7.0.7.zip)

+* [Serveur (observe-7.0.7.war)](http://repo1.maven.org/maven2/fr/ird/observe/observe/7.0.7/observe-7.0.7.war)

+

+### Issues

+  * [[Anomalie 1270]](https://gitlab.com/ultreiaio/ird-observe/issues/1270) **[SYNCHRO SIMPLE] Une requête DELETE échoue pour cause de violation de contrainte FK** (Thanks to Tony CHEMIT) (Reported by Pascal Cauquil)

+