Focal Point Banner

As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at for further assistance. Reference the community FAQ to learn more about the community.

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Automatically Restart a Report Caster Job

Read-Only Read-Only Topic
[CLOSED] Automatically Restart a Report Caster Job
Platinum Member
Is there a way to setup RC to automtically restart a job that aborts? I have 2 conditions:
1. The first of the month the Oracle Database is taken down. So jobs scheduled during that time abend.

Yea I could not schedule any job to run during that time but I'm afraid I'll run out of time slots, plus some jobs need to be run by 6 AM for example. So the question is can RC try to rerun the job later?

Message Code Message Text

BTP1010 Schedule Executed Due To NEXTRUNTIME
BTP1020 Starting task: TS0012DB - Daily Feed Report
BTP1020 Task type: MR Standard Report
BTP1020 Task domain: business/business.htm
BTP1020 Retrieving MR report: app/ts0012db
BTP1020 Connecting to server WFNT with execution id MANUSZR
BTP1020 Executing focexec.
BTP1020 TBRACCD_FEED_DATE = 2012/05/01
BTP1020 SQLCODE IS 1034 (HEX: 0000040A)
BTP1020 : ORA-01034: ORACLE not available
BTP1020 : ORA-27101: shared memory realm does not exist
BTP1020 : SVR4 Error: 2: No such file or directory
BTP1010 No report to distribute.

2. Report Caster goes down.
So when it get restarted can jobs that were suppose to run during that time be automatically started. Kind of a look back issue.

This message has been edited. Last edited by: Rick Man,

Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
Posts: 204 | Registered: March 31, 2008Report This Post
posted Hide Post
do you know about 'pre processing conditions'?
Tasks/Edit Tasks/Advanced/Procedures....
you can write up to 2 procedures that run before the caster job itself. [nb: put them in the baseapp.]. This job/jobs could check some status code somewhere, and if you got a good result, then go ahead and run the caster job, but if you get a bad result, then this little fex says:
-SET &&KILL_RPC =  'Y';

and then the caster job itself dies, and doesn't run that time.
you could set your job to run alot...often...sevaral times a day... and its pre-processing fex could check , say, the UPDATE_DATE_TIME in some Oracle file. And if the UPDATE_DATE_TIME is current, then set the KILL_RPC to Y. If that date is old, or yesterday, or whatever you decide, then SET &&KILL_RPC to N or jsut comment out the line.

This way, you get mutliple chances during a day to run your job. If all is well, only 1 will execute. If all is not well, then you'll get many more chances to run.
Make sure you research and understand the SCANBACK feature of Caster, not for this question, but just so you don't get confused.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
posted Hide Post
Good One Susannah...

   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Platinum Member
posted Hide Post
If it is in the current day then the Report Caster will look for all schedules that have a NEXRUNTIME <= SYSTEM TIME.

So, If your job is scheduled at 5 am and if you have disabled your scheduled before 5 am and enabled it at 6 am and it will automatically run the job. Same as the case even if you stop RC and re-start.

Note: I am not saying about the check box to enable in the schedule. i am taking about using the ACTIVE field in the BOTSCHED.

When possible better to use the pre-processor option as Susan mentioned.

Meet us at Summit 2012 : Casestudies: "Customizing ReportCaster"

WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012

Posts: 104 | Location: Indianapolis | Registered: November 08, 2007Report This Post
Platinum Member
posted Hide Post
Thanks for the input. Rao, If the job abends the nextruntime is set for the next run, so restarting the server or doing a scanback doesn't work. I will look into recovery and scanback more maybe it will at least allow me to run all jobs from point A to point B and not have to resubmit them one at a time.

Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
Posts: 204 | Registered: March 31, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Automatically Restart a Report Caster Job

Copyright © 1996-2020 Information Builders