Focal Point
Compound Report problem in Report Caster

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

September 06, 2007, 05:29 AM
hiten
Compound Report problem in Report Caster
Hi,

I am having a problem when trying to run a report through the ReportCaster Schedule Management. The report has compound reports which it cannot find. They are all located in the sps folder. The task log is shown below for the process.

Could anyone plase help with this problem?

Thanks in advance.



"Job Description: sps_targets_actuals_all

User: hpatel06
Procedure: J12jcupdf06f
Schedule ID: S12jb4637g05
Start Time: 2007-09-06 09:25:42 AM
End Time: 2007-09-06 09:25:42 AM
Starting worker thread
Starting task: Task 1
Task type: EDA RPC
Procedure name: sps/targets_actuals_all
Connecting to server EDASERVE with execution id webfocus
Executing focexec.
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_dmu
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_aad
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_fr_os
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_cse
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_bal
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_hls
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_emt
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_ies
THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_hum
IMAGE FILE UNREADABLE OR INVALID: spslogo_withstrapline.gif
Error found in Coordinated Compound Report: At Component DfltCmpt1
Compound Report is TERMINATING.....
Task error: THE FOCEXEC PROCEDURE CANNOT BE FOUND: targets_actuals_dmu
No report to distribute. "


Prod: WF 7.6.1 platform Windows, databases: msSQL2000, msSQL2005, IE6
September 06, 2007, 05:49 AM
FrankDutch
To make it easier to help we would like you to update your signature so we know what version you are using.

Next please post your fex or at least a part of it.

Does the compund report have all the detail included in one fex.
Does it run from MRE?

The logo seems to give a problem too, where is it located?




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

September 06, 2007, 08:52 AM
hiten
Hi the version is WF 7.6.1

It does run from MRE without any problems.

The logo is in the same location as all the fex files.

Here is part of the fex
"SET COMPONENT='DfltCmpt1'
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
IF READLIMIT EQ 1
ON TABLE SET PREVIEW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE targets_actuals_dmu
SET COMPONENT='report3'
-*component_type report
-INCLUDE targets_actuals_aad
SET COMPONENT='report5'
-*component_type report
-INCLUDE targets_actuals_fr_os
SET COMPONENT='report7'
-*component_type report
-INCLUDE targets_actuals_cse
SET COMPONENT='report8'
-*component_type report
-INCLUDE targets_actuals_bal
SET COMPONENT='report2'
-*component_type report
-INCLUDE targets_actuals_hls
SET COMPONENT='report4'
-*component_type report
-INCLUDE targets_actuals_emt
SET COMPONENT='report6'
-*component_type report
-INCLUDE targets_actuals_ies
SET COMPONENT='report9'
-*component_type report
-INCLUDE targets_actuals_hum
COMPOUND END"

Thanks for your help.


Prod: WF 7.6.1 platform Windows, databases: msSQL2000, msSQL2005, IE6
September 06, 2007, 09:22 AM
RickW
Sounds like you may need to have the folder in the Application Path on the server.


WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
September 06, 2007, 09:25 AM
FrankDutch
quote:
-INCLUDE targets_actuals_bal


I would suggest to change all these lines in

-INCLUDE app/targets_actuals_bal

etc

See if that will work

I also noticed an error on your gif file, that might give a problem too

Is your Reportcaster process running on the same machine?




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

September 06, 2007, 10:05 AM
hammo1j
I think either Frank or Rick is correct according to whether rcaster is running via the mre or application options.

mre attempts to resolve -INCLUDE at the client
(and autoprompt for unresolved amper variables within the -INCLUDE)
whereas the application version will resolve at the server.

To force MRE to resolve -INCLUDE on the server
&&INCLUDE.EVAL include name with -SET &&INCLUDE = '-INCLUDE' ; in EDASPROF.



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
September 06, 2007, 12:15 PM
hiten
Including the folder path in the INCLUDE statement had solved the porblem.

Thanks for everyones help.
Hiten


Prod: WF 7.6.1 platform Windows, databases: msSQL2000, msSQL2005, IE6