Skip to content

Instantly share code, notes, and snippets.

@bryanboza
Created July 22, 2014 18:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bryanboza/6daa924741bd3ba08bbc to your computer and use it in GitHub Desktop.
Save bryanboza/6daa924741bd3ba08bbc to your computer and use it in GitHub Desktop.
error
at com.dotcms.repackage.hibernate2.net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
... 67 more
[22/07/14 12:58:41:521 CST] WARN util.JDBCExceptionReporter: SQL Error: 22001, SQLState: 22001
[22/07/14 12:58:41:521 CST] ERROR util.JDBCExceptionReporter: Value too long for column "EMAILADDRESS VARCHAR(100)": "'123@thenewemailvalidationfromdotcmscostaricaandtheqateamvalidationofbryanbozacastillosincedotcmsupgratemysalaryfrom255comdotcms... (148)"; SQL statement:
insert into User_ (companyId, password_, passwordEncrypted, passwordExpirationDate, passwordReset, firstName, middleName, lastName, nickName, male, birthday, emailAddress, smsId, aimId, icqId, msnId, ymId, favoriteActivity, favoriteBibleVerse, favoriteFood, favoriteMovie, favoriteMusic, languageId, timeZoneId, skinId, dottedSkins, roundedSkins, greeting, resolution, refreshRate, comments, createDate, loginDate, loginIP, lastLoginDate, lastLoginIP, failedLoginAttempts, agreedToTermsOfUse, active_, userId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-176]
[22/07/14 12:58:41:522 CST] ERROR impl.SessionImpl: Could not synchronize database state with session
[22/07/14 12:58:41:522 CST] ERROR business.UserFactoryLiferayImpl: com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.ejb.UserHBM#dotcms.org.2825]
com.liferay.portal.SystemException: com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.ejb.UserHBM#dotcms.org.2825]
at com.liferay.portal.ejb.UserPersistence.update(UserPersistence.java:217)
at com.liferay.portal.ejb.UserUtil.update(UserUtil.java:108)
at com.liferay.portal.ejb.UserLocalManagerImpl.addUser(UserLocalManagerImpl.java:170)
at com.liferay.portal.ejb.UserLocalManagerUtil.addUser(UserLocalManagerUtil.java:48)
at com.dotmarketing.business.UserFactoryLiferayImpl.createUser(UserFactoryLiferayImpl.java:98)
at com.dotmarketing.business.UserAPIImpl.createUser(UserAPIImpl.java:104)
at com.dotmarketing.portlets.user.ajax.UserAjax.addUser(UserAjax.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.impl.CreatorModule$1.doFilter(CreatorModule.java:229)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.impl.CreatorModule.executeMethod(CreatorModule.java:241)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:379)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:332)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.dwrp.BaseCallHandler.handle(BaseCallHandler.java:104)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:120)
at com.dotcms.repackage.dwr_3rc2modified.org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:141)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotcms.repackage.urlrewritefilter_4_0_3.org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:404)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.filters.CMSFilter.doFilter(CMSFilter.java:113)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.filters.AutoLoginFilter.doFilter(AutoLoginFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.filters.CacheImagesFilter.doFilter(CacheImagesFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.cms.urlmap.filters.URLMapFilter.doFilter(URLMapFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.filters.TimeMachineFilter.doFilter(TimeMachineFilter.java:162)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.dotmarketing.filters.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:146)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.GenericJDBCException: could not insert: [com.liferay.portal.ejb.UserHBM#dotcms.org.2825]
at com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.persister.AbstractEntityPersister.convert(AbstractEntityPersister.java:1331)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:472)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
at com.liferay.portal.ejb.UserPersistence.update(UserPersistence.java:129)
... 60 more
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "EMAILADDRESS VARCHAR(100)": "'123@thenewemailvalidationfromdotcmscostaricaandtheqateamvalidationofbryanbozacastillosincedotcmsupgratemysalaryfrom255comdotcms... (148)"; SQL statement:
insert into User_ (companyId, password_, passwordEncrypted, passwordExpirationDate, passwordReset, firstName, middleName, lastName, nickName, male, birthday, emailAddress, smsId, aimId, icqId, msnId, ymId, favoriteActivity, favoriteBibleVerse, favoriteFood, favoriteMovie, favoriteMusic, languageId, timeZoneId, skinId, dottedSkins, roundedSkins, greeting, resolution, refreshRate, comments, createDate, loginDate, loginIP, lastLoginDate, lastLoginIP, failedLoginAttempts, agreedToTermsOfUse, active_, userId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [22001-176]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
at org.h2.message.DbException.get(DbException.java:178)
at org.h2.table.Column.validateConvertUpdateSequence(Column.java:332)
at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726)
at org.h2.command.dml.Insert.insertRows(Insert.java:152)
at org.h2.command.dml.Insert.update(Insert.java:115)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:254)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:158)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:144)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.dotcms.repackage.hibernate2.net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment