3 Replies Latest reply on Mar 5, 2019 8:27 AM by abdallah hamaydeh

    The duplicate key value is (6311).

    abdallah hamaydeh
      Share:|

      Message: could not insert: [com.numarasoftware.footprints.core.domain.business.PublishingError]; SQL [insert into fpscdb001_system.publ_error (item_id, item_name, error_type_name, location_type_name, location_name, location_id, msg, publ_log_id, publ_error_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.numarasoftware.footprints.core.domain.business.PublishingError]

       

       

      Exception Type: org.springframework.dao.DataIntegrityViolationException

      Error Code: 999

      Facility: webapp.FP

      Build Number: 33

      Serial Number: ********

      Locale: en_US

      Log entry identifier: d7bcff29-6a28-437c-a523-304e1f5b13c7

      Hash Code: -399770002

       

       

      Stack Trace:

       

       

      * Stack Trace Summary:

        - org.springframework.dao.DataIntegrityViolationException : could not insert: [com.numarasoftware.footprints.core.domain.business.PublishingError]; SQL [insert into fpscdb001_system.publ_error (item_id, item_name, error_type_name, location_type_name, location_name, location_id, msg, publ_log_id, publ_error_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.numarasoftware.footprints.core.domain.business.PublishingError]

        - org.hibernate.exception.ConstraintViolationException : could not insert: [com.numarasoftware.footprints.core.domain.business.PublishingError]

        - java.sql.SQLException : Violation of PRIMARY KEY constraint 'publ_error_pk'. Cannot insert duplicate key in object 'fpscdb001_system.publ_error'. The duplicate key value is (6313).

       

      ----------------- from the log

      Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'publ_error_pk'. Cannot insert duplicate key in object 'fpscdb001_system.publ_error'. The duplicate key value is (6311).

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

      at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)

      at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

      at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

      at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:506)

      at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1449)

      at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)

      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2418)

      ... 98 more