[Building Sakai] Site Stats jobs that fail

[Nuno Fernandes]

Just a small correction on the previous email:

> (...) and set that value plus one (+1) as the last event id on (...)
>
Should be:

(...) and set that value as the last event id on (...)

The provided SQL is correct.

Thanks,
Nuno


> Since we can't specify target table 'SST_JOB_RUN' for update in FROM clause
> (as subqueries), we have to issue 3 sql queries:
>
>    - *(1)* select max(END_EVENT_ID) from SST_JOB_RUN)
>    - *(2)* select max(ID) from SST_JOB_RUN)
>
> The first (1) query will give you the last event id processed;
> The second (2) will give the last job id;
> Replace these on the query below and execute it:
>
>    - update SST_JOB_RUN set END_EVENT_ID = *(1)* where ID = *(2)*;
>
>
> However, I would like more information to understand why you have
> END_EVENT_ID = 0 on your last job run.
>
>    - Did you remove the entries from SST_JOB_RUN before the job started?
>    - Are there any related ERRORs on you catalina.out logs?
>    - Are your previous entries from SST_JOB_RUN equal to the one you
>    referred?
>
> It would be great if you could provide me you further information!
>
> Thank you,
> Nuno
>
>
> 2009/9/19 Sean Keesler <sean.keesler at threecanoes.com>
>
>> I am seeing a site stat job fail with the following log entries:
>>
>> INFO: Starting job: DEFAULT.SiteStats Event Aggregator (2009-09-18
>> 20:54:11,666
>> QuartzScheduler_Worker-3_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
>> WARN: No events were returned - nothing to do. (2009-09-18 20:54:11,668
>> QuartzScheduler_Worker-3_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
>> INFO: Summary: 0 events processed (ids: 0 - 0) in 0s (2009-09-18
>> 20:54:11,669
>> QuartzScheduler_Worker-3_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
>> INFO: Finishing job: DEFAULT.SiteStats Event Aggregator (2009-09-18
>> 20:54:11,670
>> QuartzScheduler_Worker-3_org.sakaiproject.sitestats.impl.StatsAggregateJobImpl)
>>
>> The last record in SST_JOBS_RUN is:
>>
>> ID: 662
>> JOB_START_DATE: 2009-09-18 20:54:11
>> JOB_END_DATE: 2009-09-18 20:54:11
>> START_EVENT_ID: 0
>> END_EVENT_ID: 0
>> LAST_EVENT_DATE: NULL
>>
>> What is the right procedure to fix this?
>>
>>
>>
>> Sean Keesler
>> 130 Academy Street
>> Manlius, New York 13104 USA
>> 315-663-7756
>> sean.keesler at threecanoes.com
>>
>> _______________________________________________
>> sakai-dev mailing list
>> sakai-dev at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>> TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
>> "unsubscribe"
>>
>
>
>
> --
> Nuno Fernandes  [www.linkedin.com/in/nfgrilo]
> Software Developer - UFP-UV  [Universidade Virtual]
> Software Developer - Sakai Foundation  [sakaiproject.org]
> Sakai Fellow 2008 - Sakai Foundation  [
> confluence.sakaiproject.org/confluence/x/FIF9AQ]
>
> Universidade Fernando Pessoa  [www.ufp.pt]
> Praça 9 de Abril, 349
> 4249-004 Porto
> tel: + 351 22 507 13 00
> fax: + 351 22 550 82 69
>



-- 
Nuno Fernandes  [www.linkedin.com/in/nfgrilo]
Software Developer - UFP-UV  [Universidade Virtual]
Software Developer - Sakai Foundation  [sakaiproject.org]
Sakai Fellow 2008 - Sakai Foundation  [
confluence.sakaiproject.org/confluence/x/FIF9AQ]

Universidade Fernando Pessoa  [www.ufp.pt]
Praça 9 de Abril, 349
4249-004 Porto
tel: + 351 22 507 13 00
fax: + 351 22 550 82 69
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090921/346a1cd4/attachment.html