Focal Point
[CLOSED] Show alert message for user if webfocus server is down and database is down

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5927036276

September 12, 2014, 04:08 AM
Maddy1
[CLOSED] Show alert message for user if webfocus server is down and database is down
Hello,

Some times webfocus server may be down or database may be down at that time i need to pass the alert message to java,that "webfocus server is down so unable to generate report" + If database is down so unable to generate report".can any one help with code


Thanks

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.7.03 Windows 7, Excel,HTML,PDF
September 12, 2014, 07:46 AM
Rifaz
Maddy1,

Just to heads up, i think &RETCODE may do the trick, if your DB is down. But, about RS, need to look, is there any environment variable get set once server is running.


-Rifaz

WebFOCUS 7.7.x and 8.x
September 12, 2014, 08:34 AM
Shakila Subhan
Maddy1,

-IF (&RETCODE LE 1) AND (&FOCERRNUM EQ 0) THEN GOTO SKIP_EXIT;
-TYPE *** RETCODE = &RETCODE
-TYPE *** FOCERRNUM = &FOCERRNUM
-TYPE *** FORCED TERMINATION!
-EXIT
-RUN
-SKIP_EXIT


WebFOCUS 8.0.08 - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
Windows, All Outputs
September 13, 2014, 03:18 AM
Maddy1
Thank you very Much Rifaz and Shakila,i will try this code and let you know if it works


WebFOCUS 7.7.03 Windows 7, Excel,HTML,PDF
September 13, 2014, 11:28 AM
George Patton
Maybe I'm missing something, but if the WF server is down how is this ever going to run?

quote:
Originally posted by Shakila Subhan:
Maddy1,

-IF (&RETCODE LE 1) AND (&FOCERRNUM EQ 0) THEN GOTO SKIP_EXIT;
-TYPE *** RETCODE = &RETCODE
-TYPE *** FOCERRNUM = &FOCERRNUM
-TYPE *** FORCED TERMINATION!
-EXIT
-RUN
-SKIP_EXIT



WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
September 16, 2014, 11:46 AM
Maddy1
Hi Greg,

Can you help out what the return codes usually cause ate webfocus server down and database down


WebFOCUS 7.7.03 Windows 7, Excel,HTML,PDF
September 17, 2014, 04:58 AM
Ian Dalton
You can replace the reference to the bid login with your own as per below.
We have a small piece of html generated by Dev Studio that simply says "WebFOCUS down ....try later"

  • Log In

  • < !--
  • Log In
  • -->


    _______________________
    *** WebFOCUS 8.1.05M ***
    September 17, 2014, 05:03 AM
    Ian Dalton
    Also refer to Case: 93462003
    Summary: How to put a message on Dashboard login screen


    _______________________
    *** WebFOCUS 8.1.05M ***
    October 23, 2014, 05:22 AM
    Ram Prasad E
    Since you are using JAVA as launch tool, you can use the response header value of the WebFOCUS request and display the alert accordingly.

    Thanks,
    Ram


    WebFOCUS 8.1.05
    Windows
    http://ibiwebfocus.wordpress.com
    https://www.facebook.com/groups/ibi.webfocus/
    October 24, 2014, 05:27 AM
    Ian Dalton
    Can you supply an example of this please Ram.


    _______________________
    *** WebFOCUS 8.1.05M ***