erreur

Steve · mer. oct. 05, 2016 9:58 am

bonjour,
je ne m'en sort pas..a peine une galere solvé que un nouveau message d'erreur apparait..
Impossible d'insérer

unable to insert SQLRowValues on /MODE_REGLEMENT/ : {ID_TYPE_REGLEMENT=2(class java.lang.Integer), COMPTANT=false(class java.lang.Boolean), ETS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), NUMERO=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE_DEPOT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), NOM=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE_VIREMENT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), AJOURS=30(class java.lang.Integer), DATE_FACTURE=true(class java.lang.Boolean), FIN_MOIS=false(class java.lang.Boolean), LENJOUR=0(class java.lang.Integer), ID_BANQUE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1)} using {ID_TYPE_REGLEMENT=2, ETS=SQLRowValues.SQL_DEFAULT, ID_BANQUE=SQLRowValues.SQL_DEFAULT, COMPTANT=false, DATE_DEPOT=SQLRowValues.SQL_DEFAULT, NOM=SQLRowValues.SQL_DEFAULT, DATE=SQLRowValues.SQL_DEFAULT, AJOURS=30, FIN_MOIS=false, LENJOUR=0, NUMERO=SQLRowValues.SQL_DEFAULT, DATE_VIREMENT=SQLRowValues.SQL_DEFAULT, DATE_FACTURE=true}
org.openconcerto.utils.ExceptionHandler: Impossible d'insérer
at org.openconcerto.utils.ExceptionHandler.handle(ExceptionHandler.java:121)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:707)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:695)
at org.openconcerto.sql.element.ElementSQLObject.insert(ElementSQLObject.java:290)
at org.openconcerto.sql.element.ElementSQLObject.insert(ElementSQLObject.java:325)
at org.openconcerto.sql.request.SQLRowView.fillVals(SQLRowView.java:353)
at org.openconcerto.sql.request.SQLRowView.insert(SQLRowView.java:346)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:703)
at org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent.insert(TransfertBaseSQLComponent.java:111)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.commit(SaisieVenteFactureSQLComponent.java:1232)
at org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent.insert(SaisieVenteFactureSQLComponent.java:1094)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:695)
at org.openconcerto.sql.view.EditPanel.ajouter(EditPanel.java:472)
at org.openconcerto.sql.view.EditPanel.actionPerformed(EditPanel.java:436)
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$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.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$1.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.sql.SQLException: unable to insert SQLRowValues on /MODE_REGLEMENT/ : {ID_TYPE_REGLEMENT=2(class java.lang.Integer), COMPTANT=false(class java.lang.Boolean), ETS=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), NUMERO=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE_DEPOT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), NOM=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), DATE_VIREMENT=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1), AJOURS=30(class java.lang.Integer), DATE_FACTURE=true(class java.lang.Boolean), FIN_MOIS=false(class java.lang.Boolean), LENJOUR=0(class java.lang.Integer), ID_BANQUE=SQLRowValues.SQL_DEFAULT(class org.openconcerto.sql.model.SQLRowValues$1)} using {ID_TYPE_REGLEMENT=2, ETS=SQLRowValues.SQL_DEFAULT, ID_BANQUE=SQLRowValues.SQL_DEFAULT, COMPTANT=false, DATE_DEPOT=SQLRowValues.SQL_DEFAULT, NOM=SQLRowValues.SQL_DEFAULT, DATE=SQLRowValues.SQL_DEFAULT, AJOURS=30, FIN_MOIS=false, LENJOUR=0, NUMERO=SQLRowValues.SQL_DEFAULT, DATE_VIREMENT=SQLRowValues.SQL_DEFAULT, DATE_FACTURE=true}
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1853)
at org.openconcerto.sql.model.SQLRowValuesCluster$Insert.execOn(SQLRowValuesCluster.java:1617)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.store(SQLRowValuesCluster.java:1529)
at org.openconcerto.sql.model.SQLRowValuesCluster$Node.access$3(SQLRowValuesCluster.java:1527)
at org.openconcerto.sql.model.SQLRowValuesCluster$2.handle(SQLRowValuesCluster.java:487)
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:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:873)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:837)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:125)
at org.openconcerto.sql.utils.SQLUtils.executeAtomic(SQLUtils.java:97)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:454)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:376)
at org.openconcerto.sql.model.SQLRowValuesCluster.store(SQLRowValuesCluster.java:371)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1824)
at org.openconcerto.sql.model.SQLRowValues.insert(SQLRowValues.java:1808)
at org.openconcerto.sql.request.SQLRowView.insert(SQLRowView.java:346)
at org.openconcerto.sql.element.BaseSQLComponent.insert(BaseSQLComponent.java:703)
... 49 more
Caused by: java.sql.SQLException: Unable to insert prep52: INSERT INTO "OpenConcerto"."OpenConcerto49"."MODE_REGLEMENT" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "ID_TYPE_REGLEMENT", "COMPTANT", "AJOURS", "FIN_MOIS", "LENJOUR", "DATE_FACTURE", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto49"."MODE_REGLEMENT" {1: TIMESTAMP '2016-10-05 11:52:06.512', 2: 2, 3: TIMESTAMP '2016-10-05 11:52:06.512', 4: 2, 5: 2, 6: FALSE, 7: 30, 8: FALSE, 9: 0, 10: TRUE}
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1841)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1)
at org.openconcerto.sql.model.ConnectionHandler.compute(ConnectionHandler.java:59)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:873)
at org.openconcerto.sql.model.SQLDataSource.useConnection(SQLDataSource.java:837)
at org.openconcerto.sql.model.SQLRowValues.insertJustThis(SQLRowValues.java:1831)
... 67 more
Caused by: org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 126 got 140 MODE_REGLEMENT.MODE_REGLEMENT_ID_USER_COMMON_CREATE_fkey_INDEX_D"; SQL statement:
INSERT INTO "OpenConcerto"."OpenConcerto49"."MODE_REGLEMENT" ("MODIFICATION_DATE", "ID_USER_COMMON_MODIFY", "CREATION_DATE", "ID_USER_COMMON_CREATE", "ID_TYPE_REGLEMENT", "COMPTANT", "AJOURS", "FIN_MOIS", "LENJOUR", "DATE_FACTURE", "ORDRE") select ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, COALESCE(MAX("ORDRE"), 0) + 1 FROM "OpenConcerto"."OpenConcerto49"."MODE_REGLEMENT" [50000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
at org.h2.message.DbException.get(DbException.java:161)
at org.h2.message.DbException.convert(DbException.java:284)
at org.h2.table.RegularTable.addRow(RegularTable.java:137)
at org.h2.command.dml.Insert.addRow(Insert.java:199)
at org.h2.command.dml.Insert.insertRows(Insert.java:173)
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:2295)
at org.openconcerto.sql.model.SQLRowValues$6.handle(SQLRowValues.java:1836)
... 72 more
Caused by: java.lang.RuntimeException: rowCount expected 126 got 140 MODE_REGLEMENT.MODE_REGLEMENT_ID_USER_COMMON_CREATE_fkey_INDEX_D
at org.h2.message.DbException.throwInternalError(DbException.java:231)
at org.h2.table.RegularTable.checkRowCount(RegularTable.java:168)
at org.h2.table.RegularTable.addRow(RegularTable.java:120)
... 81 more
help me please...je pete les plombs
merci

Samuel_Burg · mer. oct. 05, 2016 10:35 am

votre problème est indiqué dans votre texte :

rowCount expected 126 got 140 MODE_REGLEMENT.MODE_REGLEMENT_ID_USER_COMMON_CREATE_fkey_INDEX_D

vous avez une table qui est moisie.

cordialement,

Steve · jeu. oct. 06, 2016 4:05 pm

Bonjour,
J'ai un tout petit niveau...Une table moisie?
Comment je répare?
Merci

Samuel_Burg · ven. oct. 07, 2016 6:49 am

Bonjour,

soit vous avez un problème a l'installation avec une base de donnée qui n'est pas à la même version que l'interface OC, soit vous avez une base de donnée qui est corrompue.

donc soit il faut finaliser l'installation (mise à jour de la base, outil intégré à OC), soit il vous faut des compétences en base de donnée pour corriger l’erreur dans la table.

cordialement,