thakns for your answer. but that is not the problem. my users are not idle for more than 5 minutes . is there any other cause?
SUjit
Main Topics
Browse All Topicshi,
I have a recurrent problem. I am using forms6i in 3-tire with oracle 8i back-end. Some of my forms which i use are getting hanged in the middle of execution like during saving. There is no problem in the application as such, if i will cancel it and run it once again it works fine.
I have incresed my OPEN_CURSOR size in server. i need to know what else may be the reason behind this. Plz suggest.
Sujit
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
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.
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.
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.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
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.
We had some problems which had been caused by:
1. database triggers
2. Internet Explorer 5.50.4807.2300 - after closing an application user closes also Explorer window -> then he/she starts again application and after at about 2 minutes
application is frozen. So we recommend (as temporary workaround) to our users not to close Explorer window before going home. It seems to be strange, it is only an experience and I can't explain it.
hi,
Thanks Henka for sharing your Experience. But here they are not doing this also. Let me be precise it a form for entering Purchase Orders.
The user entering Po No. 1. Saved successfully.
PO no. 2 saved successfully.
PO No. 3 Not saved---> User cancels the specific Po and makes it all over again. Now it is saved.
Even i have tried the same in my dummy server it is working fine. I only want to know why this uncertinty using 3-tire.
Thanx..
Sujit
Sujit, I suggest you trace this activity using sql_trace. Analyze what is happening when this operation occurs and the queries that are executed. It could be that there could be some locking activity taking place, also monitor the database, make sure that foreign indexes are present, play with the code and check if proper commits are issued. Im sure this will help you to get to the bottom of this problem.
Hm, sometimes we face strange reasons for that. I recall that after half of month investigation a questioner figured out that a defect LAN card was the cause. Check the LAN environment.
See the logs of the Application Server. Do the AS looses connection with the WEB browser? Is this Oracle Forms application? If yes look if the Forms Server is not overloaded. Also look what the actual settings of idle-time and hearth-beat parameter is.
Also try to to use AFTER INSERT, AFTER UPDATE triggers in the tabe(s) you change and register in another table the details of the activity (ID, time, etc.) - this will help you to be aware what happen.
Business Accounts
Answer for Membership
by: schwertnerPosted on 2003-07-09 at 01:38:50ID: 8883480
in 3-tier Forms applications it is likely that the forms hanged due the period of idle time. If this is the case you can increase the idle time settings. Read the following text:
========== ========== ========== =
You are running forms on the web and want the ability to automatically
close a client connection and release the forms web process if a
client remains idle for a particular amount of time. For example, say
you have many users performing data entry and you want to conserve
resources as much as possible. You can implement a five minute maximum
idle time to users, after which their connection is lost and the
ifweb60 process is shut down, which frees resources.
Terminating a User Session Based on Idle Time in Forms 6i
==========================
Follow this procedure to terminate a user session based on idle time
in Forms 6i (Forms 6.0.8.8 or higher):
1) Create a registry/environment variable called FORMS60_TIMEOUT.
2) Set FORMS60_TIMEOUT to a value of 5. This parameter specifies the
amount of time in elapsed minutes before the Forms Server process
is terminated when there is no client communication with the Forms
Server. The default is 15, and valid values are integers
between 1 - 1440 (1 day.) For example:
FORMS60_TIMEOUT=5
3) In your html file, insert a new parameter called heartBeat. This
parameter sets the frequency at which a client sends a packet to
the server to indicate that it is still running. The default value
is two minutes. Set this parameter value to greater than the value
specified for the FORMS60_TIMEOUT variable. For example, set it to
7 minutes as follows after the serverArgs parameter:
For Internet Explorer:
<PARAM NAME="heartBeat" VALUE="7">
For Netscape Browser:
heartBeat="7"
Now, if a user is idle, (that is, if they do not use their form for
five minutes) the connection is lost and the ifweb60.exe process for
that user is automatically terminated.
Note: When the ifweb60 process is terminated, the client process is
not notified, and therefore no message is displayed on the
client side. For the user, it appears that their session is
hung. The user must close all browser windows to restart the
application. Please consider this when implementing this
functionality.
Solution Explanation
====================
The ifweb60.exe timeout depends upon the heartBeat parameter. When a
client is idle, a packet is sent every two minutes to the client and
even though it is idle, it still finds it alive. If the packet finds
the client dead, it terminates the ifweb60 process after 15 minutes
(the default for FORMS60_TIMEOUT.) If you set the value of
FORMS60_TIMEOUT to less than the value of heartBeat, the forms server
does not get a reply from the client within the specified timeout
period and it thinks the client is stopped and terminates the
ifweb60.exe process.