Custom expression in until field (timer)

Carlos A

Hello.

I'm trying to set a custom expression in the until field of a timer in my BPEL.

I need it to wait until 10:30 a.m. of the next day (+1 day to the current day) and then continue with the process.

This is the current expression I'm using in the timer:

<wait name="Waiting" until="xp20:add-dayTimeDuration-to-dateTime(concat(xp20:current-date(), 'T10:30:00'), 'P1D')"/>

The problem is that the BPEL instance goes to the timer (in SOA server) but seems that the expression is never being satisfied, so the timer is always waiting and it is not possible to continue with the rest of the process.

What am I doing wrong in the expression of the timer?

Thanks for your help!

Martien van den Akker

Hi,

I'd create a separate variable and use an assign with the expression to determine the wait. In the wait refer to that variable. THe advantage is that in the flow trace you can check if the resulting value is what you expect.

Regards,
Martien

Carlos A

Hi Martien.

The thing is that the timer seems to indicate a correct date and hour (pelase check the picture), but it is never been executed.

The same is indicated into the audit trail of the BPEL instance:

Any other idea?

Hemanth Lakkaraju-Oracle

The expressions defaults to UTC timezone. Does the server timezone match?

Carlos A

The timezone should be UTC+1 (Spain).

How should I indicate this into the expression?

Hemanth Lakkaraju-Oracle

Try using fn:adjust-dateTime-to-timezone something like on below lines.

xp20:add-dayTimeDuration-to-dateTime(string(fn:adjust-dateTime-to-timezone(xsd:dateTime(concat(xp20:current-date(), 'T10:30:00')), xsd:dayTimeDuration("PT1H"))), 'P1D')

vladodias

Hi mate,

What version are you running? On 10g and 11g you might need to tune quartz threads... see Doc ID 748879.1...

Tuning Quartz Scheduler when Wait and OnAlarm Activities do not Fire (Doc ID 748879.1)

The procedure to tune differs according to the version, 10g has a file resources-quartz.properties, on 11g the BPEL Engine threads can be tuned in the EM Console...

Cheers,

Vlad

Carlos A

Hi.

I'm using 11g version.

Martien van den Akker

Cool! In 2008 I built a scheduler application in BPEL 10g, using the wait activity. Now I'm asked to look into upgrading this. I never had problems with this.

But good to have this in mind. I'll put this on my slack.

Regards,
Martien

Carlos A

Hi Hemanth.

I'm trying your idea but the problem is that the expression is not recognising the funcion--> fn:adjust-dateTime-to-timezone()

Do you know why I'm not able to use this function? Could it be because the BPEL version that I'm using (1.1)?

Thanks!

Martien van den Akker

Hi,

What I would do is to create a separate variable and assign the expression to that variable.

Then use that variable in the expression of your wait. If you run it, then in the flow trace you can verify of the expression results in the value you expect.

It should work in BPEL 1.1, based on this principle I created a job scheduler in BPEL 10g: https://blog.darwin-it.nl/2008/01/how-to-create-bpel-job-scheduler.html

Regards,
Martien