[2.3.2] Clickstream error spamming log.

[Nathan Keiter]

We literally see this 5 or 6 times per second in our log and it’s getting out of control.

 

How do we resolve this?  (Other than increasing the field size?)  I don’t think an “IDENTIFIER” should ever be that large…

 

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

 

Nathan

 

Nathan I. Keiter

Lead Network Applications Programmer

DataSystems

Gettysburg College

Campus Box 2453

717-337-6993

 

Measure your success by the level of service you provide.

Si hoc legere scis nimium eruditionis habes.

 

[Nathan Keiter]

Here's a snippet of the log output, if it helps:

[25/09/14 14:27:33:583 EDT] WARN util.JDBCExceptionReporter: SQL Error: 12899, SQLState: 72000
[25/09/14 14:27:33:583 EDT] ERROR util.JDBCExceptionReporter: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

[25/09/14 14:27:33:583 EDT] ERROR impl.SessionImpl: Could not synchronize database state with session
[25/09/14 14:27:33:583 EDT] ERROR factories.ClickstreamRequestFactory: save: failed
com.dotmarketing.exception.DotHibernateException: Unable to save/update Object to Hibernate Session
at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:460)
at com.dotmarketing.factories.ClickstreamRequestFactory.save(ClickstreamRequestFactory.java:89)
at com.dotmarketing.loggers.DatabaseClickstreamLogger.log(DatabaseClickstreamLogger.java:60)
at com.dotmarketing.factories.ClickstreamFactory.flushClickStream(ClickstreamFactory.java:167)
at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:62)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:708)
at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:575)
at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:698)
at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:683)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1316)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:722)
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#7607256]
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.saveOrUpdate(HibernateUtil.java:458)
... 14 more

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 21 more
[25/09/14 14:27:33:583 EDT] ERROR listeners.ClickstreamListener: Unable to save/update Object to Hibernate Session
com.dotmarketing.exception.DotRuntimeException: Unable to save/update Object to Hibernate Session
at com.dotmarketing.factories.ClickstreamRequestFactory.save(ClickstreamRequestFactory.java:92)
at com.dotmarketing.loggers.DatabaseClickstreamLogger.log(DatabaseClickstreamLogger.java:60)
at com.dotmarketing.factories.ClickstreamFactory.flushClickStream(ClickstreamFactory.java:167)
at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:62)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:708)
at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:575)
at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:698)
at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:683)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1316)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:722)
Caused by: com.dotmarketing.exception.DotHibernateException: Unable to save/update Object to Hibernate Session
at com.dotmarketing.db.HibernateUtil.saveOrUpdate(HibernateUtil.java:460)
at com.dotmarketing.factories.ClickstreamRequestFactory.save(ClickstreamRequestFactory.java:89)
... 13 more
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#7607256]
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.saveOrUpdate(HibernateUtil.java:458)
... 14 more

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 21 more
[25/09/14 14:27:33:900 EDT] WARN util.JDBCExceptionReporter: SQL Error: 12899, SQLState: 72000
[25/09/14 14:27:33:900 EDT] ERROR util.JDBCExceptionReporter: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

[25/09/14 14:27:33:900 EDT] ERROR impl.SessionImpl: Could not synchronize database state with session
[25/09/14 14:27:33:900 EDT] 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:681)
at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:69)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:708)
at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:575)
at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:698)
at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:683)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1316)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:722)
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#7607256]
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:663)
... 11 more

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 18 more
[25/09/14 14:27:34:670 EDT] WARN util.JDBCExceptionReporter: SQL Error: 12899, SQLState: 72000
[25/09/14 14:27:34:670 EDT] ERROR util.JDBCExceptionReporter: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

[25/09/14 14:27:34:670 EDT] ERROR impl.SessionImpl: Could not synchronize database state with session
[25/09/14 14:27:34:670 EDT] 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:681)
at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:69)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:708)
at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:575)
at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:698)
at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:683)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1316)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:722)
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#7607256]
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:663)
... 11 more

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 18 more
[25/09/14 14:27:34:974 EDT] WARN util.JDBCExceptionReporter: SQL Error: 12899, SQLState: 72000
[25/09/14 14:27:34:974 EDT] ERROR util.JDBCExceptionReporter: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

[25/09/14 14:27:34:974 EDT] ERROR impl.SessionImpl: Could not synchronize database state with session
[25/09/14 14:27:34:974 EDT] 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:681)
at com.dotmarketing.listeners.ClickstreamListener.sessionDestroyed(ClickstreamListener.java:69)
at org.apache.catalina.session.StandardSession.expire(StandardSession.java:708)
at org.apache.catalina.session.StandardSession.isValid(StandardSession.java:575)
at org.apache.catalina.session.ManagerBase.processExpires(ManagerBase.java:698)
at org.apache.catalina.session.ManagerBase.backgroundProcess(ManagerBase.java:683)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1316)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:722)
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.dotmarketing.beans.ClickstreamRequest#7607256]
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:663)
... 11 more

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 18 more

Nathan

Nathan I. Keiter
Lead Network Applications Programmer
DataSystems
Gettysburg College
Campus Box 2453
717-337-6993

Measure your success by the level of service you provide.
Si hoc legere scis nimium eruditionis habes.

From: dot...@googlegroups.com [mailto:dot...@googlegroups.com] On Behalf Of Nathan Keiter
Sent: Thursday, September 25, 2014 2:32 PM
To: dot...@googlegroups.com
Subject: [dotcms] [2.3.2] Clickstream error spamming log.

We literally see this 5 or 6 times per second in our log and it's getting out of control.

How do we resolve this?  (Other than increasing the field size?)  I don't think an "IDENTIFIER" should ever be that large.

Caused by: java.sql.SQLException: ORA-12899: value too large for column "DOTCMS"."CLICKSTREAM_REQUEST"."ASSOCIATED_IDENTIFIER" (actual: 233, maximum: 36)

Nathan

Nathan I. Keiter
Lead Network Applications Programmer
DataSystems
Gettysburg College
Campus Box 2453
717-337-6993

Measure your success by the level of service you provide.
Si hoc legere scis nimium eruditionis habes.

--
You received this message because you are subscribed to the Google Groups "Dotcms User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/d/optout.

[Falzone, Chris]

You use Clickstream Data?  The easy answer would be to turn it off in the config so it doesn't try to save it.  Though if you need it I am not sure.

--

Christopher Falzone

Interactive Developer

A Q U E N T

Digital, Creative, and Marketing Talent

aquent.com

cfal...@aquent.com

[Nathan Keiter]

Probably not, since we use Google analytics…  Turning it off is probably a good option for us.

 

Nathan

 

Nathan I. Keiter

Lead Network Applications Programmer

DataSystems

Gettysburg College

Campus Box 2453

717-337-6993

 

Measure your success by the level of service you provide.

Si hoc legere scis nimium eruditionis habes.