?
Solved

FRM-92100 and java.lang.StringIndexOutOfBoundsException when using Forms Built-in Edit_TextItem

Posted on 2008-10-21
2
Medium Priority
?
3,930 Views
Last Modified: 2013-12-18
We recently upgraded from Forms and Reports 6i to 10g.

We've found that when our users attempt to modify a field using the built-in editor (called with Edit_TextItem) they sometimes recieve an error message.  It seems to only happen if they open the text editor on a field which already contains data, modify the data, and then close the editor.  If they cut out the data and paste it right back in before making their edits, everything works fine.

FRM-92100: Your Connection to the Server was interrupted.
This may be the result of a network error, or a failure on the Server.
You will need to reestablish you connection.

Details...
Java EXception:
java.lang.StringIndexOutOfBoundsException: String index out of range: 471
      at java.lang.String.substring(Unknown Source)
      at oracle.ewt.lwAWT.lwText.LWTextField.scrollSelectionIntoView(Unknown Source)
      at oracle.ewt.lwAWT.lwText.LWTextComponent.select(Unknown Source)
      at oracle.ewt.lwAWT.lwText.LWTextComponent.select(Unknown Source)
      at oracle.ewt.lwAWT.lwText.LWTextComponent.setCaretPosition(Unknown Source)
      at oracle.ewt.lwAWT.lwText.LWTextComponent.setCaretPosition(Unknown Source)
      at oracle.forms.ui.delegates.VCommonTextDelegate.setProperty(Unknown Source)
      at oracle.forms.ui.delegates.VTextFieldDelegate.setProperty(Unknown Source)
      at oracle.forms.ui.VTextField.setProperty(Unknown Source)
      at oracle.forms.handler.TextComponentItem.onUpdate(Unknown Source)
      at oracle.forms.handler.TextFieldItem.onUpdate(Unknown Source)
      at oracle.forms.handler.UICommon.onUpdate(Unknown Source)
      at oracle.forms.engine.Runform.onUpdateHandler(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.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)

Thanks for any help you can provide.


0
Comment
Question by:donneleg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Expert Comment

by:gatorvip
ID: 22770981
This looks like bug 338834.1 in Metalink


"If the following 2 conditions are met the forms is crashing:

1.display items have an initial value text with "carriage return" inserted into it
2.on the same form a button or a textitem is present and has the "Prompt" property set"

Solution

You can use a  work-around or upgrade to 10.1.2.2 or apply a one off patch for

 10.1.2.0.2 : Patch 4658455:
0
 

Accepted Solution

by:
donneleg earned 0 total points
ID: 22853061
Thanks gatorvip, that sounded right except that we are upgraded to 10.1.2.2.  The weird thing is I found an old reference to the actual problem, way back on Forms and Reports 6.  
The solution on 6 was to modify the field property 'Keep Cursor Position' from a Yes to a No.  My fields (in Forms and Reports 10) were already set to No.  Out of frustration, I set them to 'Yes' just to see what would happen.  Well, what happened is it fixed the problem.  I'm not sure if Oracle changed the behavior somewhere in there and just didn't document it.  Perhaps they fixed the problem from 6 and caused it on 10.  Either way, it works now.  
Sorry it took so long to get back to this board.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question