Delay in executing Report Caster scheduling job

Hi Sophie,
It might be worth checking with the server that the clock time
is correct as we had a similar issue a few years back where they had reset
the mainframe clock for daylight saving time but not the WebFocus server
so it was an hour adrift.
It's a stab in the dark but is certainly worth a 2 minute check.

Paul

Developer Studio Release : 7.6.11

Posts: 21 | Location: TataSteel Strip Products UK , Port Talbot , South Wales | Registered: November 28, 2006

Ignored post by Madasabear posted

Tony A

Expert

posted

Report Caster (here) will only process three jobs at a time (able to be set in RC config), any others that get executed will sit in a queue in an order decided by their priority setting. If you have long running RC jobs then this queue may take time to service. Look at the report caster console / status screen to see the queue and it's contents.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

<JG>

posted

Both Tony and Madasabear are making valid points

Another possibility is the your application server is configured for the wrong timezone.

Darin Lee

Virtuoso

posted

And to add to the list of possibilities -- if there happened to be a server or network issue, RC may not have been able to reach an MRE repository or a WF server at the scheduled time so it may keep trying until a proper connection is made. May even be that the RC server was not up at the schedule time so its recovery mode ran the procedure an hour later when it was brought up.

(However, my bet would be on either the Time zone difference or daylight savings issue.)

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

susannah

Expert

posted

I had the same issue when i was in 5.2.
had to change the clock time by hand.
Upgrade, you'll be happy

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Silver Member

posted

Thanks for all the suggestions.

The next question are..
How do we check Report Caster server time? and how do we adjust it?

Many thanks
Sophie

WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML

Posts: 35 | Registered: September 16, 2009

Ignored post by Sophie posted

<JG>

posted

First port of call should be your Unix admin, He/she is the one who will have to change it anyway.

From a WebFOCUS Caster point of view if they are on the same machine
then from a WebFOCUS adhoc window !date will echo back the system date and time and also
tell you what time zone is being used.

If Caster is on a different machine and you have access to the Unix box simple type date.

If you do not have direct Unix logon then ask the admin.

BarryS

Gold member

posted

Hi there is a great technic that explains how to convert Zulu time at the following link: http://www.informationbuilders...developers/zulu.html

Then you can build a update of the botsched and upate the NEXTRUNTIME to affect when the job will be run next.

WebFOCUS 8103, Windows, App Studio

Posts: 80 | Location: NYC | Registered: November 13, 2008

Ignored post by BarryS posted

Silver Member

posted

Thanks for the information.

Our Unix machine time is corrected and our Report Caster is on the same machine. But the scheduling job is run an hour later than when it was scheduled.

Is there somewhere within Report Caster where we can check it's time and if it's incorrected, how do we adjust it?

Thanks

WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML

Posts: 35 | Registered: September 16, 2009

Ignored post by Sophie posted

susannah

Expert

posted

5.2 as i recall did not adjust for daylight savings time, but then i was on a wintell server.
7.n is perfect, so you'll enjoy the upgrade.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Silver Member

posted

Hi,

The Report Caster must either have it's own time registered some where or obtained the time from some where for executing the scheduled jobs.

My question was how do we find out it's time in order to rectify it?

Our scheduled jobs are currently run an hour later.

Any ideas or suggestions is much appreciated
Thanks

WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML

Posts: 35 | Registered: September 16, 2009

Ignored post by Sophie posted

susannah

Expert

posted

sophie , caster runs on GMT.
if you read the article Barry pointed you to, you'll see.
That article was written in version 5.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Silver Member

posted

Hi,

Sorry I must be not making myself clear here. I know how to check and changed Report Caster scheduled time for jobs.

Our issue is the scheduled report run an hour late because according to the Report Caster, it's (for example) 9am at the time instead of 10am (this happened after the daylight saving recently).

Therefore, my question is where do the Report Caster registered it's time to excecute the scheduled jobs?

I hope this make a bit clearer...

Thanks

WebFOCUS 5.2 upgrading to the latest version at the moment.
UNIX
HTML

Posts: 35 | Registered: September 16, 2009

Ignored post by Sophie posted

N.Selph

Guru

posted

When you look in the schedule, you see a specific time. But the time recorded in BOTSCHED for that schedule is relative to GMT at the time you first scheduled it. So if you first scheduled some recurring job to run at 9am in the summer, and another one to run at 9am in the winter they run one hour apart.

As BarryS has said, this is stored in "Zulu" time and you need to look at the article he referenced to see where this is.

(Prod: WebFOCUS 7.7.03: Win 2008 & AIX hub/Servlet Mode; sub: AS/400 JDE; mostly Self Serve; DBs: Oracle, JDE, SQLServer; various output formats)

Posts: 391 | Location: California | Registered: April 14, 2003

Ignored post by N.Selph posted

CLH

Platinum Member

posted

Hi,

Here is a shot in the dark, At one point we had a java version that calculated daylight savings time wrong so we were off by an hour.

So may want to check the java version.

Webfocus 8.0.7 on Windows

Posts: 176 | Location: Ohio | Registered: October 26, 2006

Ignored post by CLH posted