Re: Scheduled job problem

[Tomek <to...@wp.pl>]

Unfortunelly the problem still occurs.

I load the seed data (my job definition is part of seed data) every 
time, before I launching the Ofbiz. As far as I know, the OFBiz delete 
rows from the job_sandbox table sometimes. So, sometime I insert new 
record into job_sandbox table after the Ofbiz delete some rows in the 
same table. It is possible that the problem is connected with it?

On 11.04.2022 23:27, Tomek wrote:
> Thank you for your response.
>
> I think it is possible that the service run time is longer than the 5 
> minutes. So, I try to use the semaphore settings. I hope that solve my 
> problem :)
>
> Tomek
>
>
> On 11.04.2022 22:33, Michael Brohl wrote:
>> Hi,
>>
>> is it possible that your job run time is longer than the 5 minutes 
>> scheduling interval and it is not configured against parallel execution?
>>
>> If yes, consider using the semaphore settings for your service (see 
>> [1]).
>>
>> Best regards,
>>
>> Michael Brohl
>>
>> ecomify GmbH - www.ecomify.de
>>
>>
>> [1] 
>> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=7045171#ServiceEngineGuide-serviceDefinition
>>
>>
>>
>> Am 11.04.22 um 21:27 schrieb Tomek:
>>> Hi,
>>>
>>> I have created a job:
>>>
>>> <TemporalExpression tempExprId="partial-update-offer"
>>>                         tempExprTypeId="FREQUENCY"
>>>                         description="Every 5 minutes"
>>>                         integer1="12"
>>>                         integer2="5"/>
>>>
>>> <JobSandbox jobId="partial-update-offer"
>>>                         jobName="Partial update offer"
>>>                         runTime="2021-12-15 14:36:00.00"
>>>                         serviceName="partialUpdateOfferJob"
>>>                         poolId="pool"
>>>                         runAsUser="system"
>>>                         tempExprId="partial-update-offer"
>>>                         maxRecurrenceCount="-1"/>
>>>
>>> I would like to run partialUpdateOfferJob service every 5 minutes. 
>>> In the beginning every thing is ok but after some time the service 
>>> is running two (or even more) times at similar time. Here is a part 
>>> of my data stored in job_sandbox table:
>>>
>>> job_id    job_name                run_time status_id parent_job_id
>>> 269925    Partial update offer    2022-04-11 17:12:44.883000 
>>> SERVICE_QUEUED         partial-update-offer
>>> 269924    Partial update offer    2022-04-11 17:12:44.686000 
>>> SERVICE_QUEUED         partial-update-offer
>>> 269923    Partial update offer    2022-04-11 17:12:44.526000 
>>> SERVICE_QUEUED         partial-update-offer
>>> 269897    Partial update offer    2022-04-11 16:12:52.199000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269896    Partial update offer    2022-04-11 16:12:52.049000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269895    Partial update offer    2022-04-11 16:12:51.800000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269880    Partial update offer    2022-04-11 15:33:06.260000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269879    Partial update offer    2022-04-11 15:32:55.404000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269878    Partial update offer    2022-04-11 15:32:55.201000 
>>> SERVICE_FINISHED         partial-update-offer
>>> 269851    Partial update offer    2022-04-11 14:53:05.134000 
>>> SERVICE_FINISHED         partial-update-offer
>>>
>>> How can i repair it?
>>>
>>> BTW: why the service is running at irregular time period?
>>>