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     multiple fex html report timeout - advice?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
multiple fex html report timeout - advice?
 Login/Join
 
Guru
posted
Hi,

I have an HTML report that consolidates about 15 procedures onto one screen output. Rather than chaining the procedures together into one .fex, I chose to put them in an html page to control the printing output.

When I run the report, some sections will load right away, some take their time, and others return a "page cannot be displayed" error. I am pretty sure I am hitting the server too hard, because if I split the procedures into two html files, they usually return every section without the error.

Even when it does work properly, it still takes a long time to run. I have investigated scheduling via report caster, but I don't believe I am able to schedule a html page, just procedures.

I thought of a possible solution, which is to take each individual procedure, schedule it with report caster and then publish it back to the MRE. I would then build a html page that imports these casted results, and would load quickly. Each time I re-ran the report, I would over-write the old html reports, and somehow update the consolidated html report with the new values.

This did not work, as the report caster publishes each report to the MRE with a timestamp in the folder name. How would I reference the reports if the folder always changes, right? It also recently occured to me that the html report would copy the code into itself, rather than link to it, so there would be no automatic updating anyways. Grrr.

I thought I might use the report library to generate the reports, and then somehow consolidate them, but there does not appear to be any way to access them other than through the library's own interface.

Does anyone have any advice on how I can accomplish this task?

Cheers,

Joey
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Expert
posted Hide Post
15 procedures is a lot to schedule live...unless they each are really really fast.
So let caster schedule them and park each one of the output html files on your server somewhere, with a filedef, somewhere your server can read it. I have a selfserv site, so i park mine under the
D:\InetPub\wwwroot\..some directory \ some file name .htm
FILEDEF MYTAB1 DISK D:\InetPub\wwwroot\..somedirectory\mytab1.htm
FILEDEF MYTAB2 DISK D:\InetPub\wwwroot\..somedirectory\mytab2.htm
Filedef each one this way. then make them.
TABLE FILE CAR
..do stuff.
ON TABLE HOLD AS MYTAB1 FORMAT HTMTABLE
END
then your user , when hitting the launch page, or wherever you have it,
executes a program that does this:
FILEDEF...repeat all the filedefs
-RUN
-HTMLFORM BEGIN

!IBI.FIL.MYTAB1;
!IBI.FIL.MYTAB2;
..etc
-HTMLFORM END
The tables are already made, so the user wastes no time in pulling themup. Caster canmake these tables. The output of the caster job, as you set it up in caster, becomes irrelevant. Choose FORMAT ALPHA..it doesn't matter, because the fex you're running is doing all the parking of the output tables. Chose email or mre...doesn't matter.
since the fex itself has no html output, you won't be emailing anything to yourself if you just set it up as email. If you chose MRE, you're not parking anything their either. The parking is done by the fex.
Further, you can format your output tables next to each other, if you like.

-HTMLFORM BEGIN
<TABLE>
<TR><TD>!IBI.FIL.MYTAB1;</TD><TD>!IBI.FIL.MYTAB2</TD></TR>
<TR><TD COLSPAN="2">!IBI.FIL.MYTAB3;</TD></TR>
...
</TABLE>

etc.
Any help? Getting the idea?
If your fexes are really quick, you can just not filedef them at all, which will park them in the current agent, and then include your -HTMLFORM stuff at the end of your primary fex...All in One.
More than you wanted to know?

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




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Guru
posted Hide Post
That's pretty much the way to go, I agree. I've settled on breaking the report into three sections for now, due to time constraints, but I will definitely use your approach on the next report that is like this one.

Thanks so much,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Guru
posted Hide Post
FYI,

I ended up creating hold files of the processed data using the APP HOLD / FORMAT FOCUS method. I repointed the reports to this new master file, and it worked without losing any of my formatting (Yay!). I scheduled the procedure to create the masterfile every morning, using Report Caster. The report runs lightning fast and I still have a job. Smiler

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
 
Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005Report This Post
Expert
posted Hide Post
way to go!




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report 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     multiple fex html report timeout - advice?

Copyright © 1996-2020 Information Builders