Home » Developer & Programmer » Forms » Oracle Forms 10g upgrade: FRM-92100 when exiting form (Oracle Forms, 10g, Unix)
Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #344031] Thu, 28 August 2008 11:48 Go to next message
Robin84
Messages: 7
Registered: August 2008
Location: Glasgow
Junior Member
Hi.

I have recently upgraded some forms from 6i to 10g. Upon testing some of the forms (doesn't happen in all forms) I receive an error:

FRM-92100 Your connection to the server was interrupted. This may be the result of a network error or a failure on the server.
-- with the following details --
java.lang.NullPointerException
at oracle.forms.handler.TextComponentItem.selectionChanged(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent._fireSelectionChanged(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent.select(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField._selectAll(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.processFocusEvent(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.lwText.LWTextComponent.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.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.KeyboardFocusManager.redispatchEvent(Unknown Source)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(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.KeyboardFocusManager.dispatchAndCatchException(Unknown Source)
at java.awt.KeyboardFocusManager.processSynchronousLightweightTransfer(Unknown Source)
at sun.awt.windows.WComponentPeer.processSynchronousLightweightTransfer(Native Method)
at sun.awt.windows.WComponentPeer.requestFocus(Unknown Source)
at java.awt.Component.requestFocusHelper(Unknown Source)
at java.awt.Component.requestFocus(Unknown Source)
at java.awt.Component.postNextFocusHelper(Unknown Source)
at java.awt.Component.nextFocusHelper(Unknown Source)
at java.awt.Container.nextFocusHelper(Unknown Source)
at java.awt.Component.nextFocus(Unknown Source)
at java.awt.Component.transferFocus(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.removeNotify(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent.removeNotify(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.removeNotify(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.remove(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at oracle.forms.handler.UICommon.onDestroy(Unknown Source)
at oracle.forms.handler.ComponentItem.onDestroy(Unknown Source)
at oracle.forms.handler.TextComponentItem.onDestroy(Unknown Source)
at oracle.forms.handler.TextFieldItem.onDestroy(Unknown Source)
at oracle.forms.engine.Runform.onDestroyHandler(Unknown Source)
at oracle.forms.engine.Runform.processMessage(Unknown Source)
at oracle.forms.engine.Runform.processSet(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.processEventEnd(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.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)


This happens when the form is exited using the X button on the window OR in the exit button on the toolbar. The trigger in the form, when-window-closed, only has "exit_form;".

After noticing the Java error which points to a null entry I tried exit_form(no_validate) and do_key('exit_form') in its place without any luck. Been trying to debug this for a good few hours now without any luck.

Can someone suggest a fix for this... works fine in 6i...

Cheers,
Robin
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #344723 is a reply to message #344031] Mon, 01 September 2008 02:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you do a Ctrl-Shft-K before doing the Ctrl-T?

Do these forms contain a library? Did you recompile and regenerate this library?

David
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #344851 is a reply to message #344723] Mon, 01 September 2008 07:19 Go to previous messageGo to next message
Robin84
Messages: 7
Registered: August 2008
Location: Glasgow
Junior Member
David,
Thanks for your reply and suggestions.

I have used the two Ctrl commands you suggested, i.e. compilation, without error on the Windows environment (where the forms are developed). We compile files on our web server (Unix) using command line (including the compile_all=yes parameter).

Two libraries are used and have been recompiled, then reattached to the mmb menu and all other forms used, including a toolbar fmb. Not all forms use both libraries.

The problem, unfortunately, still exists. I must add that some of the forms do not cause this error when using exit_form but they do close the menu and a toolbar instead making the application unusable and so has to be reloaded every time! On some of the forms the problem doesn't exist at all and closes fine if another form is open behind it - this is not the case for all forms.

[UPDATE] - As another test I have changed the call to one of the forms that causes the error to call_form rather than open_form and this works without any problems. However, this is not ideal as I want several forms to be opened and usable at the same time as it was in 6i.

Hope this gives you a better picture of what's going on!
Thanks,
Robin

[Updated on: Mon, 01 September 2008 11:45]

Report message to a moderator

Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #344923 is a reply to message #344851] Mon, 01 September 2008 21:33 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why did you have to reattach the menus? Where is this 'toolbat'? What is it?

David
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #345031 is a reply to message #344923] Tue, 02 September 2008 03:10 Go to previous messageGo to next message
Robin84
Messages: 7
Registered: August 2008
Location: Glasgow
Junior Member
Oops, sorry I didn't reattach the menu, it was recompiled along with the 10g migration - my typo!

The toolbar is a form (horizontal toolbar canvas) that is inherited by every form. It contains navigation buttons, exit button, print, save, commit, etc.

Robin
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #345303 is a reply to message #345031] Tue, 02 September 2008 20:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I suggest deleting all the compiled objects. Recompile and regenerate your libraries (Ctrl-Shft-K, Ctrl-T) [how many do you have?], then do the menues, then do your inherited forms (eg toolbar), then do your other forms.

Does this make a difference?

David
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #345353 is a reply to message #345303] Wed, 03 September 2008 03:27 Go to previous messageGo to next message
Robin84
Messages: 7
Registered: August 2008
Location: Glasgow
Junior Member
David.

I have deleted all compiled objects, recompiled all plsql for each form in builder, saved, 'pscp' over the files and regenerated them on the UNIX box in the order you suggested using the compile_all param set to yes for each object.

This did not make any difference I'm afraid.

There are two libraries. There were 3 - the HINT.pll library for tooltips was used for the toolbar but has been removed and replaced using the tooltip properties for each button.

Appreciate your time.
Robin

[Updated on: Wed, 03 September 2008 04:31]

Report message to a moderator

Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #345494 is a reply to message #345353] Wed, 03 September 2008 19:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you telling me that you haven't tested your application on your PC?

Get real!! Get the application running on your PC using DS and THEN move it to your system test and production environment.

How did you do the "recompiled all plsql for each form in builder"? Did you generate the forms on your PC?

Also confirm that you have searched metalink and are using the latest version of the JIinitiator.

David
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #506134 is a reply to message #345494] Fri, 06 May 2011 11:12 Go to previous messageGo to next message
jcossio
Messages: 1
Registered: November 2008
Location: Medellin - Colombia
Junior Member
We are experiencing the same problem (exact Java error) with some version 6 forms, compiled to be used on web (Ver. 10). Our situation is that we have Forms6 clients and web clients so we keep our development in forms6 and just compile for the web as needed. Will try David's suggestions and see if that is the case. A bugger that Robin didn't post his solution if he ever did find one.

Jorge
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #508898 is a reply to message #506134] Wed, 25 May 2011 02:34 Go to previous messageGo to next message
LasseL
Messages: 2
Registered: May 2011
Location: Sweden
Junior Member
Hi,
I'm having the same problem when upgrading a Forms 10g form to Forms 11g (11.1.1.4).
I do an unrestricted Execute Query, scroll down 3 times and then: Bang!
Perfectly reproducible.
When I add the debug_messages=yes switch to the URL the error doesn't show up.
My database is an 11gR2 and everything is on RHEL.
Any ideas out there?
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #508900 is a reply to message #508898] Wed, 25 May 2011 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you looked on My Oracle Support?
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #509804 is a reply to message #508898] Wed, 01 June 2011 03:12 Go to previous messageGo to next message
LasseL
Messages: 2
Registered: May 2011
Location: Sweden
Junior Member
I have now solved this problem. It was caused by bad programming, or rather bad migration from Forms 3. In Forms 3 there was a built-in called show_page that took a Forms 3 pop-up page number as argument. When a Forms 3 form was migrated to graphical mode the pop-up page was converted to a canvas named PAGE_n, where n was the pop-up page number. The show_page(n) should have been converted to a show_view('PAGE_n'), but this had not been done. Forms 10g, as well as Forms 11g, still accept calls to show_page with a numerical argument. However, while Forms 10g never crashed when show_page was called in this way, Forms 11g sometimes does.
After correction of this Forms 11g seems very stable.
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #509805 is a reply to message #509804] Wed, 01 June 2011 03:14 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
Thanks for letting us know.
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #575570 is a reply to message #345494] Thu, 24 January 2013 05:04 Go to previous messageGo to next message
optimistpk
Messages: 4
Registered: December 2012
Location: Pakistan
Junior Member

Dear David!

I am also facing same problem and still not finding any solution. so reply me if you have got nay solution to this problem. One mor thing reagrding it, when ever i click on the text box items on my forms, my mouse focus does not stay.

waiting for reply.
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #575595 is a reply to message #575570] Thu, 24 January 2013 10:44 Go to previous messageGo to next message
Littlefoot
Messages: 19526
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, David doesn't visit OraFAQ Forum regularly any more so ... you probably won't get any reply from him.

As of me - sorry, no idea. However, although stating that you have the "same problem" is somewhat OK, it might help if you described your working environment (operating system, its version, database version, developer suite version).
Re: Oracle Forms 10g upgrade: FRM-92100 when exiting form [message #577475 is a reply to message #575595] Sat, 16 February 2013 09:51 Go to previous message
optimistpk
Messages: 4
Registered: December 2012
Location: Pakistan
Junior Member

Dear Littlefoot!

Same problem still exists on Windows XP/Windows 2003 server
Tools I am using are:
• Oracle Developer suit 10.1.2.0.2
• Oracle application server 10.1.2.0.2
• Jinitiator 1.3.1.22
• Oracle database 10g

"
java.lang.NullPointerException
at oracle.forms.handler.TextComponentItem.selectionChanged(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent._fireSelectionChanged(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent.select(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField._selectAll(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.processFocusEvent(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.lwText.LWTextComponent.processEventImpl(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.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.KeyboardFocusManager.redispatchEvent(Unknown Source)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(Unknown Source)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(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.KeyboardFocusManager.dispatchAndCatchException(Unknown Source)
at java.awt.KeyboardFocusManager.processSynchronousLightweightTransfer(Unknown Source)
at sun.awt.windows.WComponentPeer.processSynchronousLightweightTransfer(Native Method)
at sun.awt.windows.WComponentPeer.requestFocus(Unknown Source)
at java.awt.Component.requestFocusHelper(Unknown Source)
at java.awt.Component.requestFocus(Unknown Source)
at java.awt.Component.postNextFocusHelper(Unknown Source)
at java.awt.Component.nextFocusHelper(Unknown Source)
at java.awt.Container.nextFocusHelper(Unknown Source)
at java.awt.Component.nextFocus(Unknown Source)
at java.awt.Component.transferFocus(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.removeNotify(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextComponent.removeNotify(Unknown Source)
at oracle.ewt.lwAWT.lwText.LWTextField.removeNotify(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at oracle.ewt.lwAWT.LWComponent.remove(Unknown Source)
at java.awt.Container.remove(Unknown Source)
at oracle.forms.handler.UICommon.onDestroy(Unknown Source)
at oracle.forms.handler.ComponentItem.onDestroy(Unknown Source)
at oracle.forms.handler.TextComponentItem.onDestroy(Unknown Source)
at oracle.forms.handler.TextFieldItem.onDestroy(Unknown Source)
at oracle.forms.engine.Runform.onDestroyHandler(Unknown Source)
at oracle.forms.engine.Runform.processMessage(Unknown Source)
at oracle.forms.engine.Runform.processSet(Unknown Source)
at oracle.forms.engine.Runform.onMessageReal(Unknown Source)
at oracle.forms.engine.Runform.onMessage(Unknown Source)
at oracle.forms.engine.Runform.processEventEnd(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.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
"

after experiencing this exception, oracle form has no response to mouse click, key board click on clicking buttons, checkboxes, unbale to exit it. Kindly help me out to over come this issue.

waiting for reply.
Previous Topic: Running Multiple Instances Parallely in Oracle Forms 11g R2
Next Topic: How to Configure forms 6i to implement java beans
Goto Forum:
  


Current Time: Sat Aug 30 15:19:13 CDT 2014

Total time taken to generate the page: 0.11995 seconds