[Building Sakai] SiteStats cronjob issue

[Liu, Peter]

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/20120503/76bca98a/attachment.html