dotCMS / core

Headless/Hybrid Content Management System for Enterprises
http://dotcms.com
Other
861 stars 468 forks source link

Analytic problem on Oracle #4746

Closed graz1an0 closed 10 years ago

graz1an0 commented 10 years ago

This is the error. I found it on 2.3.2 release.

[17/01/14 00:00:03:057 CET] ERROR listeners.ClickstreamListener: Unable to close Hibernate Session com.dotmarketing.exception.DotHibernateException: Unable to close Hibernate Session at com.dotmarketing.db.HibernateUtil.closeSession(HibernateUtil.java:690) at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:69) at org.apache.catalina.session.StandardSession.expire(StandardSession.java:702) at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:592) at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:683) at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:668) at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1327) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1612) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1621) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1621) at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1601) at java.lang.Thread.run(Thread.java:662) Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#189956] at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at com.dotmarketing.db.HibernateUtil.closeSession(HibernateUtil.java:672) ... 11 more Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS201"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 40, maximum: 36)

    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:765)
    at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:662)
    at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:546)
    at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:729)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
    at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
    at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
    at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
    ... 18 more

[17/01/14 00:00:06:728 CET] WARN util.JDBCExceptionReporter: SQL Error: 12899, SQLState: 72000 [17/01/14 00:00:06:728 CET] ERROR util.JDBCExceptionReporter: ORA-12899: value too large for column "DOTCMS201"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER"

jtesser commented 10 years ago

humm this is strange as that means the identifier was not correct. I haven't seen this. Would need a reproducible case if possible