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 community@tibco.com 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     Compound Report problem in Report Caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Compound Report problem in Report Caster
 Login/Join
 
Member
posted
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
 
Posts: 12 | Registered: June 01, 2007Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: June 01, 2007Report This Post
Platinum Member
posted Hide Post
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
 
Posts: 125 | Location: New England | Registered: February 20, 2007Report This Post
Virtuoso
posted Hide Post
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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Master
posted Hide Post
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
 
Posts: 888 | Location: Airstrip One | Registered: October 06, 2006Report This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: June 01, 2007Report 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     Compound Report problem in Report Caster

Copyright © 1996-2020 Information Builders