Problème création article

Répondre
paverneuil
Messages : 2
Enregistré le : jeu. oct. 31, 2019 2:47 pm

dim. mars 01, 2020 1:36 pm

Bonjour à tous,
Depuis 1 semaine je rencontre un problème lors de la création d'un article, voici le code erreur :

Erreur pendant l'ajout

can't update SQLRowValues on /ARTICLE/ : {ID_FAMILLE_ARTICLE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), CODE_BARRE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_UNITE_VENTE=2(class java.lang.Integer), SKU=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), QTE_UNITAIRE=1(class java.math.BigDecimal), ID_DEVISE_HA=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), PA_DEVISE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COUT_REVIENT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MARGE_WITH_COUT_REVIENT=false(class java.lang.Boolean), PA_HT=0(class java.math.BigDecimal), PV_HT=20(class java.math.BigDecimal), ID_TAXE=6(class java.lang.Integer), PV_TTC=20.00(class java.math.BigDecimal), CODE_DOUANIER=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_PAYS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_FOURNISSEUR=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), GESTION_STOCK=true(class java.lang.Boolean), ID_DEPOT_STOCK=2(class java.lang.Integer), QTE_ACHAT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), OBSOLETE=false(class java.lang.Boolean), DESCRIPTIF=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COMPTE_PCE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COMPTE_PCE_ACHAT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), IFCO=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), TARE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MASQUE_CAISSE=false(class java.lang.Boolean), INFOS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MATIERE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_ECO_CONTRIBUTION=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_TAXE_COMPLEMENTAIRE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), PRIX_METRIQUE_HA_1=0(class java.math.BigDecimal), PRIX_METRIQUE_VT_1=20(class java.math.BigDecimal), VALEUR_METRIQUE_1=1.0(class java.lang.Float), VALEUR_METRIQUE_2=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), VALEUR_METRIQUE_3=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_MODE_VENTE_ARTICLE=5(class java.lang.Integer), SERVICE=false(class java.lang.Boolean), NOM=test(class java.lang.String), CODE=test(class java.lang.String), POIDS=0.0(class java.lang.Float)} : the field ID_DEPOT_STOCK points to (DEPOT_STOCK[2])
org.openconcerto.utils.ExceptionHandler: Erreur pendant l'ajout
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:144)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:151)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:441)
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.AWTEventMulticaster.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.IllegalStateException: can't update SQLRowValues on /ARTICLE/ : {ID_FAMILLE_ARTICLE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), CODE_BARRE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_UNITE_VENTE=2(class java.lang.Integer), SKU=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), QTE_UNITAIRE=1(class java.math.BigDecimal), ID_DEVISE_HA=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), PA_DEVISE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COUT_REVIENT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MARGE_WITH_COUT_REVIENT=false(class java.lang.Boolean), PA_HT=0(class java.math.BigDecimal), PV_HT=20(class java.math.BigDecimal), ID_TAXE=6(class java.lang.Integer), PV_TTC=20.00(class java.math.BigDecimal), CODE_DOUANIER=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_PAYS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_FOURNISSEUR=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), GESTION_STOCK=true(class java.lang.Boolean), ID_DEPOT_STOCK=2(class java.lang.Integer), QTE_ACHAT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), OBSOLETE=false(class java.lang.Boolean), DESCRIPTIF=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COMPTE_PCE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_COMPTE_PCE_ACHAT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), IFCO=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), TARE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MASQUE_CAISSE=false(class java.lang.Boolean), INFOS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), MATIERE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_ECO_CONTRIBUTION=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_TAXE_COMPLEMENTAIRE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), PRIX_METRIQUE_HA_1=0(class java.math.BigDecimal), PRIX_METRIQUE_VT_1=20(class java.math.BigDecimal), VALEUR_METRIQUE_1=1.0(class java.lang.Float), VALEUR_METRIQUE_2=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), VALEUR_METRIQUE_3=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), ID_MODE_VENTE_ARTICLE=5(class java.lang.Integer), SERVICE=false(class java.lang.Boolean), NOM=test(class java.lang.String), CODE=test(class java.lang.String), POIDS=0.0(class java.lang.Float)} : the field ID_DEPOT_STOCK points to (DEPOT_STOCK[2])
at org.openconcerto.sql.model.SQLRowValues.checkValidity(SQLRowValues.java:1812)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:485)
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:1874)
at org.openconcerto.sql.request.SQLRowView.insert(SQLRowView.java:346)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:708)
at org.openconcerto.erp.core.sales.product.component.ReferenceArticleSQLComponent.insert(ReferenceArticleSQLComponent.java:1650)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:700)
at org.openconcerto.sql.view.EditPanel.ajouter(EditPanel.java:475)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:439)
... 37 more


Quelqu'un pourrait t'il m'éclairer ? A première vu, le problème semblerait venir d'une multi dépot, malheureusement même en désactivant le mode, et en redémarrant openconcerto, le problème reste
Bon dimanche
paverneuil
Messages : 2
Enregistré le : jeu. oct. 31, 2019 2:47 pm

mer. juin 24, 2020 8:46 am

Bonjour,
Mon problème n'étant pas résolu aurez-vous une solution à me proposer ?

Cordialement
Répondre