[Building Sakai] SiteStats cronjob issue

[Liu, Peter]

The problem is solved.  Actually, there is nothing wrong with the latest SiteStats tool.  We have copied production Data into the Test DB and it has over millions of  events for updating into SiteStats DB.  Since we have allow the max updating events upto 50000 only.   That is why we didn't see notable changes after each Quartz job run.

Thanks,
peter

From: Peter liu <peter.liu at yale.edu<mailto:peter.liu at yale.edu>>
Date: Wed, 2 May 2012 22:24:38 -0400
To: Sakai Developers <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Subject: [Building Sakai] SiteStats cronjob issue

Hi All,
We are planning to upgrade the SiteStats tool from 2.1.7 to current 2.8.x –rev: 103117.  Everything looks great  on the Sakai 2.8.x.  However, it seems the scheduler cronJob (‘SiteStats Event Aggregator’) is not updating such as the table ‘SST_RESOURCES’ and ‘sst_events’.
We have run it on external DB and the setting as shown below and it works great with 2.1.7 tag.  Now, it seems that the SST table is not updating except the table ‘sst_job_run’ is updating.

Does anyone have such issue? Or do we miss something in the configuration?  Any suggestion will be highly appreciated.

Thanks a lot!
Peter

- - - - -  - - - -  - - - - -  - - -  - - - -  - - - -  - - - - -
## SiteStats tool DB config settings
sitestats.db=external
sitestats.externalDb.auto.ddl=false
sitestats.externalDb.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
driverClassName at org.sakaiproject.sitestats.externalDbDataSource=oracle.jdbc.driver.OracleDriver<mailto:driverClassName at org.sakaiproject.sitestats.externalDbDataSource=oracle.jdbc.driver.OracleDriver>
url at org.sakaiproject.sitestats.externalDbDataSource=jdbc<mailto:url at org.sakaiproject.sitestats.externalDbDataSource=jdbc>:oracle:thin:@manning.its.yourschool.edu:1521:XXX
username at org.sakaiproject.sitestats.externalDbDataSource=<mailto:username at org.sakaiproject.sitestats.externalDbDataSource=> sitestats_XXX
password at org.sakaiproject.sitestats.externalDbDataSource=XXXX<mailto:password at org.sakaiproject.sitestats.externalDbDataSource=XXXX>
# school wide stats
serverWideStatsEnabled at org.sakaiproject.sitestats.api.StatsManager=true<mailto:serverWideStatsEnabled at org.sakaiproject.sitestats.api.StatsManager=true>

##setup run quartz job in period internval
collectThreadEnabled at org.sakaiproject.sitestats.api.StatsUpdateManager=false<mailto:collectThreadEnabled at org.sakaiproject.sitestats.api.StatsUpdateManager=false>
#lastJobRunDateVisible at org.sakaiproject.sitestats.api.StatsManager=true<mailto:#lastJobRunDateVisible at org.sakaiproject.sitestats.api.StatsManager=true>
maxEventsPerRun at org.sakaiproject.sitestats.api.StatsAggregateJob=50000<mailto:maxEventsPerRun at org.sakaiproject.sitestats.api.StatsAggregateJob=50000>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120504/3a7c5d44/attachment.html