Question

FRM-92101 RUNTIME error - No HTTP headers received from runform

Asked by: ceecil

I have installed Oracle 9.2.0.1 (Release 2) Enterprise edition on Windows 2000 Server. Then I installed Oracle Clinical application 4.5 (database) on the same server and configured it.

The database Server is a domain controller with a domain name techobs.com. This machine is linked to another Windows Server 2000 machine on which I have installed Oracle 9iAS. However, I have not installed the entire components of the CD. As per my Oracle Clinical install manual, this is supposed to house the WebServer and the Reports server. And then there is a client on another machine making it a three tier architecture. all machines have been partitioned with Windows Server 2000 OS on a seperate partition and Oracle on another partition.

Machine 1 is W2KOCSVR.techobs.com - Oracle DB server 9.2.0.1 patched to 9.2.0.3 with Oracle Clinical 4.5 patched with relevant patches as per the install manual.

Machine 2 - is OCMIDTIER.techobs.com - Oracle Clinical Front end installed against Oracle_806 home which houses Oracle forms 6i. Component - Oracle forms and Repirts server was chosen from the CD.
            Then the installation also installs the Webserver compoenents in a new home - Oracle\iSuites.
            The Oracle Pharma application home is E:\opapps45.
            OC4J is part of the front end install with port number 7881

On mc-2 - I also installed Oracle 9iDS (COMPLETE) which is the compenent used for Oracle Clinical Reports server. This is in a another home Oracle\9iDS. So there are 3 homes on the middle tier machine - 2 OCMIDTIER.techobs.com
All patches were applied to Oracle 9iDS as per the install Oracle Clinical install manual.

All the machines have been networked through a Linksys router. The Apache server was configured on the middle tier as per the patch instructions.  Note: Oracle Forms server 6i is not used but a Forms servlet is used instead.

