Utilisant OP depuis plus 1 an, je suis passé à la version 1.4.2. Depuis, j'ai une erreur lors de la validation de certaines factures. Alors erreur de ma part dans la DB (H2), je ne sais pas, quand qu'il en soit, je n'arrive pas à m'en débarrassée.
La voici :
Code : Tout sélectionner
Unable to commit rows
unable to insert SQLRowValues on /SAISIE_VENTE_FACTURE_ELEMENT/ : {QTE=1(class java.lang.Integer), LIVREE=false(class java.lang.Boolean), CODE_MISSION=(class java.lang.String), ACOMPTE=false(class java.lang.Boolean), ACTIVITE=(class java.lang.String), T_PV_HT=3.291600(class java.math.BigDecimal), OBJET_INSPECTE=(class java.lang.String), INDICE_N=0(class java.lang.Long), INFOS_OBJET_INSPECTE=(class java.lang.String), ARCHIVE=0(class java.lang.Integer), NIVEAU=1(class java.lang.Integer), QTE_LIVREE=0(class java.lang.Integer), SERVICE=false(class java.lang.Boolean), PA_HT=0.000000(class java.math.BigDecimal), TARIF_Q18_HT=0.000000(class java.math.BigDecimal), VALEUR_METRIQUE_3=0.0(class java.lang.Float), POURCENT_SERVICE=(class java.lang.String), POURCENT_REMISE=0E-8(class java.math.BigDecimal), CREATION_DATE=2016-08-29 21:00:04.874(class java.sql.Timestamp), MARGE_HT=3.291600(class java.math.BigDecimal), ID_DEVISE=1(class java.lang.Integer), TAUX_DEVISE=1.00000000(class java.math.BigDecimal), ID_TAXE=3(class java.lang.Integer), NOM=Coquelets PAC(class java.lang.String), PRIX_METRIQUE_VT_1=6.330000(class java.math.BigDecimal), DATE=null, PV_U_DEVISE=null, POURCENT_ACOMPTE=100.00(class java.math.BigDecimal), T_POIDS_COLIS_NET=1.00000000(class java.math.BigDecimal), POIDS=0.0(class java.lang.Float), PRIX_METRIQUE_VT_3=0.000000(class java.math.BigDecimal), PRIX_METRIQUE_VT_2=0.000000(class java.math.BigDecimal), POURCENT_FACTURABLE=null, MODIFICATION_DATE=2016-08-29 21:00:04.874(class java.sql.Timestamp), Q18=false(class java.lang.Boolean), T_POIDS=0.0(class java.lang.Float), ID_UNITE_VENTE=7(class java.lang.Integer), CODE_DOUANIER=(class java.lang.String), REFERENTIEL_INSPECTION=(class java.lang.String), T_PA_HT=0.000000(class java.math.BigDecimal), ID_SAISIE_VENTE_FACTURE=2216(class java.lang.Integer), SOUS_ACTIVITE=(class java.lang.String), MONTANT_REVISABLE=false(class java.lang.Boolean), REPARTITION_POURCENT=0.00(class java.math.BigDecimal), POIDS_COLIS_NET=1.00000000(class java.math.BigDecimal), POURCENT_CCIP=...(class java.lang.String), ID_TICKET_CAISSE=1(class java.lang.Integer), ORDRE=4089.00000000(class java.math.BigDecimal), PRIX_METRIQUE_HA_3=0.000000(class java.math.BigDecimal), MONTANT_INITIAL=0.000000(class java.math.BigDecimal), DATE_FIN=null, PRIX_METRIQUE_HA_2=0.000000(class java.math.BigDecimal), PRIX_METRIQUE_HA_1=0.000000(class java.math.BigDecimal), ID_FAMILLE_ARTICLE=11(class java.lang.Integer), QTE_UNITAIRE=0.52(class java.math.BigDecimal), NB_COLIS=0(class java.lang.Integer), VALEUR_METRIQUE_1=1.0(class java.lang.Float), VALEUR_METRIQUE_2=0.0(class java.lang.Float), ID_STYLE=2(class java.lang.Integer), NOM_MISSION=(class java.lang.String), ID_USER_COMMON_CREATE=2(class java.lang.Integer), ID_METRIQUE_1=1(class java.lang.Integer), ID_ARTICLE=20(class java.lang.Integer), ID_METRIQUE_2=1(class java.lang.Integer), ID_METRIQUE_3=1(class java.lang.Integer), DESCRIPTIF=1(class java.lang.String), PV_HT=6.330000(class java.math.BigDecimal), ID_MODE_VENTE_ARTICLE=5(class java.lang.Integer), T_PV_TTC=3.47(class java.math.BigDecimal), ID_CONTACT=1(class java.lang.Integer), CODE=PAC Coquelets(class java.lang.String), SITUATION_ADMIN=(class java.lang.String), PV_T_DEVISE=0.000000(class java.math.BigDecimal), INDICE_0=0(class java.lang.Long), LOCAL_OBJET_INSPECTE=(class java.lang.String), ID_USER_COMMON_MODIFY=2(class java.lang.Integer), QTE_ACHAT=1(class java.lang.Integer), MONTANT_FACTURABLE=null, MONTANT_REMISE=null, ID_PAYS=1(class java.lang.Integer)} using {QTE=1, LIVREE=false, CODE_MISSION=, ACOMPTE=false, ACTIVITE=, T_PV_HT=3.291600, OBJET_INSPECTE=, INDICE_N=0, INFOS_OBJET_INSPECTE=, ARCHIVE=0, NIVEAU=1, QTE_LIVREE=0, SERVICE=false, PA_HT=0.000000, TARIF_Q18_HT=0.000000, VALEUR_METRIQUE_3=0.0, POURCENT_SERVICE=, POURCENT_REMISE=0E-8, CREATION_DATE=2016-08-29 21:00:04.874, MARGE_HT=3.291600, ID_DEVISE=1, TAUX_DEVISE=1.00000000, ID_TAXE=3, NOM=Coquelets PAC, PRIX_METRIQUE_VT_1=6.330000, DATE=null, PV_U_DEVISE=null, POURCENT_ACOMPTE=100.00, T_POIDS_COLIS_NET=1.00000000, POIDS=0.0, PRIX_METRIQUE_VT_3=0.000000, PRIX_METRIQUE_VT_2=0.000000, POURCENT_FACTURABLE=null, MODIFICATION_DATE=2016-08-29 21:00:04.874, Q18=false, T_POIDS=0.0, ID_UNITE_VENTE=7, CODE_DOUANIER=, REFERENTIEL_INSPECTION=, T_PA_HT=0.000000, ID_SAISIE_VENTE_FACTURE=2216, SOUS_ACTIVITE=, MONTANT_REVISABLE=false, REPARTITION_POURCENT=0.00, POIDS_COLIS_NET=1.00000000, POURCENT_CCIP=..., ID_TICKET_CAISSE=1, ORDRE=4089.00000000, PRIX_METRIQUE_HA_3=0.000000, MONTANT_INITIAL=0.000000, DATE_FIN=null, PRIX_METRIQUE_HA_2=0.000000, PRIX_METRIQUE_HA_1=0.000000, ID_FAMILLE_ARTICLE=11, QTE_UNITAIRE=0.52, NB_COLIS=0, VALEUR_METRIQUE_1=1.0, VALEUR_METRIQUE_2=0.0, ID_STYLE=2, NOM_MISSION=, ID_USER_COMMON_CREATE=2, ID_METRIQUE_1=1, ID_ARTICLE=20, ID_METRIQUE_2=1, ID_METRIQUE_3=1, DESCRIPTIF=1, PV_HT=6.330000, ID_MODE_VENTE_ARTICLE=5, T_PV_TTC=3.47, ID_CONTACT=1, CODE=PAC Coquelets, SITUATION_ADMIN=, PV_T_DEVISE=0.000000, INDICE_0=0, LOCAL_OBJET_INSPECTE=, ID_USER_COMMON_MODIFY=2, QTE_ACHAT=1, MONTANT_FACTURABLE=null, MONTANT_REMISE=null, ID_PAYS=1}
org.openconcerto.utils.ExceptionHandler: Unable to commit rows
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:112)
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:116)
at org.openconcerto.sql.view.list.RowValuesTableModel.commitData(RowValuesTableModel.java:307)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:532)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:547)
at org.openconcerto.sql.view.list.RowValuesTableModel.updateField(RowValuesTableModel.java:542)
at org.openconcerto.sql.view.list.RowValuesTable.updateField(RowValuesTable.java:234)
at org.openconcerto.erp.core.common.ui.AbstractArticleItemTable.updateField(AbstractArticleItemTable.java:157)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.commit(SaisieVenteFactureSQLComponent.java:1293)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.insert(SaisieVenteFactureSQLComponent.java:1100)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:680)
at org.openconcerto.sql.view.EditPanel.ajouter(EditPanel.java:474)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:438)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
at java.awt.Component.processMouseEvent(Component.java:6535)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6300)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4891)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.sql.SQLException: unable to insert SQLRowValues on /SAISIE_VENTE_FACTURE_ELEMENT/ : {QTE=1(class java.lang.Integer), LIVREE=false(class java.lang.Boolean), CODE_MISSION=(class java.lang.String), ACOMPTE=false(class java.lang.Boolean), ACTIVITE=(class java.lang.String), T_PV_HT=3.291600(class java.math.BigDecimal), OBJET_INSPECTE=(class java.lang.String), INDICE_N=0(class java.lang.Long), INFOS_OBJET_INSPECTE=(class java.lang.String), ARCHIVE=0(class java.lang.Integer), NIVEAU=1(class java.lang.Integer), QTE_LIVREE=0(class java.lang.Integer), SERVICE=false(class java.lang.Boolean), PA_HT=0.000000(class java.math.BigDecimal), TARIF_Q18_HT=0.000000(class java.math.BigDecimal), VALEUR_METRIQUE_3=0.0(class java.lang.Float), POURCENT_SERVICE=(class java.lang.String), POURCENT_REMISE=0E-8(class java.math.BigDecimal), CREATION_DATE=2016-08-29 21:00:04.874(class java.sql.Timestamp), MARGE_HT=3.291600(class java.math.BigDecimal), ID_DEVISE=1(class java.lang.Integer), TAUX_DEVISE=1.00000000(class java.math.BigDecimal), ID_TAXE=3(class java.lang.Integer), NOM=Coquelets PAC(class java.lang.String), PRIX_METRIQUE_VT_1=6.330000(class java.math.BigDecimal), DATE=null, PV_U_DEVISE=null, POURCENT_ACOMPTE=100.00(class java.math.BigDecimal), T_POIDS_COLIS_NET=1.00000000(class java.math.BigDecimal), POIDS=0.0(class java.lang.Float), PRIX_METRIQUE_VT_3=0.000000(class java.math.BigDecimal), PRIX_METRIQUE_VT_2=0.000000(class java.math.BigDecimal), POURCENT_FACTURABLE=null, MODIFICATION_DATE=2016-08-29 21:00:04.874(class java.sql.Timestamp), Q18=false(class java.lang.Boolean), T_POIDS=0.0(class java.lang.Float), ID_UNITE_VENTE=7(class java.lang.Integer), CODE_DOUANIER=(class java.lang.String), REFERENTIEL_INSPECTION=(class java.lang.String), T_PA_HT=0.000000(class java.math.BigDecimal), ID_SAISIE_VENTE_FACTURE=2216(class java.lang.Integer), SOUS_ACTIVITE=(class java.lang.String), MONTANT_REVISABLE=false(class java.lang.Boolean), REPARTITION_POURCENT=0.00(class java.math.BigDecimal), POIDS_COLIS_NET=1.00000000(class java.math.BigDecimal), POURCENT_CCIP=...(class java.lang.String), ID_TICKET_CAISSE=1(class java.lang.Integer), ORDRE=4089.00000000(class java.math.BigDecimal), PRIX_METRIQUE_HA_3=0.000000(class java.math.BigDecimal), MONTANT_INITIAL=0.000000(class java.math.BigDecimal), DATE_FIN=null, PRIX_METRIQUE_HA_2=0.000000(class java.math.BigDecimal), PRIX_METRIQUE_HA_1=0.000000(class java.math.BigDecimal), ID_FAMILLE_ARTICLE=11(class java.lang.Integer), QTE_UNITAIRE=0.52(class java.math.BigDecimal), NB_COLIS=0(class java.lang.Integer), VALEUR_METRIQUE_1=1.0(class java.lang.Float), VALEUR_METRIQUE_2=0.0(class java.lang.Float), ID_STYLE=2(class java.lang.Integer), NOM_MISSION=(class java.lang.String), ID_USER_COMMON_CREATE=2(class java.lang.Integer), ID_METRIQUE_1=1(class java.lang.Integer), ID_ARTICLE=20(class java.lang.Integer), ID_METRIQUE_2=1(class java.lang.Integer), ID_METRIQUE_3=1(class java.lang.Integer), DESCRIPTIF=1(class java.lang.String), PV_HT=6.330000(class java.math.BigDecimal), ID_MODE_VENTE_ARTICLE=5(class java.lang.Integer), T_PV_TTC=3.47(class java.math.BigDecimal), ID_CONTACT=1(class java.lang.Integer), CODE=PAC Coquelets(class java.lang.String), SITUATION_ADMIN=(class java.lang.String), PV_T_DEVISE=0.000000(class java.math.BigDecimal), INDICE_0=0(class java.lang.Long), LOCAL_OBJET_INSPECTE=(class java.lang.String), ID_USER_COMMON_MODIFY=2(class java.lang.Integer), QTE_ACHAT=1(class java.lang.Integer), MONTANT_FACTURABLE=null, MONTANT_REMISE=null, ID_PAYS=1(class java.lang.Integer)} using {QTE=1, LIVREE=false, CODE_MISSION=, ACOMPTE=false, ACTIVITE=, T_PV_HT=3.291600, OBJET_INSPECTE=, INDICE_N=0, INFOS_OBJET_INSPECTE=, ARCHIVE=0, NIVEAU=1, QTE_LIVREE=0, SERVICE=false, PA_HT=0.000000, TARIF_Q18_HT=0.000000, VALEUR_METRIQUE_3=0.0, POURCENT_SERVICE=, POURCENT_REMISE=0E-8, CREATION_DATE=2016-08-29 21:00:04.874, MARGE_HT=3.291600, ID_DEVISE=1, TAUX_DEVISE=1.00000000, ID_TAXE=3, NOM=Coquelets PAC, PRIX_METRIQUE_VT_1=6.330000, DATE=null, PV_U_DEVISE=null, POURCENT_ACOMPTE=100.00, T_POIDS_COLIS_NET=1.00000000, POIDS=0.0, PRIX_METRIQUE_VT_3=0.000000, PRIX_METRIQUE_VT_2=0.000000, POURCENT_FACTURABLE=null, MODIFICATION_DATE=2016-08-29 21:00:04.874, Q18=false, T_POIDS=0.0, ID_UNITE_VENTE=7, CODE_DOUANIER=, REFERENTIEL_INSPECTION=, T_PA_HT=0.000000, ID_SAISIE_VENTE_FACTURE=2216, SOUS_ACTIVITE=, MONTANT_REVISABLE=false, REPARTITION_POURCENT=0.00, POIDS_COLIS_NET=1.00000000, POURCENT_CCIP=..., ID_TICKET_CAISSE=1, ORDRE=4089.00000000, PRIX_METRIQUE_HA_3=0.000000, MONTANT_INITIAL=0.000000, DATE_FIN=null, PRIX_METRIQUE_HA_2=0.000000, PRIX_METRIQUE_HA_1=0.000000, ID_FAMILLE_ARTICLE=11, QTE_UNITAIRE=0.52, NB_COLIS=0, VALEUR_METRIQUE_1=1.0, VALEUR_METRIQUE_2=0.0, ID_STYLE=2, NOM_MISSION=, ID_USER_COMMON_CREATE=2, ID_METRIQUE_1=1, ID_ARTICLE=20, ID_METRIQUE_2=1, ID_METRIQUE_3=1, DESCRIPTIF=1, PV_HT=6.330000, ID_MODE_VENTE_ARTICLE=5, T_PV_TTC=3.47, ID_CONTACT=1, CODE=PAC Coquelets, SITUATION_ADMIN=, PV_T_DEVISE=0.000000, INDICE_0=0, LOCAL_OBJET_INSPECTE=, ID_USER_COMMON_MODIFY=2, QTE_ACHAT=1, MONTANT_FACTURABLE=null, MONTANT_REMISE=null, ID_PAYS=1}
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1758)
at org.openconcerto.sql.model.SQLRowValues.commitJustThis(SQLRowValues.java:1837)
at org.openconcerto.sql.model.SQLRowValuesCluster$Commit.execOn(SQLRowValuesCluster.java:1468)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1373)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.access$3(SQLRowValuesCluster.java:1371)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:450)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:1)
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:844)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:812)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:125)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:417)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:367)
at org.openconcerto.sql.model.SQLRowValues.commit(SQLRowValues.java:1832)
at org.openconcerto.sql.view.list.RowValuesTableModel.commitData(RowValuesTableModel.java:303)
... 47 more
Caused by: java.sql.SQLException: Unable to insert prep292: INSERT INTO "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT" ("QTE", "LIVREE", "CODE_MISSION", "ACOMPTE", "ACTIVITE", "T_PV_HT", "OBJET_INSPECTE", "INDICE_N", "INFOS_OBJET_INSPECTE", "ARCHIVE", "NIVEAU", "QTE_LIVREE", "SERVICE", "PA_HT", "TARIF_Q18_HT", "VALEUR_METRIQUE_3", "POURCENT_SERVICE", "POURCENT_REMISE", "CREATION_DATE", "MARGE_HT", "ID_DEVISE", "TAUX_DEVISE", "ID_TAXE", "NOM", "PRIX_METRIQUE_VT_1", "DATE", "PV_U_DEVISE", "POURCENT_ACOMPTE", "T_POIDS_COLIS_NET", "POIDS", "PRIX_METRIQUE_VT_3", "PRIX_METRIQUE_VT_2", "POURCENT_FACTURABLE", "MODIFICATION_DATE", "Q18", "T_POIDS", "ID_UNITE_VENTE", "CODE_DOUANIER", "REFERENTIEL_INSPECTION", "T_PA_HT", "ID_SAISIE_VENTE_FACTURE", "SOUS_ACTIVITE", "MONTANT_REVISABLE", "REPARTITION_POURCENT", "POIDS_COLIS_NET", "POURCENT_CCIP", "ID_TICKET_CAISSE", "ORDRE", "PRIX_METRIQUE_HA_3", "MONTANT_INITIAL", "DATE_FIN", "PRIX_METRIQUE_HA_2", "PRIX_METRIQUE_HA_1", "ID_FAMILLE_ARTICLE", "QTE_UNITAIRE", "NB_COLIS", "VALEUR_METRIQUE_1", "VALEUR_METRIQUE_2", "ID_STYLE", "NOM_MISSION", "ID_USER_COMMON_CREATE", "ID_METRIQUE_1", "ID_ARTICLE", "ID_METRIQUE_2", "ID_METRIQUE_3", "DESCRIPTIF", "PV_HT", "ID_MODE_VENTE_ARTICLE", "T_PV_TTC", "ID_CONTACT", "CODE", "SITUATION_ADMIN", "PV_T_DEVISE", "INDICE_0", "LOCAL_OBJET_INSPECTE", "ID_USER_COMMON_MODIFY", "QTE_ACHAT", "MONTANT_FACTURABLE", "MONTANT_REMISE", "ID_PAYS") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) {1: 1, 2: FALSE, 3: '', 4: FALSE, 5: '', 6: 3.291600, 7: '', 8: 0, 9: '', 10: 0, 11: 1, 12: 0, 13: FALSE, 14: 0.000000, 15: 0.000000, 16: 0.0, 17: '', 18: 0.00000000, 19: TIMESTAMP '2016-09-05 21:01:09.151', 20: 3.291600, 21: 1, 22: 1.00000000, 23: 3, 24: 'Coquelets PAC', 25: 6.330000, 26: NULL, 27: NULL, 28: 100.00, 29: 1.00000000, 30: 0.0, 31: 0.000000, 32: 0.000000, 33: NULL, 34: TIMESTAMP '2016-09-05 21:01:09.151', 35: FALSE, 36: 0.0, 37: 7, 38: '', 39: '', 40: 0.000000, 41: 2216, 42: '', 43: FALSE, 44: 0.00, 45: 1.00000000, 46: '...', 47: 1, 48: 4089.00000000, 49: 0.000000, 50: 0.000000, 51: NULL, 52: 0.000000, 53: 0.000000, 54: 11, 55: 0.52, 56: 0, 57: 1.0, 58: 0.0, 59: 2, 60: '', 61: 2, 62: 1, 63: 20, 64: 1, 65: 1, 66: '1', 67: 6.330000, 68: 5, 69: 3.47, 70: 1, 71: 'PAC Coquelets', 72: '', 73: 0.000000, 74: 0, 75: '', 76: 2, 77: 1, 78: NULL, 79: NULL, 80: 1}
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1746)
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:844)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:812)
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1736)
... 62 more
Caused by: org.h2.jdbc.JdbcSQLException: NULL not allowed for column "PV_U_DEVISE"; SQL statement:
INSERT INTO "OpenConcerto"."OpenConcerto49"."SAISIE_VENTE_FACTURE_ELEMENT" ("QTE", "LIVREE", "CODE_MISSION", "ACOMPTE", "ACTIVITE", "T_PV_HT", "OBJET_INSPECTE", "INDICE_N", "INFOS_OBJET_INSPECTE", "ARCHIVE", "NIVEAU", "QTE_LIVREE", "SERVICE", "PA_HT", "TARIF_Q18_HT", "VALEUR_METRIQUE_3", "POURCENT_SERVICE", "POURCENT_REMISE", "CREATION_DATE", "MARGE_HT", "ID_DEVISE", "TAUX_DEVISE", "ID_TAXE", "NOM", "PRIX_METRIQUE_VT_1", "DATE", "PV_U_DEVISE", "POURCENT_ACOMPTE", "T_POIDS_COLIS_NET", "POIDS", "PRIX_METRIQUE_VT_3", "PRIX_METRIQUE_VT_2", "POURCENT_FACTURABLE", "MODIFICATION_DATE", "Q18", "T_POIDS", "ID_UNITE_VENTE", "CODE_DOUANIER", "REFERENTIEL_INSPECTION", "T_PA_HT", "ID_SAISIE_VENTE_FACTURE", "SOUS_ACTIVITE", "MONTANT_REVISABLE", "REPARTITION_POURCENT", "POIDS_COLIS_NET", "POURCENT_CCIP", "ID_TICKET_CAISSE", "ORDRE", "PRIX_METRIQUE_HA_3", "MONTANT_INITIAL", "DATE_FIN", "PRIX_METRIQUE_HA_2", "PRIX_METRIQUE_HA_1", "ID_FAMILLE_ARTICLE", "QTE_UNITAIRE", "NB_COLIS", "VALEUR_METRIQUE_1", "VALEUR_METRIQUE_2", "ID_STYLE", "NOM_MISSION", "ID_USER_COMMON_CREATE", "ID_METRIQUE_1", "ID_ARTICLE", "ID_METRIQUE_2", "ID_METRIQUE_3", "DESCRIPTIF", "PV_HT", "ID_MODE_VENTE_ARTICLE", "T_PV_TTC", "ID_CONTACT", "CODE", "SITUATION_ADMIN", "PV_T_DEVISE", "INDICE_0", "LOCAL_OBJET_INSPECTE", "ID_USER_COMMON_MODIFY", "QTE_ACHAT", "MONTANT_FACTURABLE", "MONTANT_REMISE", "ID_PAYS") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23502-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.table.Column.validateConvertUpdateSequence(Column.java:295)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:713)
at org.h2.command.dml.Insert.insertRows(Insert.java:152)
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:2191)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1741)
... 67 more
Vers le numéro de facture en haut à gauche, un indicateur me dit que le numéro existe déjà!??
Voilà, merci d'avance pour vos solutions.
note: OS Linux mint 18 - java 8