Bonjour,
J'ai aussi cette erreur, mais voici en cherchant une solution ce que j'ai decouvert:
EN VERSION MONOPOSTE:
Connection Compte "ILM informatique" tout ces modules fonctionne.... sans erreur (j'ai activé uniquement ceux qui m'interesse bien sûr)
Le fichier joint Capture mono.PNG n’est plus disponible.
Le fichier joint Capture mono 1.PNG n’est plus disponible.
Mais avec une autre entreprise c'est la que les problemes commence...
Le module "Tickets supports clients" ne veux pas s'installer....
Impossible d'appliquer les changements
java.lang.Exception: Couldn't install module org.openconcerto.modules.customersupport.Module created from JarModuleFactory org.openconcerto.modules.customersupport (1.0) from Modules\org.openconcerto.modules.customersupport-1.0.jar
org.openconcerto.utils.ExceptionHandler: Impossible d'appliquer les changements
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.erp.modules.AvailableModulesPanel$3.done(AvailableModulesPanel.java:148)
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:66)
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 created from JarModuleFactory org.openconcerto.modules.customersupport (1.0) from Modules\org.openconcerto.modules.customersupport-1.0.jar
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:130)
... 42 more
Caused by: java.lang.Exception: Couldn't install module org.openconcerto.modules.customersupport.Module created from JarModuleFactory org.openconcerto.modules.customersupport (1.0) from Modules\org.openconcerto.modules.customersupport-1.0.jar
at org.openconcerto.erp.modules.ModuleManager.installAndRegister(ModuleManager.java:1884)
at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1747)
at org.openconcerto.erp.modules.ModuleManager.applyChange(ModuleManager.java:1628)
at org.openconcerto.erp.modules.AvailableModulesPanel$3.doInBackground(AvailableModulesPanel.java:124)
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:1126)
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:1117)
at org.openconcerto.erp.modules.ModuleManager.installAndRegister(ModuleManager.java:1882)
... 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:1923)
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:1894)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1890)
at org.openconcerto.modules.customersupport.Module.install(Module.java:88)
... 19 more
Caused by: java.sql.SQLException: Unable to insert prep40: INSERT INTO "OpenConcerto"."OpenConcerto48"."COMPLETION" ("LABEL", "CHAMP") VALUES (?, ?) {1: 'En cours', 2: 'CUSTOMER_SUPPORT_TICKET.STATUS'}
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1911)
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:1901)
... 37 more
Caused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_FC ON ""OpenConcerto48"".COMPLETION(CHAMP, LABEL) VALUES ( /* key:10 */ 'CUSTOMER_SUPPORT_TICKET.STATUS', 'En cours')"; SQL statement:
INSERT INTO "OpenConcerto"."OpenConcerto48"."COMPLETION" ("LABEL", "CHAMP") VALUES (?, ?) [23505-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.java:101)
at org.h2.index.PageBtree.find(PageBtree.java:121)
at org.h2.index.PageBtreeLeaf.addRow(PageBtreeLeaf.java:148)
at org.h2.index.PageBtreeLeaf.addRowTry(PageBtreeLeaf.java:101)
at org.h2.index.PageBtreeIndex.addRow(PageBtreeIndex.java:96)
at org.h2.index.PageBtreeIndex.add(PageBtreeIndex.java:87)
at org.h2.table.RegularTable.addRow(RegularTable.java:119)
at org.h2.command.dml.Insert.insertRows(Insert.java:157)
at org.h2.command.dml.Insert.update(Insert.java:115)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:253)
at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:193)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:2376)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1906)
... 42 more
Le fichier joint Capture mono 1.PNG n’est plus disponible.
à plus tard...