com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'ukPhrase'. Cannot insert duplicate key in object 'dbo.phrase'. Error Code: 2627 Call: INSERT INTO phrase (phrase, languageCode, phraseAdminID, companyID) VALUES (?, ?, ?, ?) bind = [Choisez votre, fr, 65, 3] Query: InsertObjectQuery(net.bawtry.webshop.PhraseAdmin[id=-1])

hivmr.com | 5 months ago
  1. 0

    db:: 3.72::Work Status Error Cannot insert duplicate key row in object 'dbo.tblMainLoc kx

    hivmr.com | 5 months ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'ukPhrase'. Cannot insert duplicate key in object 'dbo.phrase'. Error Code: 2627 Call: INSERT INTO phrase (phrase, languageCode, phraseAdminID, companyID) VALUES (?, ?, ?, ?) bind = [Choisez votre, fr, 65, 3] Query: InsertObjectQuery(net.bawtry.webshop.PhraseAdmin[id=-1])
  2. 0

    Does Glassfish Enterprise Server v2.1.1 require identity field == null?

    Oracle Community | 7 years ago | 843833
    com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'ukPhrase'. Cannot insert duplicate key in object 'dbo.phrase'. Error Code: 2627 Call: INSERT INTO phrase (phrase, languageCode, phraseAdminID, companyID) VALUES (?, ?, ?, ?) bind => [Choisez votre, fr, 65, 3] Query: InsertObjectQuery(net.bawtry.webshop.PhraseAdmin[id=-1])
  3. 0

    Stack trace: 10-02-2014 02:09:37 PM org.bonitasoft.console.server.processes.ProcessServlet deploy SEVERE: Error while deploying bar. org.ow2.bonita.facade.exception.DeploymentException: could not insert: [org.ow2.bonita.facade.def.InternalDataFieldDefinition] cause: could not insert: [org.ow2.bonita.facade.def.InternalDataFieldDefinition] org.hibernate.exception.ConstraintViolationException: could not insert: [org.ow2.bonita.facade.def.InternalDataFieldDefinition] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:63) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2346) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2853) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129) at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:201) at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:147) at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:799) at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:791) at org.hibernate.engine.CascadingAction$8.cascade(CascadingAction.java:329) at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392) at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204) at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425) at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:362) at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:338) at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204) at org.hibernate.engine.Cascade.cascade(Cascade.java:161) at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:475) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:353) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129) at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:201) at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:147) at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:71) at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:808) at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:782) at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:786) at org.ow2.bonita.persistence.db.HibernateDbSession.save(HibernateDbSession.java:50) at org.ow2.bonita.services.impl.DbJournal.recordProcessDeployed(DbJournal.java:274) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.ow2.bonita.util.Chainer.invoke(Chainer.java:95) at com.sun.proxy.$Proxy44.recordProcessDeployed(Unknown Source) at org.ow2.bonita.deployment.Deployer.deploy(Deployer.java:199) at org.ow2.bonita.facade.impl.ManagementAPIImpl.deploy(ManagementAPIImpl.java:106) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.ow2.bonita.facade.APIInterceptor$APIInterceptorCommand.execute(APIInterceptor.java:115) at org.ow2.bonita.services.impl.DefaultCommandService.execute(DefaultCommandService.java:44) at org.ow2.bonita.runtime.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:45) at org.ow2.bonita.services.impl.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.ow2.bonita.services.impl.RetryInterceptor.execute(RetryInterceptor.java:59) at org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:187) at com.sun.proxy.$Proxy38.deploy(Unknown Source) at org.bonitasoft.console.server.processes.ProcessDataStore.deploy(ProcessDataStore.java:119) at org.bonitasoft.console.server.processes.ProcessServlet.deploy(ProcessServlet.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.bonitasoft.forms.server.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Thread.java:662) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'UQ__BN_DATAF_DEF__0CDAE408'. Cannot insert duplicate key in object 'dbo.BN_DATAF_DEF'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:93) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:56) ... 79 more at org.ow2.bonita.facade.impl.ManagementAPIImpl.deploy(ManagementAPIImpl.java:108) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.ow2.bonita.facade.APIInterceptor$APIInterceptorCommand.execute(APIInterceptor.java:115) at org.ow2.bonita.services.impl.DefaultCommandService.execute(DefaultCommandService.java:44) at org.ow2.bonita.runtime.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:45) at org.ow2.bonita.services.impl.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40) at org.ow2.bonita.services.impl.RetryInterceptor.execute(RetryInterceptor.java:59) at org.ow2.bonita.facade.APIInterceptor.invoke(APIInterceptor.java:187) at com.sun.proxy.$Proxy38.deploy(Unknown Source) at org.bonitasoft.console.server.processes.ProcessDataStore.deploy(ProcessDataStore.java:119) at org.bonitasoft.console.server.processes.ProcessServlet.deploy(ProcessServlet.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.bonitasoft.forms.server.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.bonitasoft.console.security.SessionFixationValve.invoke(SessionFixationValve.java:77) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Thread.java:662)

    JIRA | 3 years ago | Eduardo Elgueta
    org.hibernate.exception.ConstraintViolationException: could not insert: [org.ow2.bonita.facade.def.InternalDataFieldDefinition]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Violation of Unique Key constraint

    Stack Overflow | 6 years ago | Derek
    org.springframework.dao.DataIntegrityViolationException: could not insert: [EducationType]; SQL [insert into education_t ype (version, name) values (?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationEx ception: could not insert: [EducationType]
  6. 0

    Hibernate AssertionFailure: null id in entry (don't flush the Session after an exception occurs)

    Stack Overflow | 2 years ago
    org.hibernate.exception.ConstraintViolationException: could not execute statement

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.microsoft.sqlserver.jdbc.SQLServerException

      Violation of UNIQUE KEY constraint 'ukPhrase'. Cannot insert duplicate key in object 'dbo.phrase'. Error Code: 2627 Call: INSERT INTO phrase (phrase, languageCode, phraseAdminID, companyID) VALUES (?, ?, ?, ?) bind = [Choisez votre, fr, 65, 3] Query: InsertObjectQuery(net.bawtry.webshop.PhraseAdmin[id=-1])

      at oracle.toplink.essentials.exceptions.DatabaseException.sqlException()
    2. oracle.toplink.essentials
      DatabaseException.sqlException
      1. oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:311)
      1 frame