You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by 叶双明 <ye...@gmail.com> on 2012/06/18 17:34:50 UTC

problem of TemporalExpression

Hi all,

seed-initial data in framework\service\data\ScheduledServices.xml:

<TemporalExpression tempExprId="MIDNIGHT_DAILY"
tempExprTypeId="FREQUENCY" description="Daily Midnight"
date1="2000-01-01 00:00:00.000" integer1="5" integer2="1"/>
    <JobSandbox jobId="PURGE_OLD_JOBS" jobName="Purge Old Jobs"
runTime="2000-01-01 00:00:00.000" serviceName="purgeOldJobs"
poolId="pool" runAsUser="system" tempExprId="MIDNIGHT_DAILY"
maxRecurrenceCount="-1"/>

It seem should be run once every, but in my system, it became run
three times every day,


JOB	ID	POOL	RUN TIME	START DATE/TIME	SERVICE	STATUS	END DATE/TIME	
Purge Old Jobs	 PURGE_OLD_JOBS	 pool	 2000-01-01 00:00:00.000	
2012-06-18 15:03:18.964	purgeOldJobs	 Finished
Purge Old Jobs	 10081	 pool	 2012-06-15 00:00:00.000	 2012-06-15
00:00:08.088	purgeOldJobs	 Failed
Purge Old Jobs	 10083	 pool	 2012-06-15 00:00:00.000	 2012-06-15
00:00:08.092	purgeOldJobs	 Finished
Purge Old Jobs	 10088	 pool	 2012-06-16 00:00:00.000	 2012-06-16
00:00:13.826	purgeOldJobs	 Finished
Purge Old Jobs	 10089	 pool	 2012-06-16 00:00:00.000	 2012-06-16
00:00:13.834	purgeOldJobs	 Failed
Purge Old Jobs	 10101	 pool	 2012-06-17 00:00:00.000	 2012-06-17
00:00:10.771	purgeOldJobs	 Finished
Purge Old Jobs	 10102	 pool	 2012-06-17 00:00:00.000	 2012-06-17
00:00:10.774	purgeOldJobs	 Failed
Purge Old Jobs	 10108	 pool	 2012-06-18 00:00:00.000	 2012-06-18
00:00:07.101	purgeOldJobs	 Finished
Purge Old Jobs	 10106	 pool	 2012-06-18 00:00:00.000	 2012-06-18
00:00:07.098	purgeOldJobs	 Finished
Purge Old Jobs	 10115	 pool	 2012-06-19 00:00:00.000	  	purgeOldJobs	
Pending	  	Cancel Job
Purge Old Jobs	 10112	 pool	 2012-06-19 00:00:00.000	  	purgeOldJobs	
Pending	  	Cancel Job
Purge Old Jobs	 10119	 pool	 2012-06-19 00:00:00.000	  	purgeOldJobs	
Pending	  	Cancel Job

Any idea?
Thanks!
-- 
叶双明

Re: problem of TemporalExpression

Posted by Adrian Crum <ad...@sandglass-software.com>.
Since no one else is experiencing this problem, you should investigate 
what is different about your installation. Did you run the installation 
script more than once? What have you changed?

-Adrian

