Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-1333

SQL Exception: out of range for type integer when sending out notifications

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 9.4.3
    • Fix Version/s: 9.4.5, 10.0.9
    • Component/s: None
    • Labels:
      None

      Description

      The notification generation script stops with the following Error resulting in most of the subscriptions not sent. What database field needs a bigger type here?:

      2014-11-27 04:14:34,013 [schedulerFactoryBean_Worker-3] ERROR SqlExceptionHelper - ERROR: value "3762716734" is out of range for type integer
      2014-11-27 04:14:34,014 [schedulerFactoryBean_Worker-3] ERROR NotificationsManagerImpl - OLAT::ERROR % N1-E189 % org.olat.core.commons.services.notifications.manager % n/a % n/a % n/a % n/a % Cannot generate a subscription item. % >>>stack of 1.cause::org.olat.core.logging.DBRuntimeException: Error in
      list() -> at org.olat.core.commons.persistence.DBQueryImpl.list(DBQueryImpl.java:180) at org.olat.portfolio.manager.EPNotificationManager.getCommentNotifications(EPNotificationManager.java:232) at org.olat.portfolio.manager.EPNotificationManager.getCommentNotifications(EPNotificationManager.java:143) at org.olat.por
      tfolio.manager.EPNotificationsHelper.getAllSubscrItemsStructured(EPNotificationsHelper.java:115) at org.olat.portfolio.manager.EPNotificationsHandler.createSubscriptionInfo(EPNotificationsHandler.java:80) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.createSubscriptionItem(Notificati
      onsManagerImpl.java:1005) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.processSubscribersByEmail(NotificationsManagerImpl.java:360) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.notifyAllSubscribersByEmail(NotificationsManagerImpl.java:301) at org.
      olat.core.commons.services.notifications.manager.EmailNotificationJob.executeWithDB(EmailNotificationJob.java:49) at org.olat.core.commons.services.scheduler.JobWithDB.executeInternal(JobWithDB.java:59) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)>>>stack of 2.cause::org.hiber
      nate.exception.DataException: could not extract ResultSet -> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135) at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) at org.hibernate.engine.jdbc.spi.Sql
      ExceptionHelper.convert(SqlExceptionHelper.java:124) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88) at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) at org.hibernate.loa
      der.Loader.executeQueryStatement(Loader.java:1859) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:906) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) at org.hibernate.loader.Loader.doList(Loader.java:2550
      )>>>stack of 3.cause::org.postgresql.util.PSQLException: ERROR: value "3762716734" is out of range for type integer -> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql
      .core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdb
      c2Statement.java:273) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetRetu
      rnImpl.java:79) at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
      2014-11-27 04:14:34,015 [schedulerFactoryBean_Worker-3] ERROR SqlExceptionHelper - ERROR: current transaction is aborted, commands ignored until end of transaction block
      2014-11-27 04:14:34,015 [schedulerFactoryBean_Worker-3] ERROR InfoMessageNotificationHandler - OLAT::ERROR % N1-E190 % org.olat.commons.info.notification % n/a % n/a % n/a % n/a % Unexpected exception % >>>stack of 1.cause::javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCExc
      eption: could not extract ResultSet -> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277) at org.olat.repository.Reposit
      oryManager.lookupDisplayNameByOLATResourceableId(RepositoryManager.java:662) at org.olat.commons.info.notification.InfoMessageNotificationHandler.createSubscriptionInfo(InfoMessageNotificationHandler.java:71) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.createSubscriptionItem(Notifi
      cationsManagerImpl.java:1005) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.processSubscribersByEmail(NotificationsManagerImpl.java:360) at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.notifyAllSubscribersByEmail(NotificationsManagerImpl.java:301) at
      org.olat.core.commons.services.notifications.manager.EmailNotificationJob.executeWithDB(EmailNotificationJob.java:49) at org.olat.core.commons.services.scheduler.JobWithDB.executeInternal(JobWithDB.java:59) at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)>>>stack of 2.cause::org.h
      ibernate.exception.GenericJDBCException: could not extract ResultSet -> at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) at org.hibernate.engine.jdbc.spi.SqlExceptio
      nHelper.convert(SqlExceptionHelper.java:109) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88) at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859) at org.hibernate.loader.Loader.executeQuerySta
      tement(Loader.java:1838) at org.hibernate.loader.Loader.doQuery(Loader.java:906) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) at org.hibernate.loader.Loader.doList(Loader.java:2550) at org.hibernate.loader.Loader.doList(Loader.java:2536)>>>stack of 3.cause::org.postgresql.util
      .PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block -> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.Quer
      yExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.j
      ava:273) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:7
      9) at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
      2014-11-27 04:14:34,035 [schedulerFactoryBean_Worker-3] ERROR SqlExceptionHelper - ERROR: current transaction is aborted, commands ignored until end of transaction block
      2014-11-27 04:14:34,037 [schedulerFactoryBean_Worker-3] ERROR ErrorLogger - Job (DEFAULT.org.olat.notifications.job.enabled threw an exception.
      org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet]
      at org.quartz.core.JobRunShell.run(JobRunShell.java:234)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)
      at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.updateSubscriberLatestEmail(NotificationsManagerImpl.java:476)
      at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.sendMailToUserAndUpdateSubscriber(NotificationsManagerImpl.java:460)
      at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.notifySubscribersByEmail(NotificationsManagerImpl.java:383)
      at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.processSubscribersByEmail(NotificationsManagerImpl.java:373)
      at org.olat.core.commons.services.notifications.manager.NotificationsManagerImpl.notifyAllSubscribersByEmail(NotificationsManagerImpl.java:301)
      at org.olat.core.commons.services.notifications.manager.EmailNotificationJob.executeWithDB(EmailNotificationJob.java:49)
      at org.olat.core.commons.services.scheduler.JobWithDB.executeInternal(JobWithDB.java:59)
      at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:113)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:223)
      ... 1 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
      at org.hibernate.loader.Loader.doQuery(Loader.java:906)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
      at org.hibernate.loader.Loader.doList(Loader.java:2550)
      at org.hibernate.loader.Loader.doList(Loader.java:2536)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
      at org.hibernate.loader.Loader.list(Loader.java:2361)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)
      at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)
      at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)
      at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)
      at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)
      ... 10 more
      Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
      at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
      at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
      at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
      at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
      ... 25 more

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              d.haag Daniel Haag
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour
                1h