Re: Oracle 9iAS Forms Services Java access problem

From: TJ <tj39_at_hotmail.com>
Date: 11 Aug 2004 15:56:21 -0700
Message-ID: <8cc3133.0408111456.2530a71e_at_posting.google.com>


"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Xns9541B789DE524SunnySD_at_68.6.19.6>...
> tj39_at_hotmail.com (TJ) wrote in
> news:8cc3133.0408100936.bf36154_at_posting.google.com:
>
> > I have a java program that is run from a HPUX server cron job to check
> > the status of my 9.0.2.12.2 Oracle 9iAS Forms Services running on a
> > Windows 2000 server. The program determines if the Forms Services
> > restarted after a cold, off-hours backup by retrieving and reading
> > base.htm.
> >
> > I have 3 windows servers with "identical" configurations of 9iAS Forms
> > Services. The java program works when running against the dev and
> > test Forms servers but not against the production Forms server. It
> > did work against the production Forms server until I upgraded to
> > 9.0.2.12.2 a few months ago. The only way to reproduce the problem
> > against the test Forms server is to rename base.htm so the program
> > can't find it. default.env,forms90.conf,formsweb.cfg all appear to be
> > identical. Paths and other environmental variables are identical on
> > the windows Forms servers. The java program fails or succeeds
> > consistently on 3 different HPUX servers both in cron and from the
> > command line.
> >
> > The error message is: java.io.IOException: Server returned HTTP
> > response code: 500 for URL:
> > http://productionserver:7778/forms90/f90servlet
> >
> > Java is 1.3.1 on all environments.
> >
> > import java.io.*;
> > import java.net.*;
> >
> > public class auRLTest
> > {
> > public auRLTest()
> > {
> > try {
> > System.out.println("Starting...");
> > URL url = new
> > URL("http://productionserver:7778/forms90/f90servlet");
> > System.out.println("Opening URL connection ("+url+")");
> > URLConnection uc = url.openConnection ();
> > System.out.println("Connecting to URL"); uc.connect();
> > System.out.println("Opening input stream.");
> > BufferedReader in = new BufferedReader(
> > new InputStreamReader( uc.getInputStream() ) );
> > System.out.println("Reading file...");
> > System.out.println("===============================================
> > ==========================="); String inputLine = in.readLine();
> > while (inputLine != null)
> > {
> > System.out.println(inputLine);
> > inputLine = in.readLine();
> > }
> > System.out.println("===============================================
> > ==========================="); System.out.println("Closing
> > file."); in.close();
> > System.out.println("Production Form Server is UP");
> > }
> > catch( java.net.ConnectException connectException ) {
> > System.out.println("***PRODUCTION FORM SERVER IS DOWN***.");
> > }
> > catch( Exception exception ) {
> > System.out.println(exception);
> > }
> > }
> >
> > public static void main(String[] args)
> > {
> > auRLTest uRLTest = new auRLTest();
> > }
> > }
> >
> > Any clues or ideas are appreciated.
> >
> > Thanks
> >
>
> IIRC -
> http://productionserver:7778/forms90/f90servlet/showenv
> will display the HPUX environment.
> Are they REALLY the same between all three systems?
>
> What does
> $ dcmctl getstate -v
> display?
>
> Do Forms REALLY work & just your "diagnostic" program fails?

Yes, sorry. Forms Services are working from the browser. The diagnostic program is failing on "productionserver" only by reporting that the Forms services are not running when they actually are. My guess was that it couldn't find base.htm for some reason. The diagnostic program has no problem identifying whether the Enterprise Manager http://productionserver:1810 is running or not on "productionserver" or whether Forms Services are running on my dev or test Application Server.

I couldn't find anything about the showenv parameter. It defaulted to the Forms version splash page that /f90servlet/ displays.

Thanks Received on Thu Aug 12 2004 - 00:56:21 CEST

Original text of this message