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.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
All, I am trying to view 3 fex files(togather), in HTML,PDF and EXCEL. Here is my concept. Table abc ..... ON ON TABLE PCHOLD FORMAT &WFFMT OPEN NOBREAK End Table def ..... ON ON TABLE PCHOLD FORMAT &WFFMT End Table ghi ..... ON ON TABLE PCHOLD FORMAT &WFFMT CLOSE End When i am trying to execute it i am getting "An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. The application server log contains information on why this error has occurred. Contact your WebFOCUS Administrator or Information Builders Customer Support Services for further assistance" In one of the forum it was said that we need to uncheck the Friendly HTTP errors from IE->Advanced tab.I did it but still i get the same error. Even i used the -SET COMPOUND=OPEN before first TABLE "abc" and -SET COMPOUNT=CLOSED before "ghi" TABLE. But when i tried with individual FEX files they were working fine.I do 35 columns of data for each fex output, and each fex will hold around 10000 records which are grouped in to 8 category. Is it because of size of data?Do i need to modify any settings in webserver? Let me know if you have any solutions.
3 times 10.000 records would give you more than 500 pages in pdf and the excel file will also be to big. An html report of that size is imo not what you want. Reconsider the way of bringing this info to the enduser instead of trying to handle the problem you get here.
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, 2006
Hi, Sorry for the mistake it is not 3 fex, it is 3 tables in a single fex. So for TABLES i already tested the SET COMPOUND OPEN.It gave same error. Kamesh, yes it works fine if i execute them separately.
One of the forum member told that we need to increase the thread size @ tomcat webserver.Is that a solution? Regards R.Prasanna
Kamesh, It works fine with the all examples.I tried the way you told, for my reports.It worked fine except for PDF. While doing it for PDF i got the following error. 0 NUMBER OF RECORDS IN TABLE= 14955 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES. 0 NUMBER OF RECORDS IN TABLE= 8459 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES. 0 NUMBER OF RECORDS IN TABLE= 21200 LINES= 8 (FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 63.19 INCHES.
The report shouts only if i try to show all the 3 as output format.
I had similar problems using COMPOUND in previous releases (5.x). I do not know what 7.x is behaving like.
Your last posting says REPORT WILL BE PANELED. When I had this message COMPUND did not work. I had to make sure that the reports fit on one page in width. You might have a problem with that because of the 35 columns!
Another problem was (sometimes) the NOBREAK option. If appropriate to the needs of your report try COMPOUND without NOBREAK. This might even help you at all with your problem.
I hope my experiences help you a bit in debugging!
Prod: WF 7.1.5 Test: WF 7.6.4 Unix Sun Solaris HTML, PDF, EXL2K
Posts: 54 | Location: Switzerland | Registered: May 13, 2003