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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to catch error in RC job and not continue with other tasks

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] How to catch error in RC job and not continue with other tasks
 Login/Join
 
Silver Member
posted
I have an RC job that runs every week. It has not given me any error until recently. The steps after the task that errored out got executed and I published an incorrect report. The RC job just creates a report to a shared drive does not send an email of the report that got created.

How do I catch this error and tell RC not to execute the rest of the tasks if I get an error? How can I send a notification to an email so that if there was an error, somebody gets notified and we can react to the error before publishing and incorrect report?

Here's the error that I got during the RC job and would like to catch this:

Connecting to server EDASERVE with execution id admin
Executing focexec.
No report to create.
SQLCODE IS 2706 (HEX: 00000A92) XOPEN: 42S02
: ASA Error -141: Table season not found
L (FOC1405) SQL PREPARE ERROR.
Task finished.


Thanks,
Joel

This message has been edited. Last edited by: Joel,


7.6.6
Windows 2003 Server, Sybase IQ, DB2, SQL Server and Oracle Databases
Excel, HTML and PDF
 
Posts: 34 | Registered: February 20, 2008Report This Post
Guru
posted Hide Post
In Report Caster it seems like each task in a schedule runs on its own and does not look at the previous task status.
The only way I have gotten around this is to put some sort of preprocessing procedure in each task that in some way checks the proper output of the previous task and issues a &KILL_RPC if it is not satisfactory.


(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, 2003Report This Post
Expert
posted Hide Post
You can have "Job 1" create a status file which is then read by "Job 2". Job 2, in turn will run / or not based on the contents of the file created in job 1.

It may be a work arond. But, it's as good as checking a Return Code of a previous job (imho)...




   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
Silver Member
posted Hide Post
Thanks for the reply. I'll try to incorporate your suggestions with the job.

One question, on the Edit Schedule, there's a tab for settings and then a section for Notification. If I use the dropdown "On Error", will this catch the error of the job and send me notification? I noticed that it will always send notification if there are no email attachment for the job. So if I'm just generating the report to file, I will get an error every time.

Thanks,
Joel


7.6.6
Windows 2003 Server, Sybase IQ, DB2, SQL Server and Oracle Databases
Excel, HTML and PDF
 
Posts: 34 | Registered: February 20, 2008Report This Post
Silver Member
posted Hide Post
Hi Joel,

there is a setting for this behaviour in the RC-configuration.
Start -> Programs -> IBI -> ReportCaster -> Dist. Server -> configuration -> edit

Default Setting -> Default processing for no report to distribute
change to warning

regards,
Markus


WF 7.6.6 (MRE,BID, DevStudio, partly RC) on Windows 2003 /Apache/Tomcat
Output: HTML,Excel,PDF,PPT
Adapters: SQL Server, DB2, Oracle
 
Posts: 38 | Location: Austria, Linz | Registered: June 19, 2009Report This Post
Expert
posted Hide Post
That setting is for notification (of job results) not for error trapping...
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report 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] How to catch error in RC job and not continue with other tasks

Copyright © 1996-2020 Information Builders