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.
I got an error message saying ERROR: MR_UNKNOWN_ERROR -12: Pcb2.: java.io.EOFException.
It happened when when expected number of output records is too big.
My question is: is there a way I can catch this error in fex code and then display a more graceful message?
I did a throught search on this forum. I found some good error-handling technique, for example using IF &FOCERRNUM NE 0 GOTO FATAL. But seems like this can't catch this exception.
I also found a solution from this forum using IF &LINE > 60000 GOTO display something. But our BA prefer not to use a hard-coded number like 60000 or anything else.
we use dashboard to show this report. I personally think it is impossible to catch this error. But because my experience is very limited. I am not so comfident to tell them that firmly.
Can someone please give me some idea about this?
Thanks
aluThis message has been edited. Last edited by: alu,
Errors of these kind originate in the servlets, which is actually part of the webserver. This is completely out of control of anything that happens in the reporting server. It is not something you can catch - there is just no way. The cause of it may be that the number of output records is too big, but can also be something else entirely. If the problem is indeed caused by the number of records, then you may want to consider using the webviewer option. This will present the output of the request on a page-by-page basis, thus never overloading the browser or servlets. The remainder of the report stays on the server untill called by the user. Check it out.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
when i have encountered this error, its in generating an extract file from a gigantic oracle file, and when i changed the output to hold a FOCUS file rather than a foctemp, bingo, the error went away. so, if that's your situation, try ON TABLE HOLD AS MYFILE FORMAT XFOCUS rather than ON TABLE HOLD AS MYFILE
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Thank you all for taking time to reply my question.
I think I got my perfect answer from GamP. Also, I will remember dlogan, susannah and jbmuir's suggestion for future reference.
We are in the process of upgrade from version 5.3. to version 7.6. But right now we are still in version 5.3. I tried using "FORMAT XFOCUS". But seems it did not work in 5.3.
Thanks... This is stuff that I didn't consider at this dept till now.
BTW: the "IF &LINE GT 60000 GOTO" (I used 65535) is probably for the limits of Excel. I used that to alter my output form from Excel to a CSV format...
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005