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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
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