J'ai eus plusieurs erreur m'indiquant que certaines de tables ne possédaient pas les bons droits d'accès (entre autre les tables FWK_.... et 4 ou 5 autres tables)
J'ai donc modifié les droits d'accès directement dans ma base.
Après de multiples essais de mise à jour de la base de donnée, je tombe finalement sur cette erreur :
Code : Tout sélectionner
chec de mise à jour
java.lang.IllegalStateException: /UNITE_VENTE/ is empty, can not infer UNDEFINED_ID
org.openconcerto.utils.ExceptionHandler: Echec de mise à jour
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:313)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: java.lang.IllegalStateException: /UNITE_VENTE/ is empty, can not infer UNDEFINED_ID
at org.openconcerto.erp.config.InstallationPanel$1$1$5.create(InstallationPanel.java:295)
at org.openconcerto.sql.utils.SQLUtils$1.handle(SQLUtils.java:80)
at org.openconcerto.sql.utils.SQLUtils$2.handle(SQLUtils.java:147)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:55)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:785)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:125)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:97)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:77)
at org.openconcerto.erp.config.InstallationPanel$1$1.run(InstallationPanel.java:286)
... 1 more
Caused by: java.lang.IllegalStateException: /UNITE_VENTE/ is empty, can not infer UNDEFINED_ID
at org.openconcerto.sql.model.SQLTable.findMinID(SQLTable.java:524)
at org.openconcerto.sql.model.SQLTable.fetchUndefID(SQLTable.java:501)
at org.openconcerto.sql.model.SQLTable.getUndefinedID(SQLTable.java:1215)
at org.openconcerto.sql.model.SQLTable.getUndefinedID(SQLTable.java:1209)
at org.openconcerto.sql.model.SQLTable.getUndefinedID(SQLTable.java:1181)
at org.openconcerto.sql.model.SQLSelect.getUndefWhere(SQLSelect.java:290)
at org.openconcerto.sql.model.SQLSelect.asString(SQLSelect.java:226)
at org.openconcerto.sql.changer.correct.CorrectOrder.noNulls(CorrectOrder.java:87)
at org.openconcerto.sql.changer.correct.CorrectOrder.changeImpl(CorrectOrder.java:61)
at org.openconcerto.sql.changer.correct.CorrectOrder.changeImpl(CorrectOrder.java:1)
at org.openconcerto.sql.changer.Changer.changeAll(Changer.java:115)
at org.openconcerto.sql.changer.Changer.change(Changer.java:100)
at org.openconcerto.erp.config.InstallationPanel.updateSocieteSchema(InstallationPanel.java:2831)
at org.openconcerto.erp.config.InstallationPanel.access$8(InstallationPanel.java:2823)
at org.openconcerto.erp.config.InstallationPanel$1$1$5.create(InstallationPanel.java:293)
... 9 more
Code : Tout sélectionner
Erreur de connexion
java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Couldn't add showAs for org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement "OpenConcerto"."OpenConcerto51"."STOCK" : null=[QTE_TH, QTE_REEL, QTE_LIV_ATTENTE, QTE_RECEPT_ATTENTE]
org.openconcerto.utils.ExceptionHandler: Erreur de connexion
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:257)
at org.openconcerto.sql.ui.ConnexionPanel.connect(ConnexionPanel.java:476)
at org.openconcerto.sql.ui.ConnexionPanel.access$4(ConnexionPanel.java:449)
at org.openconcerto.sql.ui.ConnexionPanel$7.run(ConnexionPanel.java:404)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalStateException: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Couldn't add showAs for org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement "OpenConcerto"."OpenConcerto51"."STOCK" : null=[QTE_TH, QTE_REEL, QTE_LIV_ATTENTE, QTE_RECEPT_ATTENTE]
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1046)
at org.openconcerto.sql.PropsConfiguration.getShowAs(PropsConfiguration.java:1073)
at org.openconcerto.erp.config.ComptaPropsConfiguration.setSocieteShowAs(ComptaPropsConfiguration.java:894)
at org.openconcerto.erp.config.ComptaPropsConfiguration.setUpSocieteDataBaseConnexion(ComptaPropsConfiguration.java:1024)
at org.openconcerto.erp.action.NouvelleConnexionAction$1.run(NouvelleConnexionAction.java:129)
... 4 more
Caused by: java.util.concurrent.ExecutionException: java.lang.IllegalStateException: Couldn't add showAs for org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement "OpenConcerto"."OpenConcerto51"."STOCK" : null=[QTE_TH, QTE_REEL, QTE_LIV_ATTENTE, QTE_RECEPT_ATTENTE]
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:188)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1042)
... 8 more
Caused by: java.lang.IllegalStateException: Couldn't add showAs for org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement "OpenConcerto"."OpenConcerto51"."STOCK" : null=[QTE_TH, QTE_REEL, QTE_LIV_ATTENTE, QTE_RECEPT_ATTENTE]
at org.openconcerto.sql.PropsConfiguration$1$1.elementAdded(PropsConfiguration.java:266)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:275)
at org.openconcerto.sql.PropsConfiguration$1.create(PropsConfiguration.java:1)
at org.openconcerto.sql.PropsConfiguration$Addable$1.call(PropsConfiguration.java:1022)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at org.openconcerto.sql.PropsConfiguration$Addable.get(PropsConfiguration.java:1040)
... 8 more
Caused by: java.lang.IllegalArgumentException: unknown field QTE_LIV_ATTENTE in STOCK. The table STOCK contains the followins fields: [ID, QTE_REEL, QTE_TH, ARCHIVE, ORDRE, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE]
at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:807)
at org.openconcerto.sql.ShowAs.namesToFields(ShowAs.java:112)
at org.openconcerto.sql.ShowAs.show(ShowAs.java:167)
at org.openconcerto.sql.PropsConfiguration$1$1.elementAdded(PropsConfiguration.java:262)
... 13 more
Merci pour votre réponse.
Bien cordialement
Ps: la version 1.3.2 fonctionne toujours correctement même avec les mises à jour de base de donnée.