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

Quart job fails with Table SST_PREFS doesn't exist

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.7.1
    • Fix Version/s: 2.8.3
    • Component/s: Sitestats
    • Labels:
    • Environment:
      Demo trunk
    • Previous Issue Keys:
      STAT-255

      Description

      Job 'SiteStats old SST_PREFS table conversion'

      2010-09-20 13:54:21,323 INFO QuartzScheduler_Worker-4 org.sakaiproject.component.app.scheduler.NavigableEventLogListener.jobExecutions - Trigger Fired: [trigger: MT_5i1lkp35o1t7f, trigger description: , start: Mon Sep 20 13:54:21 CEST 2010, end: null, job: test14, job description: , class: org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper]
      2010-09-20 13:54:21,331 INFO QuartzScheduler_Worker-4 org.sakaiproject.component.app.scheduler.NavigableEventLogListener.jobExecutions - Job Executing: [name: test14, description: , class: org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper]
      2010-09-20 13:54:21,331 INFO QuartzScheduler_Worker-4 org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl - Old SiteStats Preferences table conversion started...
      2010-09-20 13:54:21,332 ERROR QuartzScheduler_Worker-4 org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl - Table SST_PREFS doesn't exist! Create it before running this conversion script.
      java.sql.SQLException: Table not found in statement [select count(*) from SST_PREFS]
      at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
      at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      at org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl.areBothTablesPresent(ConvOldPrefsJobImpl.java:199)
      at org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl.execute(ConvOldPrefsJobImpl.java:64)
      at org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper.execute(SpringJobBeanWrapper.java:70)
      at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
      2010-09-20 13:54:21,332 INFO QuartzScheduler_Worker-4 org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl - Old SiteStats Preferences table conversion finished.
      2010-09-20 13:54:21,332 INFO QuartzScheduler_Worker-4 org.sakaiproject.component.app.scheduler.NavigableEventLogListener.jobExecutions - Job Executed: [name: test14, description: , class: org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper]
      2010-09-20 13:54:21,333 INFO QuartzScheduler_Worker-4 org.sakaiproject.component.app.scheduler.NavigableEventLogListener.jobExecutions - Trigger Completed: [trigger: MT_5i1lkp35o1t7f, trigger description: , start: Mon Sep 20 13:54:21 CEST 2010, end: null, job: test14, job description: , class: org.sakaiproject.component.app.scheduler.jobs.SpringJobBeanWrapper, execution result: 3]

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                nfernandes Nuno Fernandes (Inactive)
                Reporter:
                a.m.berg@uva.nl Alan Berg
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration