java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • "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]"
    via by Angelo Bernabei,
  • Migration From 6.2 GA2 7.0 GA2 - Forums | Liferay
    via by Unknown author,
    • java.sql.SQLException: Duplicate entry '254-admin@gato.dyndns.org' for key 1 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 com.jivesoftware.wildfire.enterprise.archive.Conversation.insertIntoDb(Conversation.java:264) at com.jivesoftware.wildfire.enterprise.archive.Conversation.<init>(Conversation.java:102) at com.jivesoftware.wildfire.enterprise.archive.ConversationManager.processMessage(ConversationManager.java:405) at com.jivesoftware.wildfire.enterprise.archive.MessageInterceptor.interceptPacket(MessageInterceptor.java:68)

    Users with the same issue

    rocdayrocday
    1 times, last one,
    slashslash
    1 times, last one,
    zbalintzbalint
    2 times, last one,
    ivanszkypeterivanszkypeter
    4 times, last one,
    HronomHronom
    1 times, last one,
    41 more bugmates