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>,

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.

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

Thank you very Much Rifaz and Shakila,i will try this code and let you know if it works

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

Hi Greg,

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

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

-->

Also refer to Case: 93462003
Summary: How to put a message on Dashboard login screen

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

Can you supply an example of this please Ram.