[Building Sakai] quartz-job issue with siteStats tool

[Liu, Peter]

Sorry!!!

It was my own mistake.  I have run a wrong quartz-job: 'stieStats old SST_PREFS table conversion'.  Actually, I need to run 'SiteStats event Aggregator' quartz-job.

After I have switched to the right quartz job and it works great!

Many thanks,
Peter

From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Liu, Peter
Sent: Monday, July 11, 2011 4:00 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] quartz-job issue with siteStats tool

Hi,

We have run the SiteStats tool 2.1.7 tag for our Sakai 2.6.x version.  We have no problem to run it in an external Database schema with
collectThreadEnabled at org.sakaiproject.sitestats.api.StatsUpdateManager=true<mailto:collectThreadEnabled at org.sakaiproject.sitestats.api.StatsUpdateManager=true> case (in time data collection).

However, when I try to switch it to run a quartz job to collect the data updates at certain period, the Quartz job gives me following errors and it complaints about two tables not exit:
ERROR: Table SST_PREFS doesn't exist!
ERROR: Table SST_PREFERENCES doesn't exist!

And I don't see that the data has been updated for siteStats tool.

Does we need these tables created in Sakai main schema? Or do we miss something?  I have seen that there is a JIRA issue:
https://jira.sakaiproject.org/browse/STAT-255?

Does this solve this issue?

Many thanks!
Peter liu

############################ Error Log #######################
INFO: Old SiteStats Preferences table conversion started... (2011-07-11 15:14:39,223 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl)
ERROR: Table SST_PREFS doesn't exist! Create it before running this conversion script. (2011-07-11 15:14:39,227 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl)
java.sql.SQLException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
        at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
        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:203)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
ERROR: Table SST_PREFERENCES doesn't exist! Create it before running this conversion script. (2011-07-11 15:14:39,229 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl)
java.sql.SQLException: ORA-00942: table or view does not exist

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
        at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
        at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
        at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
        at org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl.areBothTablesPresent(ConvOldPrefsJobImpl.java:215)
        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:203)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
INFO: Old SiteStats Preferences table conversion finished. (2011-07-11 15:14:39,230 QuartzScheduler_Worker-2_org.sakaiproject.sitestats.impl.ConvOldPrefsJobImpl)


-----------------------------------------
Senior Developer
The Center for Media and Instructional Innovation
Shared Solutions ITS
Yale University
135 College Street, Suite 101
New Haven, CT  06510
Office: 203-432-7867

NOTE: Yale ITS will NEVER request passwords or other personal information via email. Messages requesting such information are fraudulent and should be deleted.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110711/0765cf07/attachment.html