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     [CLOSED] WF Function for Error Message

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] WF Function for Error Message
 Login/Join
 
MCKELPA99
Gold member
posted
Does anyone know if there is an internal amper function that returns the error message in WebFOCUS similar to &FOCERRNUM that returns the error number?

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


WebFOCUS 7.7.02
Unix
All Output
 
Posts: 70 | Registered: March 24, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Syntax: How to Retrieve an Error Message
FEXERR(error, 'A72')
where:
error - Is the error number, up to 5 digits long.
'A72' - Is the format of the output value enclosed in single quotation marks. The format is A72 because the maximum length of an Information Builders error message is 72 characters.

Example: Retrieving an Error Message
FEXERR retrieves the error message whose number is contained in the &ERR variable, in
this case 650. The result is returned to the variable &MSGVAR and has the format A72.
-SET &ERR = 650;
-SET &MSGVAR = FEXERR(&ERR, 'A72');
-TYPE &MSGVAR

The output is:
(FOC650) THE DISK IS NOT ACCESSED

or
-SET &FOCERRMSG = FEXERR(&FOCERRNUM, 'A72');

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
MCKELPA99
Gold member
posted Hide Post
Thanks...this functions works for the most part. However, if the error message is "Table Not Found: TableXXX", it does not return the name of the table which is a part of the error message. It just returns "Table Not Found".


WebFOCUS 7.7.02
Unix
All Output
 
Posts: 70 | Registered: March 24, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Yes, unfortunately the additional message info is not included - we all wish it would be.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
MCKELPA99
Gold member
posted Hide Post
Thanks! So then, I guess there are other error messages where this function does not return the additional part of the message?


WebFOCUS 7.7.02
Unix
All Output
 
Posts: 70 | Registered: March 24, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Never does. People have discussed how to capture/trace/parse the WebFOCUS execution code and errors, but I think this is overkill - a user never wants to know why a report failed, they don't want the report to fail. I usually capture the error and display a message stating an error occurred.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     [CLOSED] WF Function for Error Message

Copyright © 1996-2020 Information Builders