erreur création fournisseur[RESOLU]

lodnexus · jeu. janv. 04, 2018 11:11 am

Bonjour,
je me retrouve face à une erreur lorsque que j'essai de créer un fournisseur via la liste fournisseur.

Erreur d'initialisation

unknown field ID_CATEGORIE_COMPTABLE in FOURNISSEUR. The table FOURNISSEUR contains the followins fields: [ID_FOURNISSEUR, TYPE, NOM, CODE, ID_ADRESSE, ID_ADRESSE_E, ARCHIVE, ORDRE, UE, ID_COMPTE_PCE, ID_MODE_REGLEMENT, TEL, FAX, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, ID_LANGUE, ID_DEVISE, RESPONSABLE, TEL_P, MAIL, INFOS, ID_COMPTE_PCE_CHARGE, ATTACHMENTS, NUMERO_TVA, SIRET]
org.openconcerto.utils.ExceptionHandler: Erreur d'initialisation
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:129)
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:134)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:211)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:141)
	at org.openconcerto.sql.view.EditFrame.<init>(EditFrame.java:97)
	at org.openconcerto.sql.view.EditFrame.<init>(EditFrame.java:79)
	at org.openconcerto.sql.view.IListPanel.getCreateFrame(IListPanel.java:607)
	at org.openconcerto.sql.view.IListPanel.handleAction(IListPanel.java:519)
	at org.openconcerto.sql.view.ListeAddPanel.handleAction(ListeAddPanel.java:65)
	at org.openconcerto.sql.view.IListPanel.actionPerformed(IListPanel.java:468)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(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.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.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.lang.IllegalArgumentException: unknown field ID_CATEGORIE_COMPTABLE in FOURNISSEUR. The table FOURNISSEUR contains the followins fields: [ID_FOURNISSEUR, TYPE, NOM, CODE, ID_ADRESSE, ID_ADRESSE_E, ARCHIVE, ORDRE, UE, ID_COMPTE_PCE, ID_MODE_REGLEMENT, TEL, FAX, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, ID_LANGUE, ID_DEVISE, RESPONSABLE, TEL_P, MAIL, INFOS, ID_COMPTE_PCE_CHARGE, ATTACHMENTS, NUMERO_TVA, SIRET]
	at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:953)
	at org.openconcerto.sql.element.BaseSQLComponent.getField(BaseSQLComponent.java:175)
	at org.openconcerto.sql.element.BaseSQLComponent.addView(BaseSQLComponent.java:275)
	at org.openconcerto.sql.element.BaseSQLComponent.addView(BaseSQLComponent.java:267)
	at org.openconcerto.erp.core.supplychain.supplier.component.FournisseurSQLComponent.addViews(FournisseurSQLComponent.java:390)
	at org.openconcerto.sql.element.SQLComponent.uiInit(SQLComponent.java:209)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:204)
	... 43 more

J'ai désinstaller puis réinstaller openconcerto 1.5.1.
version java (build 1.8.0_151-b12)
Merci de votre intérêt.

jeu. janv. 04, 2018 2:05 pm

Bonjour,

Merci de retélécharger la version 1.5.1, de l'installer et de mettre votre base de données à jour.

Cordialement,

lodnexus · jeu. janv. 04, 2018 4:46 pm

Bonsoir,
j'ai désinstallé proprement openconcerto, puis installé la version 1.5.1. J'ai migré mon fichier OpenConcerto.h2.db dans le nouveau dossier, puis mis à jour ma base de donnée.

Je trouve toujours la même erreur au moment de créer un fournisseur.

Code : Tout sélectionner

Erreur d'initialisation

unknown field ID_CATEGORIE_COMPTABLE in FOURNISSEUR. The table FOURNISSEUR contains the followins fields: [ID_FOURNISSEUR, TYPE, NOM, CODE, ID_ADRESSE, ID_ADRESSE_E, ARCHIVE, ORDRE, UE, ID_COMPTE_PCE, ID_MODE_REGLEMENT, TEL, FAX, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, ID_LANGUE, ID_DEVISE, RESPONSABLE, TEL_P, MAIL, INFOS, ID_COMPTE_PCE_CHARGE, ATTACHMENTS, NUMERO_TVA, SIRET]
org.openconcerto.utils.ExceptionHandler: Erreur d'initialisation
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:129)
	at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:134)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:211)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:141)
	at org.openconcerto.sql.view.EditFrame.<init>(EditFrame.java:97)
	at org.openconcerto.sql.view.EditFrame.<init>(EditFrame.java:79)
	at org.openconcerto.sql.view.IListPanel.getCreateFrame(IListPanel.java:607)
	at org.openconcerto.sql.view.IListPanel.handleAction(IListPanel.java:519)
	at org.openconcerto.sql.view.ListeAddPanel.handleAction(ListeAddPanel.java:65)
	at org.openconcerto.sql.view.IListPanel.actionPerformed(IListPanel.java:468)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(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.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.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.lang.IllegalArgumentException: unknown field ID_CATEGORIE_COMPTABLE in FOURNISSEUR. The table FOURNISSEUR contains the followins fields: [ID_FOURNISSEUR, TYPE, NOM, CODE, ID_ADRESSE, ID_ADRESSE_E, ARCHIVE, ORDRE, UE, ID_COMPTE_PCE, ID_MODE_REGLEMENT, TEL, FAX, MODIFICATION_DATE, ID_USER_COMMON_MODIFY, ID_USER_COMMON_CREATE, CREATION_DATE, ID_LANGUE, ID_DEVISE, RESPONSABLE, TEL_P, MAIL, INFOS, ID_COMPTE_PCE_CHARGE, ATTACHMENTS, NUMERO_TVA, SIRET]
	at org.openconcerto.sql.model.SQLTable.getField(SQLTable.java:953)
	at org.openconcerto.sql.element.BaseSQLComponent.getField(BaseSQLComponent.java:175)
	at org.openconcerto.sql.element.BaseSQLComponent.addView(BaseSQLComponent.java:275)
	at org.openconcerto.sql.element.BaseSQLComponent.addView(BaseSQLComponent.java:267)
	at org.openconcerto.erp.core.supplychain.supplier.component.FournisseurSQLComponent.addViews(FournisseurSQLComponent.java:390)
	at org.openconcerto.sql.element.SQLComponent.uiInit(SQLComponent.java:209)
	at org.openconcerto.sql.view.EditPanel.<init>(EditPanel.java:204)
	... 43 more

jeu. janv. 04, 2018 5:16 pm

Vous avez loupé l'étape "retélécharger la version 1.5.1".

Cordialement,

lodnexus · jeu. janv. 04, 2018 5:32 pm

Effectivement, quand je dis que les gens ne savent plus lire attentivement... je tombe en plein dedans.
Je fais ca.

lodnexus · jeu. janv. 04, 2018 5:54 pm

Après
- suppression et réinstallation propre
- lancement de l'exécuteur configuration.exe,
- test de la connexion à la base de donnée - qui a créé un fichier base de donnée
- fermer configuration.exe
- remplacer le fichier OpenConcerto.h2.db dans le dossier
C:\Users\NameUtilisateur\AppData\Roaming\OpenConcerto\Data\DBData\
- Mise à niveau de la base de donnée dans l'onglet installation de configuration.exe
- lancement de l'application

Ca fonctionne !

Merci de votre patience et de votre réactivité !