Installations des modules impossible sur la version 1.6

Félix · sam. janv. 05, 2019 9:13 am

Bonjour à toutes et à tous !

Tout d'abord bonne année et meilleurs voeux !! Que 2019 nous réserve plein de bonnes surprises.

J'ai voulu faire la mise à jours d'Openconcerto 1.6 dans le magasin où je travaille, cependant depuis la mise à jour je n'arrive pas à installer les nouveaux modules et même à en désinstaller certains.
J'ai le message suivant :

Code : Tout sélectionner

Impossible d'appliquer les changements

java.lang.IllegalArgumentException: target state is REGISTERED but no graph was provided
org.openconcerto.utils.ExceptionHandler: Impossible d'appliquer les changements
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:135)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.done(AvailableModulesPanel.java:145)
	at javax.swing.SwingWorker$5.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
	at sun.swing.AccumulativeRunnable.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
	at javax.swing.Timer.fireActionPerformed(Unknown Source)
	at javax.swing.Timer$DoPostEvent.run(Unknown Source)
	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.WaitDispatchSupport$2.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(Unknown Source)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at org.openconcerto.erp.modules.AvailableModulesPanel$1.run(AvailableModulesPanel.java:65)
	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: target state is REGISTERED but no graph was provided
	at java.util.concurrent.FutureTask.report(Unknown Source)
	at java.util.concurrent.FutureTask.get(Unknown Source)
	at javax.swing.SwingWorker.get(Unknown Source)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.done(AvailableModulesPanel.java:127)
	... 42 more
Caused by: java.lang.IllegalArgumentException: target state is REGISTERED but no graph was provided
	at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1594)
	at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1518)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.doInBackground(AvailableModulesPanel.java:121)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.doInBackground(AvailableModulesPanel.java:1)
	at javax.swing.SwingWorker$1.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at javax.swing.SwingWorker.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

D'ailleurs ce n'est pas la première fois que je rencontre des soucis avec les modules suite aux mises à jour, y a t'il une procédure, un ordre à suivre pour remettre les modules à jours sans perdre les données ou sans avoir un message d'erreur ?

Merci d'avance.

Cordialement,
Félix.

mar. janv. 08, 2019 5:44 pm

Bonjour,

La procédure est simple pourtant : mettre les modules à jour dans le dossier "Modules" et lancer le logiciel...

Cordialement,

Félix · mer. janv. 09, 2019 3:23 pm

Bonjour Guillaume,

C'est ce que je fais... et je me retrouve quand même avec certaines erreurs...
Pour ce qui est de mon problème de ne pas pouvoir installer les modules ou même d'en désinstaller d'autres que l'on a essayé ?

mer. janv. 09, 2019 5:19 pm

Il nous faudrait un peu plus d'info, cad :
- la liste des modules (avec les versions) installés avant la 1.6
- la liste des fichiers dans votre dossier "modules"
- une capture d'écran de votre fenêtre de module dans OpenConcerto

Cordialement,

Félix · ven. janv. 11, 2019 9:58 am

Après un bon gros coup de nettoyage dans les modules installés juste pour essayer. Ça marche vachement mieux...
Par contre je n'arrive pas a remettre le module support client, j'ai l'erreur suivante :

Code : Tout sélectionner

Impossible d'appliquer les changements

java.lang.Exception: Couldn't install module org.openconcerto.modules.customersupport.Module@34059dd7
org.openconcerto.utils.ExceptionHandler: Impossible d'appliquer les changements
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:135)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.done(AvailableModulesPanel.java:145)
	at javax.swing.SwingWorker$5.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(Unknown Source)
	at sun.swing.AccumulativeRunnable.run(Unknown Source)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(Unknown Source)
	at javax.swing.Timer.fireActionPerformed(Unknown Source)
	at javax.swing.Timer$DoPostEvent.run(Unknown Source)
	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.WaitDispatchSupport$2.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.awt.WaitDispatchSupport$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.WaitDispatchSupport.enter(Unknown Source)
	at java.awt.Dialog.show(Unknown Source)
	at java.awt.Component.show(Unknown Source)
	at java.awt.Component.setVisible(Unknown Source)
	at java.awt.Window.setVisible(Unknown Source)
	at java.awt.Dialog.setVisible(Unknown Source)
	at org.openconcerto.erp.modules.AvailableModulesPanel$1.run(AvailableModulesPanel.java:65)
	at java.awt.event.InvocationEvent.dispatch(Unknown Source)
	at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$500(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Couldn't install module org.openconcerto.modules.customersupport.Module@34059dd7
	at java.util.concurrent.FutureTask.report(Unknown Source)
	at java.util.concurrent.FutureTask.get(Unknown Source)
	at javax.swing.SwingWorker.get(Unknown Source)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.done(AvailableModulesPanel.java:127)
	... 42 more
Caused by: java.lang.Exception: Couldn't install module org.openconcerto.modules.customersupport.Module@34059dd7
	at org.openconcerto.erp.modules.ModuleManager.installAndRegister(ModuleManager.java:1774)
	at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1637)
	at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1518)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.doInBackground(AvailableModulesPanel.java:121)
	at org.openconcerto.erp.modules.AvailableModulesPanel$3.doInBackground(AvailableModulesPanel.java:1)
	at javax.swing.SwingWorker$1.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at javax.swing.SwingWorker.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.IllegalStateException: erreur lors de l'ajout des status
	at org.openconcerto.modules.customersupport.Module.install(Module.java:101)
	at org.openconcerto.erp.modules.ModuleManager$6.handle(ModuleManager.java:1028)
	at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
	at org.openconcerto.erp.modules.ModuleManager.install(ModuleManager.java:1020)
	at org.openconcerto.erp.modules.ModuleManager.installAndRegister(ModuleManager.java:1772)
	... 10 more
Caused by: java.sql.SQLException: unable to insert SQLRowValues on /COMPLETION/ : {CHAMP=CUSTOMER_SUPPORT_TICKET.STATUS(class java.lang.String), LABEL=En cours(class java.lang.String)} using {LABEL=En cours, CHAMP=CUSTOMER_SUPPORT_TICKET.STATUS}
	at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1927)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Insert.execOn(SQLRowValuesCluster.java:1794)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1698)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1693)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Node.access$3(SQLRowValuesCluster.java:1692)
	at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:555)
	at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:1)
	at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:149)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:127)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:99)
	at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:522)
	at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:441)
	at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:436)
	at org.openconcerto.sql.model.SQLRowValues.store(SQLRowValues.java:1898)
	at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1894)
	at org.openconcerto.modules.customersupport.Module.install(Module.java:88)
	... 19 more
Caused by: java.sql.SQLException: Unable to insert INSERT INTO "OpenConcerto"."OpenConcerto48"."COMPLETION" ("LABEL", "CHAMP") VALUES ('En cours', 'CUSTOMER_SUPPORT_TICKET.STATUS')
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1915)
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:883)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:847)
	at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1905)
	... 37 more
Caused by: org.postgresql.util.PSQLException: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « COMPLETIONTMP_pkey »
  Détail : La clé « ("CHAMP", "LABEL")=(CUSTOMER_SUPPORT_TICKET.STATUS, En cours) » existe déjà.
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
	at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
	at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:2380)
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1910)
	... 42 more

Cordialement,
Félix.