Hi
Is there a list of error numbers which we have for WebFOCUS errors? I want to distinguish between Database errors and the rest of the regular WebFOCUS errors which we get. Based on whether the error is a DB error, I need to display different messages.
Please help.

Regards
Syed

Syed,

Perhaps this will be of help. This will give you WebFocus error codes and the associated error message. The message appears to be ERROR if the code is not applicable:

  
-REPEAT :ERRLOOP FOR &I FROM 0 TO 5000;

-* Get the FOCUS error message
-SET &FOC_ERR_MSG = FEXERR(&I,'A72');

-TYPE &I : &FOC_ERR_MSG 

-:ERRLOOP 

Regards,
Sean

Sean, that was fun wasn't it?

Francis,

Yeah, around and around the loop we go.....

Appears to be a lot of junk in there, so hopefully Syed will be able to parse out whatever he needs!

Sean

I think it will be difficult to separate database errors from WebFOCUS errors because, for many errors, more than one WebFOCUS error is generated and only the last one is stored in &FOCERRNUM.

Francis,

Yes, definitely a good point. And, even if you have a handle on a relevant error message, I don't think WF stores the source of the problem, such as the field that caused the error.

In Data Migrator (ETL), I can search for ORA for example in ettlog, as well as for FOC in etllog and etlstats, so I can track down FOCUS versus database errors that way, but not in WF.

Sean

Hi,

At the end the error returned is webfocus error that can be due to an exception on db server.
And Francis said it will be difficult to make a difference.

Regards.

Majid.

Thanks a lot for your responses. My intention was to separate the errors occuring due to Database/WebFOCUS. It seems that it is difficult to differentiate them using WebFOCUS error handling.
I think I need to figure out another mechanism to go about this issue.

Regards
Syed

Syed,

I should have mentioned that some SQL errors are contained in &RETCODE, so if you have a WebFOCUS error (&FOCERRNUM NE 0) you could first check &RETCODE to see if there is a SQL error. In one app, I have tests for DB2 SQL errors -551, -1015, -1032, -1035, -2036, -30082.

Hi Syed,

If sql server error is returned by webfocus that means also that this error was generated by sql server.
In sql server we can catch these erros and send mails directly from sql server to whom ever we want.

Regards

Francis/Majid
Thanks for the response.
Actually I am looking for errors which can be caught after the report is generated. We have an error page which, in case there's any error, would show a message with the Error No. (&FOCERRNUM). we wanted to use this to track down the root cause. I understand that if the error is a SQL error, it can be caught from the logs on SQL server. However, we would want to know into which bucket should the error fall in - WebFOCUS or Database, based on the error number which we get on the error page.

Syed