java.sql.SQLException: Duplicate entry '254-admin@gato.dyndns.org' for key 1

JIRA | Gaston Dombiak | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0
  2. 0
  3. 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [Mifos-developer] Problem Upgrading to Revision 12244 and higher

    Google Groups | 9 years ago | Graeme Ruthven
    java.lang.RuntimeException: error in upgrading to 169
  6. 0

    "14 Apr 2008 12:37:37,986 DEBUG it.eng.spagobi.commons.utilities.ExecutionProxy.exec:141 - statusCode=200 14 Apr 2008 12:37:37,986 DEBUG it.eng.spagobi.commons.utilities.ExecutionProxy.exec:143 - response=[B@5ebd6b 14 Apr 2008 12:37:37,986 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.loadAuditByID:103 - IN 14 Apr 2008 12:37:37,990 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.loadAuditByID:153 - OUT 14 Apr 2008 12:37:37,990 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.modifyAudit:160 - IN 14 Apr 2008 12:37:37,994 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.modifyAudit:178 - OUT 14 Apr 2008 12:37:37,994 DEBUG it.eng.spagobi.commons.utilities.ExecutionProxy.exec:156 - OUT 14 Apr 2008 12:37:37,994 DEBUG it.eng.spagobi.commons.utilities.ExecutionProxy.getFileExtensionFromContType:169 - IN 14 Apr 2008 12:37:37,995 DEBUG it.eng.spagobi.commons.utilities.ExecutionProxy.getFileExtensionFromContType:198 - OUT 14 Apr 2008 12:37:37,995 DEBUG it.eng.spagobi.events.EventsManager.registerEvent:98 - IN 14 Apr 2008 12:37:37,995 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.insertEventLog:192 - IN 14 Apr 2008 12:37:38,006 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.init:30 - IN 14 Apr 2008 12:37:38,007 DEBUG it.eng.spagobi.commons.utilities.GeneralUtilities.getBackEndSpagoBiContextAddress:345 - IN 14 Apr 2008 12:37:38,008 DEBUG it.eng.spagobi.commons.utilities.GeneralUtilities.getBackEndSpagoBiContextAddress:348 - Trying to recover spagobi context path from ConfigSingleton 14 Apr 2008 12:37:38,009 DEBUG it.eng.spagobi.commons.utilities.GeneralUtilities.getBackEndSpagoBiContextAddress:352 - using context path: http://athos:58080/SpagoBI 14 Apr 2008 12:37:38,009 DEBUG it.eng.spagobi.commons.utilities.GeneralUtilities.getBackEndSpagoBiContextAddress:356 - OUT:http://athos:58080/SpagoBI 14 Apr 2008 12:37:38,010 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.init:35 - Read validateUrl=https://localhost:8443/exo-cas-2/proxyValidate 14 Apr 2008 12:37:38,011 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.init:38 - Read validateService=http://athos:58080/SpagoBI/proxyReceptor 14 Apr 2008 12:37:38,011 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.init:43 - Read activeSso=false 14 Apr 2008 12:37:38,012 DEBUG it.eng.spagobi.services.audit.service.AuditServiceImpl.log:32 - IN 14 Apr 2008 12:37:38,012 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.validateTicket:58 - IN 14 Apr 2008 12:37:38,013 DEBUG it.eng.spagobi.services.common.AbstractServiceImpl.validateTicket:76 - OUT 14 Apr 2008 12:37:38,014 DEBUG it.eng.spagobi.services.audit.service.AuditServiceImpl.log:48 - IN 14 Apr 2008 12:37:38,014 DEBUG it.eng.spagobi.services.audit.service.AuditServiceImpl.log:54 - Audit id = [63] 14 Apr 2008 12:37:38,015 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.loadAuditByID:103 - IN 14 Apr 2008 12:37:38,019 DEBUG it.eng.spagobi.monitoring.dao.DbAuditImpl.loadAuditByID:153 - OUT 14 Apr 2008 12:37:38,020 WARN it.eng.spagobi.monitoring.dao.AuditManager.updateAudit:247 - Audit record with id = [63] has already a start time and an end time. This record will not be modified. 14 Apr 2008 12:37:38,021 DEBUG it.eng.spagobi.services.audit.service.AuditServiceImpl.log:42 - OUT 14 Apr 2008 12:37:38,031 DEBUG it.eng.spagobi.commons.dao.AbstractHibernateDAO.insertEventLog:233 - OUT 14 Apr 2008 12:37:38,031 DEBUG it.eng.spagobi.events.EventsManager.registerEvent:112 - OUT 14 Apr 2008 12:37:38,032 DEBUG it.eng.spagobi.tools.scheduler.jobs.ExecuteBIDocumentJob.saveAsDocument:217 - IN 14 Apr 2008 12:37:38,032 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceBegin Istantiation of DAO [DomainDAO] 14 Apr 2008 12:37:38,032 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [DomainDAO] Implementation class [it.eng.spagobi.commons.dao.DomainDAOHibImpl] 14 Apr 2008 12:37:38,032 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [DomainDAO] Instatiate successfully 14 Apr 2008 12:37:38,037 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceBegin Istantiation of DAO [EngineDAO] 14 Apr 2008 12:37:38,038 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [EngineDAO] Implementation class [it.eng.spagobi.engines.config.dao.EngineDAOHibImpl] 14 Apr 2008 12:37:38,038 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [EngineDAO] Instatiate successfully 14 Apr 2008 12:37:38,040 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceBegin Istantiation of DAO [BIObjectDAO] 14 Apr 2008 12:37:38,041 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [BIObjectDAO] Implementation class [it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl] 14 Apr 2008 12:37:38,041 DEBUG Spago.trace:142 - MetadataService::it.eng.spagobi.commons.dao.DAOFactory::createDAOInstanceDAO [BIObjectDAO] Instatiate successfully 14 Apr 2008 12:37:38,044 DEBUG it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl.internalInsertBIObject:504 - IN 14 Apr 2008 12:37:38,047 ERROR it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl.internalInsertBIObject:587 - HibernateException org.hibernate.exception.ConstraintViolationException: could not insert: [it.eng.spagobi.analiticalmodel.document.metadata.SbiObjects] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404) at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243) at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269) at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510) at it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl.internalInsertBIObject(BIObjectDAOHibImpl.java:556) at it.eng.spagobi.analiticalmodel.document.dao.BIObjectDAOHibImpl.insertBIObject(BIObjectDAOHibImpl.java:490) at it.eng.spagobi.tools.scheduler.jobs.ExecuteBIDocumentJob.saveAsDocument(ExecuteBIDocumentJob.java:281) at it.eng.spagobi.tools.scheduler.jobs.ExecuteBIDocumentJob.execute(ExecuteBIDocumentJob.java:129) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529) Caused by: java.sql.SQLException: Column 'CREATION_USER' cannot be null at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1967) ... 20 more 14 Apr 2008 12:37:38,048 DEBUG Spago.trace:142 - EMFUserError::init: invocato 14 Apr 2008 12:37:38,048 DEBUG Spago.trace:142 - EMFUserError::init: severity [ERROR] 14 Apr 2008 12:37:38,049 DEBUG Spago.trace:142 - EMFUserError::init: code [100] 14 Apr 2008 12:37:38,049 WARN Spago.trace:142 - MessageBundle::getMessage: requestContainer nullo 14 Apr 2008 12:37:38,049 DEBUG Spago.trace:142 - EMFUserError::init: description [Generic Error]"

    JIRA | 9 years ago | Angelo Bernabei
    org.hibernate.exception.ConstraintViolationException: could not insert: [it.eng.spagobi.analiticalmodel.document.metadata.SbiObjects]

  1. Hronom 1 times, last 4 months ago
  2. kid 2 times, last 6 months ago
  3. kuldeep 4 times, last 7 months ago
  4. mortalman7 1 times, last 10 months ago
32 unregistered visitors
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. java.sql.SQLException

    Duplicate entry '254-admin@gato.dyndns.org' for key 1

    at com.mysql.jdbc.MysqlIO.checkErrorPacket()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
    3. com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
    4. com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
    5. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
    6. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
    7. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
    7 frames
  3. com.jivesoftware.wildfire
    MessageInterceptor.interceptPacket
    1. com.jivesoftware.wildfire.enterprise.archive.Conversation.insertIntoDb(Conversation.java:264)
    2. com.jivesoftware.wildfire.enterprise.archive.Conversation.<init>(Conversation.java:102)
    3. com.jivesoftware.wildfire.enterprise.archive.ConversationManager.processMessage(ConversationManager.java:405)
    4. com.jivesoftware.wildfire.enterprise.archive.MessageInterceptor.interceptPacket(MessageInterceptor.java:68)
    4 frames