I can ping machine 2 from machine 1 and vice versa. I can TNSPING the OC database on machine 1 from machine 2 but only from the Oracle\9iDS home. When I TNSPING the Oracle Clinical DB server (W2KOCSVR machine 1) from the Oracle\806 home on (OCMIDTIER mc-2), it comes up with a message attempting to contact ADDRESS=(PROTOCOL=TCP)(HOST=W2KOCSVR)(PORT=1521) and comes out. (I am not sure why because the PATH variables have been set to include all the 3 homes on OCMIDTIER (mc-2).

Problem 1 - I see a message oracle.net.config.ServiceAliasException: 10   in the EM console even though the dbase starts up without a problem.  (minor issue but needs to be fixed)

Problem 2 - IMPORTANT and the reason for this request. When I bring up the launch page to log into the application from the middle tier (as client), the first time, it downloads the Jinitiator 1.1.8.21 and installs it. Then when I attempt to connect to the database with a username and passowrd, I get a FORMS RUNTIME ERROR.
Error: FRM-92101 A failure has occured on the server. You will need to re-establish your session.
===========================================================================
Details of the error below: 500 POINTS to have this resolved.

============================================================================
                        Tue Mar 14 22:27:02 EST 2006
============================================================================
Oracle JInitiator version 1.1.8.21
Using JRE version 1.1.8.21
User home directory = C:\Documents and Settings\opareps
JAR caching enabled.
  Cache directory: C:\Program Files\Oracle Corporation\Oracle JInitiator 1.1.8.21\jcache
  Maximum cache size: 50000000 bytes
Getting JAR file sizes...
---------REMOVED LINES related to jar files -------
Opening http://ocmidtier.techobs.com/servlet/opaservlet?JServSessionIdroot=27vtf4q4k1.pQbHokfOokjM/BfzmQvJmBaImQXHcALJmQ5Go6XNr3CNa34R no proxy
Forms Applet version is : 60825

oracle.forms.net.ConnectionException: Forms session <1> aborted: unable to communicate with runtime process.
      at java.lang.Throwable.<init>(Compiled Code)
      at java.lang.Exception.<init>(Compiled Code)
      at java.io.IOException.<init>(IOException.java:45)
      at oracle.forms.net.ConnectionException.<init>(Unknown Source)
      at oracle.forms.net.ConnectionException.createConnectionException(Compiled Code)
      at oracle.forms.net.HTTPNStream.getResponse(Compiled Code)
      at oracle.forms.net.HTTPNStream.doFlush(Compiled Code)
      at oracle.forms.net.HTTPNStream.flush(Compiled Code)
      at java.io.DataOutputStream.flush(DataOutputStream.java:92)
      at oracle.forms.net.StreamMessageWriter.run(Compiled Code)
Opening http://ocmidtier.techobs.com/forms60java/oracle/ewt/alert/resource/AlertBundle_en_US.class no proxy
Opening http://ocmidtier.techobs.com/forms60java/oracle/ewt/alert/resource/AlertBundle_en_US.properties no proxy
===============   ----------------- ==========================

CONTENTS of Jserv.log
Perspective for Java Version 1.1.
Copyright(C) 1998-99 Three D Graphics, Inc.
Environment: Sun Microsystems Inc.
Operating System: Windows NT
Java Version: 1.2.2
Imaging Model: Lightweight
Locale: en_US
Build Number [tdgswing.0415.07].
[14/03/2006 15:47:12:781 EST] Viewer/oracle.discoiv.Disco4iv: Initialized Discoverer 4i Viewer (4.1.38.16.0)
[14/03/2006 22:26:59:186 EST] f60servlet/oracle.forms.servlet.FormsServlet: init
FormsServlet init():
    configFileName:     D://ORACLE//806/forms60/server/formsweb.cfg
    testMode:           false
    baseHTMLJinitiator: D://ORACLE//806/forms60/server/basejini.htm
    baseHTMLJpi:        null
    baseHTMLie:         D://ORACLE//806/forms60/server/baseie.htm
    baseHTML:           D://ORACLE//806/forms60/server/base.htm
[14/03/2006 22:26:59:202 EST] f60servlet/FormsServlet init():
    configFileName:     D://ORACLE//806/forms60/server/formsweb.cfg
    testMode:           false
    baseHTMLJinitiator: D://ORACLE//806/forms60/server/basejini.htm
    baseHTMLJpi:        null
    baseHTMLie:         D://ORACLE//806/forms60/server/baseie.htm
    baseHTML:           D://ORACLE//806/forms60/server/base.htm
[14/03/2006 22:27:04:718 EST] opaservlet/oracle.forms.servlet.ListenerServlet: init
ListenerServlet init()
    EnvFile:          D:\ORACLE\806\forms60\server\opa45.env
    WorkingDirectory: null
    Executable:       null
    WaitTime:         500
    MaxBlockTime      1000
[14/03/2006 22:27:04:718 EST] opaservlet/ListenerServlet init()
    EnvFile:          D:\ORACLE\806\forms60\server\opa45.env
    WorkingDirectory: null
    Executable:       null
    WaitTime:         500
    MaxBlockTime      1000
Forms session <1> aborted: unable to communicate with runtime process.
[14/03/2006 22:27:48:124 EST] opaservlet/Forms session <1> aborted: unable to communicate with runtime process.
[14/03/2006 22:27:48:124 EST] opaservlet/Forms session <1> exception stack trace:
java.io.IOException: FRM-93000: Unexpected internal error.
Details : No HTTP headers received from runform
      at oracle.forms.servlet.ListenerServlet.forwardResponseFromRunform(Unknown Source)
      at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      at org.apache.jserv.JServConnection.run(JServConnection.java, Compiled Code)
      at java.lang.Thread.run(Thread.java, Compiled Code)




This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2006-03-14 at 19:51:51ID21774150
Topic

Oracle IAS Application Server

Participating Experts
1
Points
500
Comments
5

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. dBase Autoincrement in Delphi
    Does anyone know how to implement an autoincrement field for a dBase table (like in paradox). Thanks Paul.
  2. Servlets caching on Apache
    I am developing java servlets to run on an apache webserver. The apache version is 1.3.12 and ApacheJServ version 1.0 running on Solaris 7. Everything is working fine until I try to update the servlets, the original version caches and doesn't update. I bring the apache webs...
  3. Deploying Servlets in Apache!
    Hi, Is it possible to deploy Servlets and JSPs on the Apache WebServer. Which version of Apache WebServer supports this feature? I have been using version 3.1.19 and that version does not seem to support Servlets and JSPs. Regards Shayad
  4. How do I change a DBASE table's language driver at runti…
    How do I change a DBASE table's language driver at runtime?
  5. Servlet cookie
    hi, anyone know how to create cookie in servlet? i need to createa cookie recording the last visit date/time of the client and another cookie recording the number of visits. The cookie must be created if they do not exist. Set the current date/time to one cookie and inc...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: bpetersePosted on 2006-03-15 at 15:57:10ID: 16200405

Sounds like quite the hornet's nest you got there. ;-p

Could you please post the contents of the formsweb.cfg and opa45.env files?  All my experience has been on Unix but there are similarities.  

I assume your default form is a login form of some sort?

>I am not sure why because the PATH variables have been set to include all the 3 homes on OCMIDTIER (mc-2).<

Paths & ENV vars are extremely important when starting up forms & reports.  Is there a startup script/bat files when you start the middle tier or are there a number of executables?  The solution could be as simple as having the correct paths & vars stated before starting each component.  


/bp/

 

by: ceecilPosted on 2006-03-15 at 16:14:25ID: 16200513

Hello bPeterse

Thank you for your comments. I will post the files soon. I am actually now upgrading the database to the latest release as per the new release manuals.  The reason as to why there are 3 homes is because of Oracle's crap. They use 806 forms and whose dll's are incompatible with the DB dlls.  They than changed it to a 3 tier architecture where they brought in the Oracle application server.  That installs 2 homes 1. Oracle\806 and 2. Oracle\iSuites. To make matters worse, they don't use the Forms server service but servlets instead after patching.  And then they user Oracle\9iDS for the reports server which became the third home.

I am presently upgrading and I will let you know the status before I post the upgraded files. But if you want them sent to you directly, let me know.

Thanks

Cecil

 

by: ceecilPosted on 2006-03-30 at 06:14:03ID: 16332456

Peterse:

I upgraded my Database server to 9.2.0.6.0, reinstalled the applicaton Oracle Clincial server side again. Then created the database for Oracle Clinical.

I upgraded the Middle Tier by actually re-installing the components again but this time using Oracle 10G for the reports server. All the services were up and running fine.

The entire installation requirments are a mess from Oracle. They use Oracle 9iAs for the Middle tier and infrastructure. and forms and reports server. Then I had to disable or remove the Forms and Reports server SERVICE. Patch the Forms server with some patch from Metalink.

The Reports server - I had to use Oracle 10G - Forms and Reports server component only. ( I had to remove Oracle 9iDS that was installed earlier and replace it with Oracle 10G).

The problem I had after all this was that I could not TNSPING my database from the Middle Tier. I tried to use the forum but did not succeed. then I thought of simply trying to connect through the application itself.  I started the DB server and brought up the database.  Then I started the Middle Tier and decided to launch the Oracle Cclinical application. After keying in the user name and pasword and db name, it usddenly connected and brought up the applicatin screen. nothing culd be better at this time. However, I still have not tested the Reports server to know whether it is working as I  have would first have to configure the applicaton to make sure that all relevant details have been enetered and mapped within the application before I test if all is well. But for the moment, my initial peoblem has been fixed.

Thanks for the inout. You can take 100 points for your effort to help resolve this issue.

This issue is now CLOSED.



20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...