August 29, 2007, 07:34 PM
Jim DaleError Report from Reportcaster
We are migrating about 100 reports from mainframe to WebFocus and scheduling them through ReportCaster.
I don't need to know how to do this now because
we're swamped with the conversion but I'd like to know if anyone has ever written a Focus Report against the ReportCaster tables to determine if any reports have abended.
We had something like this on the mainframe and will need someting similar so we don't have to go through each log each day to see if the report ran.
Thanks,
Jim
7.13
Oracle
Unix
August 30, 2007, 04:37 AM
RolandHi Jim,
Have a look at column ERROR in BOTLOG. It is '1' for the execution of a schedule, if there is some sort of error message in the log.
Then in BOTLOG2 you find ERROR2. This column is set to 'Y', if the line contains an error message. The message itself tells you more.
August 30, 2007, 11:22 AM
Darin LeeYou just have to make sure the master files are in your app path. At our site, we use APP APPENDPATH rcaster in administrative user profiles to limit those who can report against these tables (since some of them contain secure information)
August 30, 2007, 12:28 PM
Jim DaleThanks guys for the fast turn around. This will help me very much when I get ready to write the report. If I have any more questions I'll submit another post.
Thanks again,
Jim