Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-31760

ORA-01407 Error with LAST_VISIT_TIME when site presence enabled

    Details

    • 11 status:
      Resolved
    • Test Plan:
      Hide

      Via SAK-29546 set

      enableSitePresences@org.sakaiproject.sitestats.api.StatsManager=true
      collectEventsForSiteWithToolOnly@org.sakaiproject.sitestats.api.StatsUpdateManager=false

      It shouldn't display any errors when trying to run the updates.

      Show
      Via SAK-29546 set enableSitePresences@org.sakaiproject.sitestats.api.StatsManager=true collectEventsForSiteWithToolOnly@org.sakaiproject.sitestats.api.StatsUpdateManager=false It shouldn't display any errors when trying to run the updates.

      Description

      The following error occurs:

      2016-09-14 06:31:16,288  WARN org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.hibernate.util.JDBCExceptionReporter - SQL Error: 1407, SQLState: 72000
      2016-09-14 06:31:16,293 ERROR org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.hibernate.util.JDBCExceptionReporter - ORA-01407: cannot update ("SITEUSER"."SST_PRESENCE_TOTALS"."LAST_VISIT_TIME") to NULL
      2016-09-14 06:31:16,293  WARN org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.hibernate.util.JDBCExceptionReporter - SQL Error: 1407, SQLState: 72000
      2016-09-14 06:31:16,293 ERROR org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.hibernate.util.JDBCExceptionReporter - ORA-01407: cannot update ("SITEUSER"."SST_PRESENCE_TOTALS"."LAST_VISIT_TIME") to NULL
      2016-09-14 06:31:16,295  WARN org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl - Unable to commit transaction: 
      org.hibernate.QueryTimeoutException: Could not execute JDBC batch update
      	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)
      	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
      	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
      	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
      	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
      	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
      	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
      	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
      	at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl$5.doInHibernate(StatsUpdateManagerImpl.java:997)
      	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
      	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:341)
      	at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateConsolidatedEvents(StatsUpdateManagerImpl.java:900)
      	at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.run(StatsUpdateManagerImpl.java:487)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.BatchUpdateException: ORA-01407: cannot update ("SITEUSER"."SST_PRESENCE_TOTALS"."LAST_VISIT_TIME") to NULL
      	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500)
      	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
      	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
      	... 13 more
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  buckett Matthew Buckett
                  Reporter:
                  lcanessa Leonardo Canessa
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: