1 Reply Latest reply on Feb 21, 2014 12:05 AM by Gary Graham-Oracle

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

    vipsta

      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