Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Viewing .trc Files Gives java.lang.NumberFormatException: For input string: "xxxx"

vipstaFeb 20 2014 — edited Feb 20 2014

Action

I have generated an Oracle .trc file in the normal manner.

I can view the trace file in Toad and a normal text editor.

Version Used

I attempt to load the trave file into SQL Developer version :

Oracle SQL Developer 4.0.0.13

Version 4.0.0.13

Build MAIN-13.80

Oracle is 11.2.0.3

Error Observed

and the following error is generated :

java.lang.NumberFormatException: For input string: "18446744069414649858"

    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

    at java.lang.Long.parseLong(Long.java:444)

    at java.lang.Long.parseLong(Long.java:483)

    at oracle.dbtools.raptor.sqltrace.parser.EventWait.<init>(EventWait.java:99)

    at oracle.dbtools.raptor.sqltrace.parser.SqlCursor.addEvent(SqlCursor.java:150)

    at oracle.dbtools.raptor.sqltrace.parser.TraceFile.shred(TraceFile.java:189)

    at oracle.dbtools.raptor.sqltrace.SqlTraceEditorNode.getTraceFile(SqlTraceEditorNode.java:27)

    at oracle.dbtools.raptor.sqltrace.SqlTraceTreeEditor.init(SqlTraceTreeEditor.java:45)

    at oracle.dbtools.raptor.sqltrace.SqlTraceTreeEditor.getGUI(SqlTraceTreeEditor.java:60)

    at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.attachEditor(SplitPane.java:1119)

    at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.attachNewEditor(SplitPane.java:1113)

    at com.oracle.jdeveloper.nbwindowsystem.editor.SplitPane.doLayout(SplitPane.java:586)

    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.whenCurrentEditorChanges(NbEditorManager.java:1591)

    at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.whenCurrentEditorChanges(TabGroup.java:1026)

    at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.setCurrentTabGroupState(TabGroup.java:847)

    at com.oracle.jdeveloper.nbwindowsystem.editor.TabGroup.addTabGroupState(TabGroup.java:129)

    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:546)

    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.createEditor(NbEditorManager.java:523)

    at com.oracle.jdeveloper.nbwindowsystem.NbEditorManager.openEditor(NbEditorManager.java:391)

    at oracle.ide.cmd.OpenCommand.openWithNoProject(OpenCommand.java:337)

    at oracle.ide.cmd.OpenCommand.access$100(OpenCommand.java:62)

    at oracle.ide.cmd.OpenCommand$1.run(OpenCommand.java:266)

    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)

    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)

    at java.awt.EventQueue.access$200(EventQueue.java:103)

    at java.awt.EventQueue$3.run(EventQueue.java:694)

    at java.awt.EventQueue$3.run(EventQueue.java:692)

    at java.security.AccessController.doPrivileged(Native Method)

    at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)

    at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)

    at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

    at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

    at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)

    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)

    at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)

    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)

    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)

    at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

Source Of Error

Using a text editor I opened up the .trc file and there is an entry (I have bolded and underlined the text) :

(it is a large file so I have only shown the rows before and after the offending number string)

EXEC #139845798097160:c=0,e=43,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1884964958,tim=1392804358387712

FETCH #139845798097160:c=0,e=7,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,plh=1884964958,tim=1392804358387732

CLOSE #139845798097160:c=0,e=6,dep=1,type=3,tim=1392804358387758

WAIT #139845798105544: nam='library cache lock' ela= 178 handle address=3933045368 lock address=7565422120 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388295

WAIT #139845798105544: nam='library cache pin' ela= 141 handle address=3933045368 pin address=7565421864 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388508

WAIT #139845798105544: nam='library cache lock' ela= 136 handle address=7068253496 lock address=7450118032 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388732

WAIT #139845798105544: nam='library cache pin' ela= 106 handle address=7068253496 pin address=7450117776 100*mode+namespace=18446744069414649858 obj#=2981032 tim=1392804358388908

PARSE #139845798088992:c=0,e=11,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=1,plh=0,tim=1392804358391715

Hope this helps

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 20 2014
Added on Feb 20 2014
1 comment
279 views