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     [SOLVED] Report fails when Shceduled in report caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Report fails when Shceduled in report caster
 Login/Join
 
Member
posted
Hi,

I'm little new to webfocus.
I have created compound report and when I run it.

but it gives error when I create a schedule in report caster.
here is the report

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=CM, $
SECTION=section1, LAYOUT=ON, METADATA='0.005^0.005^0.005^0.005^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4, SHOW_GLOBALFILTER=OFF, $

PAGELAYOUT=1, NAME='Page layout 13', text='Page layout 13', TOC-LEVEL=1, BOTTOMMARGIN=0.001, RIGHTMARGIN=0.001, TOPMARGIN=0.001, METADATA='BOTTOMMARGIN=0.001,RIGHTMARGIN=0.001, TOPMARGIN=0.001,LEFTMARGIN=0,RIGHTMARGIN=0,', $
-*OBJECT=IMAGE, NAME='image002', IMAGE=MWH-Mainzeal-logo-V2.gif, POSITION=(0.635 0.529), DIMENSION=(5.0 2.0), METADATA='Z-INDEX: 107; POSITION: absolute; WIDTH: 5cm; HEIGHT: 2cm; TOP: 0.529cm; LEFT: 0.635cm', $
-*OBJECT=IMAGE, NAME='image003', IMAGE=weeklynew/aav3.gif, POSITION=(15.635 0.529), DIMENSION=(5.0 2.0), METADATA='Z-INDEX: 107; POSITION: absolute; WIDTH: 5cm; HEIGHT: 2cm; TOP: 0.529cm; LEFT: 15.53cm', $
-*COMPONENT='graph6', TEXT='graph6', TOC-LEVEL=2, POSITION=(0.741 3.545), DIMENSION=(19.579 14.615), COMPONENT-TYPE=GRAPH, METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 19.579cm; HEIGHT: 14.615cm; TOP: 3.545cm; LEFT: 0.741cm', $
OBJECT=STRING, NAME='text004', TEXT='Canterbury Earthquake Reinstatement', POSITION=(5.635 7.423), MARKUP=ON, WRAP=ON, DIMENSION=(16.906 1.600), style=bold, METADATA='', $
COMPONENT='report00199', TEXT='report00199', TOC-LEVEL=2, POSITION=(7.635 12.423), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.159cm; HEIGHT: 1.25cm; TOP: 6.423cm; LEFT: 0.30cm', $
COMPONENT='report00200', TEXT='report00200', TOC-LEVEL=2, POSITION=(8.635 15.100), DIMENSION=(* *), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.159cm; HEIGHT: 1.25cm; TOP: 8.1cm; LEFT: 0.30cm', $
OBJECT=STRING, NAME='text444', TEXT='Prepared By', POSITION=(9 20.423), MARKUP=ON, WRAP=ON, DIMENSION=(9.906 1.600), style=bold, METADATA='', $
-*OBJECT=IMAGE, NAME='image002', IMAGE=MWH-Mainzeal-logo-V2.gif, POSITION=(8.635 22.500), DIMENSION=(5.0 2.0), METADATA='Z-INDEX: 107; POSITION: absolute; WIDTH: 5cm; HEIGHT: 2cm; TOP: 0.600cm; LEFT: 0.635cm', $



END

SET COMPONENT='report00199'
-*component_type report
-INCLUDE weeklynew/current_weekno_all
SET COMPONENT='report00200'
-*component_type report
-*INCLUDE weeklynew/current_date_only_all

COMPOUND END

First error occurs when I display an image is says image not found
then it complains procedure not found if I use include like below
-INCLUDE current_weekno_all
but if I add the folder name then like below
-INCLUDE weeklynew/current_weekno_all
it complain another error saying file description not found (which is inside the included file)

instead of using Includes if I cut and paste the code from fex file in to this then report works fine.

can any one please point me where 'm going wrong?

any help would be much appreciated.


thanks

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


Prod: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 7.0 / DBMS- MSSQL 2008
Dev: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 6.0/ DBMS - MSSQL 2008
 
Posts: 4 | Registered: April 19, 2012Report This Post
Platinum Member
posted Hide Post
Might be related to the ReportCaster Exection ID. Have a look at this thread,
http://forums.informationbuild...977019295#9977019295


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Member
posted Hide Post
Thanks for the quick response.
I'm using the admin account to execute the report
the same works for the rest of the reports.
Infaact it works for this if I remove the images and remove includes.
(Instead includes if I copy and paste the code from the other fex then this works)

Any way I'll try using another user to execute the report.

Any other clues?

Much appriciated.


Prod: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 7.0 / DBMS- MSSQL 2008
Dev: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 6.0/ DBMS - MSSQL 2008
 
Posts: 4 | Registered: April 19, 2012Report This Post
Platinum Member
posted Hide Post
To avoid the error 'Description not found', try prefixing the master file with the app name.
For example: TABLE FILE weeklynew/MASTERFILE


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
 
Posts: 165 | Registered: September 29, 2008Report This Post
Member
posted Hide Post
Thanks Atturhari,
it does work .
but still I have issue with images.
it complains Image not found. even if I add the folder name in front of the image name.
here is the error
IMAGE FILE NOT FOUND: weeklynew/aav3.gif

Any idea?
Thanks for your help


Prod: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 7.0 / DBMS- MSSQL 2008
Dev: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 6.0/ DBMS - MSSQL 2008
 
Posts: 4 | Registered: April 19, 2012Report This Post
Guru
posted Hide Post
Your images are in the application folder weeklynew, right? Is the application folder weeklynew in the APP PATH? Try adding it to the APP PATH or try adding APP PREPENDPATH weeklynew to beginning of your fex.


WebFOCUS 8.1.05M Unix Self-Service/MRE/Report Caster - Outputs Excel, PDF, HTML, Flat Files
 
Posts: 320 | Location: Memphis, TN | Registered: February 12, 2008Report This Post
Member
posted Hide Post
Thanks Mighty Max,

Adding App Path on top of my report fixed the issue.

Thanks of Lot


Prod: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 7.0 / DBMS- MSSQL 2008
Dev: Webfocus 7.7 SP2/ Windows 2008 R2 Tomcat 6.0/ DBMS - MSSQL 2008
 
Posts: 4 | Registered: April 19, 2012Report 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     [SOLVED] Report fails when Shceduled in report caster

Copyright © 1996-2020 Information Builders