Focal Point
Report Castor

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4911015222

April 09, 2007, 01:36 AM
Syed
Report Castor
Hi
We are working in Mainframes environment.If we try to schedule the controller process through ReportCaster its giving error while running “THE FOCEXEC PROCEDURE CANNOT BE FOUND: ”.
Include files are not recognized, and when we give the server path in INCLUDE, it is able to locate the procedure.
But even then an error occurs while identifying the Target Mart, it says “Task error: THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED:”

Please let us know if there is any limitation (server dependent) in scheduling reports through the Report Castor.

Regards,
Syed
working on WebFOCUS 7.1.4 using Citrix
Mainframe Server


Using WF 7.1.7/Dev Studio
April 09, 2007, 07:29 AM
FrankDutch
I schedule the reports from the MRE, my first attempt gave me the same errors as you have.
The report caster is in fact a user that should have the proper rights to run a report.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

April 09, 2007, 11:54 AM
BlueZone
Syed :
We have our reporting server (EDA) on the Mainframe, with the WF Client on a Windows Server. The majority of our Focus code is on the mainframe. We never had any issues in scheduling jobs in RC, either with Fexes that are strictly in the MRE or those on the mainframe.

In cases where the code is on the mainframe, the RC schedule is pointed to a dummy MRE member that will have this following one line...

-MRNOEDIT -INCLUDE MNFRMFEX

This will instruct the WF processing engine to look for a program called MNFRMFEX on the mainframe and not in the MRE. Well ofcourse, our WF setup has been configured to connect to the mainframe by default, it being the only data source in our situation. All our data files/DB2-tables and their respective MFDs are on the mainframe and our schedules execute just fine without a hitch.

RC may have its share of limitations (like using MORE in your code, etc), but with the right settings, you should be able to schedule jobs that reside on the mainframe just fine.

Goooooooooooood day !!
Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
April 16, 2007, 12:01 PM
Kerry
Hi Syed,

Has this issue been resolved? Many thanks to Frank and Sandeep's input. Smiler

I ran a bit search on Information Builders' online documents and came across the following topics which may be of interest:

Summary: FOC227 when running from Devstudio Text Editor

Caster Error: BTP1010:The FOCEXEC PROCEDURES CANNOT BE FOUND

Testing Remote Server (SSCTL) via Hub Server:FOC227

(FOC227) THE FOCEXEC PROCEDURE CANNOT BE FOUND: GKESET

Hope this helps. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.