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

Missing sequence

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.9.0
    • Fix Version/s: 2.9.0, 10.0
    • Component/s: Global
    • Labels:
      None
    • Environment:
      qa3-us
    • 2.9 Status:
      Resolved
    • Conversion Script Required:
      Yes
    • Previous Issue Keys:
      STAT-315

      Description

      Might be missing a sequence in the oracle conversion scripts for Sakai 2.9:

      2012-04-03 16:01:33,520 WARN org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl - Unable to commit transaction:
      org.hibernate.exception.SQLGrammarException: could not get next sequence value
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
      at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:508)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:500)
      at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:496)
      at sun.reflect.GeneratedMethodAccessor1144.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1293)
      at $Proxy14.saveOrUpdate(Unknown Source)
      at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateUserStatObjects(StatsUpdateManagerImpl.java:1233)
      at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.access$1600(StatsUpdateManagerImpl.java:76)
      at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl$4.doInHibernate(StatsUpdateManagerImpl.java:888)
      at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
      at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.doUpdateConsolidatedEvents(StatsUpdateManagerImpl.java:805)
      at org.sakaiproject.sitestats.impl.StatsUpdateManagerImpl.run(StatsUpdateManagerImpl.java:484)
      at java.lang.Thread.run(Thread.java:662)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ottenhoff Sam Ottenhoff
                  Reporter:
                  chmaurer@iupui.edu Chris Maurer
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code