We have a J2EE application that is calling and executing a WF report through Web Services. If anything goes wrong with the WF report (i.e. can't connect to the database, etc.) we want WF to send J2EE to send a string (like the one below) through a SOAP message. Is this possible?
WebFOCUS Message[42]: NO EDA HTML Output
No HTML Output!
<H5>
(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
: SQL OLE DB Interface: Could not find Connection WEBFOCUS
L (FOC1406) SQL OPEN CURSOR ERROR.
</H5>
This message has been edited. Last edited by: Ted Michalski,
7.7.02 Windows EXCEL, PDF, CSV, TEXT
October 14, 2010, 08:14 AM
Håkan
Ted, something like this: 1. Create a master for the focsql.err file, ti's located in the \ibi\64bit\srv76\home\nls or \ibi\srv76\home\nls\, depending on whether you're on a 64 or 32 bit machine. They come in a few different language versions as well.
I think that step 1 should be add error checking to your fex.
Then you can handle the errors.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 14, 2010, 05:36 PM
Håkan
No offence Waz
but I think create the master file first and then run a standard fex as an -include or ex after the report. If &FOCERRNUM = 0 then you just skip the error handling, else do somthing useful to send to your Java app