Modules compatibles avec la version 1.3 beta ?

Un conseil pour l'installation? Un problème technique pour installer OpenConcerto?
Répondre
Info_Pat
Messages : 22
Enregistré le : lun. mars 19, 2012 11:48 am

lun. déc. 24, 2012 8:12 am

Bonjour,

J'ai essayé d'installer les modules Prospects et Projets sur une version 1.3beta.
A chaque fois j'ai une erreur qui est générée.

Code : Tout sélectionner

mpossible d'installer les modules

java.sql.SQLException: unable to insert SQLRowValues on /FWK_MODULE_METADATA/ : {MODULE_VERSION=10000(class java.lang.Long), MODULE_NAME=org.openconcerto.modules.customerrelationship.lead(class java.lang.String), TABLE=LEAD(class java.lang.String), FIELD=EMAIL(class java.lang.String)} using {TABLE=LEAD, FIELD=EMAIL, MODULE_NAME=org.openconcerto.modules.customerrelationship.lead, MODULE_VERSION=10000}
org.openconcerto.utils.ExceptionHandler: Impossible d'installer les modules
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:86)
	at org.openconcerto.erp.modules.AvailableModulesPanel$InstallAction$1.done(AvailableModulesPanel.java:209)
	at javax.swing.SwingWorker$5.run(SwingWorker.java:717)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.run(SwingWorker.java:814)
	at sun.swing.AccumulativeRunnable.run(AccumulativeRunnable.java:95)
	at javax.swing.SwingWorker$DoSubmitAccumulativeRunnable.actionPerformed(SwingWorker.java:824)
	at javax.swing.Timer.fireActionPerformed(Timer.java:291)
	at javax.swing.Timer$DoPostEvent.run(Timer.java:221)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:702)
	at java.awt.EventQueue.access$400(EventQueue.java:82)
	at java.awt.EventQueue$2.run(EventQueue.java:663)
	at java.awt.EventQueue$2.run(EventQueue.java:661)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:672)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205)
	at java.awt.Dialog$1.run(Dialog.java:1044)
	at java.awt.Dialog$3.run(Dialog.java:1096)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.awt.Dialog.show(Dialog.java:1094)
	at java.awt.Component.show(Component.java:1591)
	at java.awt.Component.setVisible(Component.java:1543)
	at java.awt.Window.setVisible(Window.java:843)
	at java.awt.Dialog.setVisible(Dialog.java:984)
	at org.openconcerto.erp.modules.AvailableModulesPanel$1.run(AvailableModulesPanel.java:64)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:702)
	at java.awt.EventQueue.access$400(EventQueue.java:82)
	at java.awt.EventQueue$2.run(EventQueue.java:663)
	at java.awt.EventQueue$2.run(EventQueue.java:661)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:672)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.util.concurrent.ExecutionException: java.sql.SQLException: unable to insert SQLRowValues on /FWK_MODULE_METADATA/ : {MODULE_VERSION=10000(class java.lang.Long), MODULE_NAME=org.openconcerto.modules.customerrelationship.lead(class java.lang.String), TABLE=LEAD(class java.lang.String), FIELD=EMAIL(class java.lang.String)} using {TABLE=LEAD, FIELD=EMAIL, MODULE_NAME=org.openconcerto.modules.customerrelationship.lead, MODULE_VERSION=10000}
	at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
	at java.util.concurrent.FutureTask.get(FutureTask.java:83)
	at javax.swing.SwingWorker.get(SwingWorker.java:582)
	at org.openconcerto.erp.modules.AvailableModulesPanel$InstallAction$1.done(AvailableModulesPanel.java:203)
	... 40 more
Caused by: java.sql.SQLException: unable to insert SQLRowValues on /FWK_MODULE_METADATA/ : {MODULE_VERSION=10000(class java.lang.Long), MODULE_NAME=org.openconcerto.modules.customerrelationship.lead(class java.lang.String), TABLE=LEAD(class java.lang.String), FIELD=EMAIL(class java.lang.String)} using {TABLE=LEAD, FIELD=EMAIL, MODULE_NAME=org.openconcerto.modules.customerrelationship.lead, MODULE_VERSION=10000}
	at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1225)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Insert.execOn(SQLRowValuesCluster.java:1010)
	at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:926)
	at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:325)
	at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:1)
	at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:112)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:707)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:93)
	at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:295)
	at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:248)
	at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1195)
	at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1179)
	at org.openconcerto.erp.modules.ServerModuleManager.updateModuleFields(ServerModuleManager.java:174)
	at org.openconcerto.erp.modules.ModuleManager$5.handle(ModuleManager.java:626)
	at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:112)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:707)
	at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:93)
	at org.openconcerto.erp.modules.ModuleManager.installOnServer(ModuleManager.java:617)
	at org.openconcerto.erp.modules.ModuleManager.installModulesOnServer(ModuleManager.java:1343)
	at org.openconcerto.erp.modules.AvailableModulesPanel$InstallAction$1.doInBackground(AvailableModulesPanel.java:196)
	at javax.swing.SwingWorker$1.call(SwingWorker.java:277)
	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
	at javax.swing.SwingWorker.run(SwingWorker.java:316)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
	at java.lang.Thread.run(Thread.java:680)
Caused by: java.sql.SQLException: Unable to insert INSERT INTO "OpenConcerto"."OpenConcerto48"."FWK_MODULE_METADATA" ("TABLE", "FIELD", "MODULE_NAME", "MODULE_VERSION") VALUES ('LEAD', 'EMAIL', 'org.openconcerto.modules.customerrelationship.lead', '10000') RETURNING "ID"
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1213)
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1)
	at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
	at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:707)
	at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1203)
	... 28 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "FWK_MODULE_METADATA_uniqModule"
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
	at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1587)
	at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1208)
	... 32 more
Est ce lié à la nouvelle structure de la base de données ?

Salutations
Avatar du membre
guillaume
Messages : 2433
Enregistré le : ven. févr. 11, 2011 7:15 pm

lun. déc. 24, 2012 4:41 pm

Bonjour,

Tout est lié aux changements interne réalisés pour la 1.3.
Les modules à jour viendront avec la prochaine bêta.

Cordialement,
Directeur technique d'OpenConcerto qui dans son temps libre s'occupe du forum.
Pour une assistance pro, nous sommes joignables à ILM Informatique contre quelques jetons.
Pensez aussi à lire le manuel !
Info_Pat
Messages : 22
Enregistré le : lun. mars 19, 2012 11:48 am

lun. déc. 24, 2012 6:31 pm

Bonjour,

OK, merci

Bon Noël à tous
Répondre