Advertisement

02.01.2005 at 07:13PM PST, ID: 21297946
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

FRM-92101: There was a failure in the Forms Server during startup

I have come across the error (in the question title) while saving records from a form.  Now I've tried it when running my forms with my PC acting as the server (Oracle 9i OAS) and the client (via Internet Explorer browser), and also with a separate server (Oracle Application Server 10g) and my PC as the client.  This only happens when I'm inserting a new record from a secondary form that had data populated from the calling form.

For example, and application record is created then saved.  Then a button to call the corporation screen is pressed and details of the application populate fields in the corp screen.  At that point I add more data and the save.  This is when the application crashes, but the browser remains open.  Now if I modify and existing corporation from an existing application, when I save everything runs normal.

Some other details are:

Java Exception:
oracle.forms.net.ConnectionException: Forms session <18> aborted: unable to communicate with runtime process.

Now I looked at the possible solution by Oracle: "This can be confirmed by looking for a log message like "Unable to switch to Workin Directory: <workingDirectory>" in the application.log file.  I did look at the log, and saw no error like this but did see other errors


05/02/01 18:57:41 forms90web: Forms session <31> aborted: unable to communicate with runtime process.
05/02/01 18:57:41 forms90web: Forms session <31> exception stack trace:  
java.net.SocketException: Connection reset  at java.net.SocketInputStream.read(SocketInputStream.java:168)
 
    at java.io.BufferedInputStream.fill(BufferedInputStream.java:183)
 
 
    at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
 
    at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
 
    at java.lang.Thread.run(Thread.java:534)
 

Then saw this in the error log

[Tue Feb 01 18:05:23 2005] [error] [client 10.11.90.37] [ecid: 1107309923:147.22.88.31:3324:3532:3338,0] File does not exist: d:/orahome2/forms90/java/java/awt/KeyboardFocusManager.class
 
[Tue Feb 01 18:05:23 2005] [error] [client 10.11.90.37] [ecid: 1107309923:147.22.88.31:3324:3532:3339,0] File does not exist: d:/orahome2/forms90/java/sun/applet/AppletViewer.class
 
[Tue Feb 01 18:05:23 2005] [error] [client 10.11.90.37] [ecid: 1107309923:147.22.88.31:3324:3532:3340,0] File does not exist: d:/orahome2/forms90/java/sun/applet/AppletViewer.class
 
[Tue Feb 01 18:05:24 2005] [error] [client 10.11.90.37] [ecid: 1107309924:147.22.88.31:3324:3532:3342,0] File does not exist: d:/orahome2/forms90/java/oracle/forms/registry/default.dat
 
[Tue Feb 01 18:06:00 2005] [error] [client 10.11.90.37] [ecid: 1107309960:147.22.88.31:3324:3532:3362,0] File does not exist: d:/orahome2/apache/apache/htdocs/forms90/listval.gif
 
[Tue Feb 01 18:06:00 2005] [error] [client 10.11.90.37] [ecid: 1107309960:147.22.88.31:3324:3532:3363,0] File does not exist: d:/orahome2/apache/apache/htdocs/forms90/listval.gif
 
[Tue Feb 01 18:06:00 2005] [error] [client 10.11.90.37] [ecid: 1107309960:147.22.88.31:3324:3532:3364,0] File does not exist: d:/orahome2/apache/apache/htdocs/forms90/listval.gif
 
[Tue Feb 01 18:06:07 2005] [error] [client 10.11.90.37] [ecid: 1107309967:147.22.88.31:3324:3532:3373,0] File does not exist: d:/orahome2/apache/apache/htdocs/forms90/listval.gif
 
 
that it was looking for other Java files and also some gif files (listval.gif).


The point is, is that my Oracle Home is set properly yet this error still occurs.

Any clues as to what this could be?  This is a showstopper for my app and I can't release it into QA let alone production.

Gio
Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: jaramill
Solution Provided By: OzzMod
Participating Experts: 2
Solution Grade: B
Views: 437
Translate:
Loading Advertisement...
02.01.2005 at 09:23PM PST, ID: 13200195

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.02.2005 at 09:25AM PST, ID: 13205433

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.02.2005 at 03:55PM PST, ID: 13209390

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.03.2005 at 05:00AM PST, ID: 13213498

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.06.2005 at 09:57PM PST, ID: 13241625

All comments and solutions are available to Premium Service Members only.

Start your 7-day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • Automotive
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Displays / Monitors
  • Handhelds / PDAs
  • Components
  • Peripherals
  • Laptops/Notebooks
  • Servers
  • Misc
  • Apple
  • Embedded Hardware
  • Networking Hardware
  • Storage
  • Desktops
  • New Users
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMware
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Virtualization
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • Web Computing
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Consulting
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMware
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Automation
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Web Services
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Web Computing
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Lounge
  • Business Travel
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
  • Automotive
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
02.01.2005 at 09:23PM PST, ID: 13200195
I think you will need a Patch

What is New in Forms6i Patch 6?
The following are changes that were made for Forms6i Patch 6.
Enhanced Network Resilience. Currently in Oracle Forms 6i patch 5, if a network
failure lasts more than a few seconds, then the Oracle Forms session is lost and you
receive the following error message, which results in the loss of any unsaved
information:
"FRM-92100: Your connection to the Server has been interrupted. This may be
the result of a network error or a failure on the Server. You will need to
reestablish your session."
For patch 6 (as a fix to bug 1762055), when using the listner servlet, the client has
the ability to distinguish network failures from server (Oracle Forms runtime)
failures, and in the case of a network failure, attempts to reestablish the network
connection. The client tries to reconnect as many times as you specify in the
<networkRetries> parameter, and for each attempt, a message such as the following
is displayed in the right-hand side of the status bar:
"2/30"
where 2 indicates the second attempt and 30 is the <networkRetries> value.
If the client is unable to talk to the server after retrying the number of times
specified in the <networkRetries> parameter, it aborts the Oracle Forms session and
displays the following message:
"FRM-92102: A network error has occurred. The Forms Client has attempted
to reestablish its connection to the Server <number> times without success.
Please check the network connection and try again later."
If there is a failure in the server (that is, the Forms runtime process unexpectedly
terminates or someone has stopped it), the client immediately aborts the Oracle
Forms session and displays the following message:
"FRM-92101: A failure has occurred on the Server. You will need to
reestablish your session.


Read http://download-west.oracle.com/otn_hosted_doc/forms/forms/p6_relnotef_s.pdf for more.
 
02.02.2005 at 09:25AM PST, ID: 13205433
I'm using Oracle 9i Developer Suite Forms, not 6i.
 
02.02.2005 at 03:55PM PST, ID: 13209390
Found my problem bug and solution. In another thread someone suggested looking at the directory Forms90 and look at the latest dump files. In there it showed where the Form was crashing.

In my case it was happeninng in a POST-INSERT trigger. This trigger had an update statement but for some reason (don't know why), the previous programmer used the FOR UPDATE clause to update one record. So I removed the FOR UPDATE clause and voila!!!

My records commited and the web-form did NOT crash! What a relief.
 
02.03.2005 at 05:00AM PST, ID: 13213498
A request has been made in Community Support to close this question:

http:Q_21299484.html

If there are no objections, a moderator will finalise this question after 4 days by:

- PAQ-ing the question and refunding 500  points

Please leave any recommendations here.

modulo

Community Support Moderator
Experts Exchange
 
02.06.2005 at 09:57PM PST, ID: 13241625
Closed, 500 points refunded.
OzzMod
Community Support Moderator
Accepted Solution
 
 
20080236-EE-VQP-29