On 6/26/2012 1:30 PM, 叶双明 wrote:
> Can anybody help?
>
> 2012/6/18 叶双明 <ye...@gmail.com>:
>> Hi all,
>>
>> seed-initial data in framework\service\data\ScheduledServices.xml:
>>
>> <TemporalExpression tempExprId="MIDNIGHT_DAILY"
>> tempExprTypeId="FREQUENCY" description="Daily Midnight"
>> date1="2000-01-01 00:00:00.000" integer1="5" integer2="1"/>
>>     <JobSandbox jobId="PURGE_OLD_JOBS" jobName="Purge Old Jobs"
>> runTime="2000-01-01 00:00:00.000" serviceName="purgeOldJobs"
>> poolId="pool" runAsUser="system" tempExprId="MIDNIGHT_DAILY"
>> maxRecurrenceCount="-1"/>
>>
>> It seem should be run once every, but in my system, it became run
>> three times every day,
>>
>>
>> JOB     ID      POOL    RUN TIME        START DATE/TIME SERVICE STATUS  END DATE/TIME
>> Purge Old Jobs   PURGE_OLD_JOBS  pool    2000-01-01 00:00:00.000
>> 2012-06-18 15:03:18.964 purgeOldJobs     Finished
>> Purge Old Jobs   10081   pool    2012-06-15 00:00:00.000         2012-06-15
>> 00:00:08.088    purgeOldJobs     Failed
>> Purge Old Jobs   10083   pool    2012-06-15 00:00:00.000         2012-06-15
>> 00:00:08.092    purgeOldJobs     Finished
>> Purge Old Jobs   10088   pool    2012-06-16 00:00:00.000         2012-06-16
>> 00:00:13.826    purgeOldJobs     Finished
>> Purge Old Jobs   10089   pool    2012-06-16 00:00:00.000         2012-06-16
>> 00:00:13.834    purgeOldJobs     Failed
>> Purge Old Jobs   10101   pool    2012-06-17 00:00:00.000         2012-06-17
>> 00:00:10.771    purgeOldJobs     Finished
>> Purge Old Jobs   10102   pool    2012-06-17 00:00:00.000         2012-06-17
>> 00:00:10.774    purgeOldJobs     Failed
>> Purge Old Jobs   10108   pool    2012-06-18 00:00:00.000         2012-06-18
>> 00:00:07.101    purgeOldJobs     Finished
>> Purge Old Jobs   10106   pool    2012-06-18 00:00:00.000         2012-06-18
>> 00:00:07.098    purgeOldJobs     Finished
>> Purge Old Jobs   10115   pool    2012-06-19 00:00:00.000                purgeOldJobs
>> Pending         Cancel Job
>> Purge Old Jobs   10112   pool    2012-06-19 00:00:00.000                purgeOldJobs
>> Pending         Cancel Job
>> Purge Old Jobs   10119   pool    2012-06-19 00:00:00.000                purgeOldJobs
>> Pending         Cancel Job
>>
>> Any idea?
>> Thanks!
>> --
>> 叶双明
>
>



Re: problem of TemporalExpression

Posted by 叶双明 <ye...@gmail.com>.
Can anybody help?

2012/6/18 叶双明 <ye...@gmail.com>:
> Hi all,
>
> seed-initial data in framework\service\data\ScheduledServices.xml:
>
> <TemporalExpression tempExprId="MIDNIGHT_DAILY"
> tempExprTypeId="FREQUENCY" description="Daily Midnight"
> date1="2000-01-01 00:00:00.000" integer1="5" integer2="1"/>
>    <JobSandbox jobId="PURGE_OLD_JOBS" jobName="Purge Old Jobs"
> runTime="2000-01-01 00:00:00.000" serviceName="purgeOldJobs"
> poolId="pool" runAsUser="system" tempExprId="MIDNIGHT_DAILY"
> maxRecurrenceCount="-1"/>
>
> It seem should be run once every, but in my system, it became run
> three times every day,
>
>
> JOB     ID      POOL    RUN TIME        START DATE/TIME SERVICE STATUS  END DATE/TIME
> Purge Old Jobs   PURGE_OLD_JOBS  pool    2000-01-01 00:00:00.000
> 2012-06-18 15:03:18.964 purgeOldJobs     Finished
> Purge Old Jobs   10081   pool    2012-06-15 00:00:00.000         2012-06-15
> 00:00:08.088    purgeOldJobs     Failed
> Purge Old Jobs   10083   pool    2012-06-15 00:00:00.000         2012-06-15
> 00:00:08.092    purgeOldJobs     Finished
> Purge Old Jobs   10088   pool    2012-06-16 00:00:00.000         2012-06-16
> 00:00:13.826    purgeOldJobs     Finished
> Purge Old Jobs   10089   pool    2012-06-16 00:00:00.000         2012-06-16
> 00:00:13.834    purgeOldJobs     Failed
> Purge Old Jobs   10101   pool    2012-06-17 00:00:00.000         2012-06-17
> 00:00:10.771    purgeOldJobs     Finished
> Purge Old Jobs   10102   pool    2012-06-17 00:00:00.000         2012-06-17
> 00:00:10.774    purgeOldJobs     Failed
> Purge Old Jobs   10108   pool    2012-06-18 00:00:00.000         2012-06-18
> 00:00:07.101    purgeOldJobs     Finished
> Purge Old Jobs   10106   pool    2012-06-18 00:00:00.000         2012-06-18
> 00:00:07.098    purgeOldJobs     Finished
> Purge Old Jobs   10115   pool    2012-06-19 00:00:00.000                purgeOldJobs
> Pending         Cancel Job
> Purge Old Jobs   10112   pool    2012-06-19 00:00:00.000                purgeOldJobs
> Pending         Cancel Job
> Purge Old Jobs   10119   pool    2012-06-19 00:00:00.000                purgeOldJobs
> Pending         Cancel Job
>
> Any idea?
> Thanks!
> --
> 叶双明



-- 
叶双明