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

Jive Software Open Source | Gaston Dombiak | 1 decade ago
  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. kid 2 times, last 1 month ago
  2. kuldeep 4 times, last 2 months ago
  3. mortalman7 1 times, last 5 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