Home » Developer & Programmer » Forms » Oracle form freezes
Oracle form freezes [message #208902] Tue, 12 December 2006 08:55 Go to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Hi All,

I am using oracle forms 9i AS (developer suit) .It's a web based oracle form application.my problem is that many of the users are facing problem while working on those forms.Suddenly the form freezes and they can't do anything. Every menu item and scroll bar stops working. it doesn't give any message and doesn't do any action also.
For example if user presses query or exit button on menu nothing happens.but on some forms i am having Tab canvas when user changes the canvas he can change it successfully but still can't query any data or add/delete/update any record.
Mostly it freezes while using scroll bar.

it happens randomly for some time and when users kills the form using task manager and relogin again in the application it works fine.

I did search on google ..it talks about some Jinitiator problem.We all are having JInitiator version 1.3.1.9.
so please let me know how to check which JInitiator my forms are using if it is using any?
or if there is any other reason please let me know.

Thanks in advance for patience and reading such a long problem description.

[Updated on: Tue, 12 December 2006 08:55]

Report message to a moderator

Re: Oracle form freezes [message #208992 is a reply to message #208902] Tue, 12 December 2006 21:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I believe that the problem is due to the version of JInitiator that you are running. The problem is most obvious when the user places the mouse over the arrow of the scroll bar and hold down the mouse button. The work around it to remove the scroll bar from the block and make the user press the page up and page down buttons.

Have a look at http://www.orafaq.com/forum/m/180729/67467/?srch=jinit+version#msg_180729 and search for the word 'version'. There are other ways of finding out which version of the JInitiator is running but I can't remember it at the moment.

David
Re: Oracle form freezes [message #209191 is a reply to message #208992] Wed, 13 December 2006 12:24 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Hi ,

This is the output of JInitiator at the time when forms freezes.Please guide me how to overcome with it.it happens so randomly that tough to simulate this situation.
and it's not just scrollbar that causes this problem it may be caused by any event in the form.
thanks in advance.

-------------------------------------------------------------------
connectMode=HTTP, native.

Forms Applet version is : 902110

connectMode=HTTP, native.

Forms Applet version is : 902110

Exception occurred during event dispatching:

java.lang.ArrayIndexOutOfBoundsException: 0 >= 0

at java.util.Vector.elementAt(Unknown Source)

at oracle.ewt.lwAWT.lwWindow.SystemModalStyle.grabMouseEvent(Unknown Source)

at oracle.forms.handler.AppsModalStyle.grabMouseEvent(Unknown Source)

at oracle.ewt.lwAWT.lwWindow.LWWindow$MouseGrab.grabMouseEvent(Unknown Source)

at oracle.ewt.lwAWT.lwWindow.LWWindow$MouseGrab.mouseExited(Unknown Source)

at java.awt.AWTEventMulticaster.mouseExited(Unknown Source)

at oracle.ewt.event.tracking.GlassMouseGrabProvider.processMouseGrabs(Unknown Source)

at oracle.ewt.event.tracking.GlassMouseGrabProvider$Disp._redispatchEvent(Unknown Source)

at oracle.ewt.event.tracking.GlassMouseGrabProvider$Disp._redispatchEvent(Unknown Source)

at oracle.ewt.event.tracking.GlassMouseGrabProvider$Disp._checkTarget(Unknown Source)

at oracle.ewt.event.tracking.GlassMouseGrabProvider$Disp.mouseClicked(Unknown Source)

at java.awt.Component.processMouseEvent(Unknown Source)

at oracle.ewt.lwAWT.LWComponent.processMouseEvent(Unknown Source)

at java.awt.Component.processEvent(Unknown Source)

at java.awt.Container.processEvent(Unknown Source)

at oracle.ewt.lwAWT.LWComponent.processEventImpl(Unknown Source)

at oracle.ewt.lwAWT.LWComponent.redispatchEvent(Unknown Source)

at oracle.ewt.lwAWT.LWComponent.processEvent(Unknown Source)

at java.awt.Component.dispatchEventImpl(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

at java.awt.Container.dispatchEventImpl(Unknown Source)

at java.awt.Window.dispatchEventImpl(Unknown Source)

at java.awt.Component.dispatchEvent(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)
Re: Oracle form freezes [message #209246 is a reply to message #209191] Wed, 13 December 2006 23:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Like much of Java that output is totally meaningless.

Have you found out the version of Jinitiator that you are running?

I suggest recompiling all the PLL files (don't create the plx files) in the form builder (Ctrl-Shft-K - compile all, then save), recompile all the menus (Ctrl-Shft-K then save), and then all the forms (ctrl-Shft-K, then Ctrl T, then save). It MIGHT make a difference. If not, then log an SR with Oracle and get them to help you determine the correct version of JInitiator for your version of Forms.

Is this happening on all the PCs or only the ones that are more than 3 years old?

David

[Updated on: Wed, 13 December 2006 23:19]

Report message to a moderator

Re: Oracle form freezes [message #209327 is a reply to message #209246] Thu, 14 December 2006 05:29 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Hi,

if we goto this link it says about a bug in Jinitiator 1.3.1.9
but still doesn't have any clue how to fix it.

http://www.orafaq.com/forum/?t=msg&th=28332/0/
Re: Oracle form freezes [message #209777 is a reply to message #209327] Sun, 17 December 2006 20:06 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
YOU can't fix it. Try a newer version of JInitiator. If you answered my questions I may be able to give you other information.

David
Re: Oracle form freezes [message #209892 is a reply to message #209777] Mon, 18 December 2006 05:30 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Thanks David.

I have involved DBA ans sysadmin in this now and they also agreed to try a JInitiator version 1.3.1.13. Hope it will be alright after this change.
Re: Oracle form freezes [message #209988 is a reply to message #209892] Mon, 18 December 2006 19:51 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why don't you want to answer my other questions?

David
Re: Oracle form freezes [message #210392 is a reply to message #209988] Wed, 20 December 2006 10:08 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
Hi David,

About your questions..Only solution to the problem is Version upgrade from 1.3.1.9 (currently we are using) to 1.3.1.13 (we are in testing Phase with this version)
None of the other things can help for this problem.
In the testing results so far excellent and scroll bars are scrolling faster and screens havn't hang so far (in Last seven Days).

i thinks now i have answerd your questions.
Re: Oracle form freezes [message #210946 is a reply to message #210392] Sat, 23 December 2006 23:39 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi yogen,

how are you?if your problem is solved or not?

Bye
Ashu
Re: Oracle form freezes [message #212103 is a reply to message #210392] Wed, 03 January 2007 16:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
The question I wanted answered was "Is this happening on all the PCs or only the ones that are more than 3 years old?"

David
Re: Oracle form freezes [message #212197 is a reply to message #212103] Thu, 04 January 2007 04:15 Go to previous messageGo to next message
yogen
Messages: 39
Registered: October 2006
Location: UK
Member
It was happening on all the PCs...infact we had here a operation called Workstation Revamp in which all the PCs..were upgraded from P3 to P4 and many more software and hardwares were upgraded.we were having this problem both before and after this operation so i doesn't think it was related to some set up (Other than JInitiator) of the PC.
Re: Oracle form freezes [message #212251 is a reply to message #212197] Thu, 04 January 2007 06:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Some PCs have on-board Java, specifically a routine called 'mouse' and this was causing problems in older PCs.

Is there on-board Java on these PCs?

David
Previous Topic: Accessing Remote Database and Error connecting to Remote Database (merged)
Next Topic: calender in forms 9i
Goto Forum:
  


Current Time: Sun Dec 11 06:02:50 CST 2016

Total time taken to generate the page: 0.11087 seconds