7 Replies Latest reply: Apr 20, 2012 9:08 AM by InoL RSS

    reports 11g tracing

    Martijnke
      Hi all,

      can someone explain were to put tracing on
      and were those trace files then are located
      we use reports 11gR1 and weblogic server 10.3.3 on windows 2008


      Kr
      Martin
        • 1. Re: reports 11g tracing
          tony.g
          Exactly what sort of tracing are you wanting to perform?
          • 2. Re: reports 11g tracing
            Martijnke
            tracing of the report itself
            (so no sql tracing)

            some of our reports simply crash after migrating from 6i to 11g
            • 3. Re: reports 11g tracing
              tony.g
              Do you see details of what happened in the showjobs list on the report server?
              • 4. Re: reports 11g tracing
                Martijnke
                REP-56048: Engine rwEng-0 crashed

                this is from rwserver_diagnostic.log:
                [2012-04-19T15:45:22.416+02:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.server] [tid: 14] [ecid: 0000JRAqPsVFo2G5yzL6iW1F^1Rl000000,0:1:100000001] REP-50125 : org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe  [[
                org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 208 completed: Maybe
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectionAbort(ORBUtilSystemException.java:2400)
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectionAbort(ORBUtilSystemException.java:2418)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readBits(SocketOrChannelConnectionImpl.java:354)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.handleEvent(SocketOrChannelConnectionImpl.java:1124)
                     at com.sun.corba.se.impl.transport.SelectorImpl.run(SelectorImpl.java:289)
                Caused by: org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 211  completed: No
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.ioexceptionWhenReadingConnection(ORBUtilSystemException.java:2484)
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.ioexceptionWhenReadingConnection(ORBUtilSystemException.java:2502)
                     at com.sun.corba.se.impl.protocol.giopmsgheaders.MessageBase.readGIOPHeader(MessageBase.java:116)
                     at com.sun.corba.se.impl.transport.CorbaContactInfoBase.createMessageMediator(CorbaContactInfoBase.java:150)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readBits(SocketOrChannelConnectionImpl.java:314)
                     ... 2 more
                Caused by: java.io.IOException: An existing connection was forcibly closed by the remote host
                     at sun.nio.ch.SocketDispatcher.read0(Native Method)
                     at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:25)
                     at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:237)
                     at sun.nio.ch.IOUtil.read(IOUtil.java:204)
                     at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:236)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.readFully(SocketOrChannelConnectionImpl.java:599)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.read(SocketOrChannelConnectionImpl.java:521)
                     at com.sun.corba.se.impl.protocol.giopmsgheaders.MessageBase.readGIOPHeader(MessageBase.java:112)
                     ... 4 more
                
                ]]
                [2012-04-19T15:45:23.462+02:00] [reports] [INCIDENT_ERROR] [REP-50125] [oracle.reports.server] [tid: 14] [ecid: 0000JRAqPsVFo2G5yzL6iW1F^1Rl000000,0:1:100000001] REP-50125 : org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 201  completed: No  [[
                org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 201  completed: No
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectFailure(ORBUtilSystemException.java:2200)
                     at com.sun.corba.se.impl.logging.ORBUtilSystemException.connectFailure(ORBUtilSystemException.java:2221)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:205)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:218)
                     at com.sun.corba.se.impl.transport.SocketOrChannelContactInfoImpl.createConnection(SocketOrChannelContactInfoImpl.java:101)
                     at com.sun.corba.se.impl.protocol.CorbaClientRequestDispatcherImpl.beginRequest(CorbaClientRequestDispatcherImpl.java:152)
                     at com.sun.corba.se.impl.protocol.CorbaClientDelegateImpl.request(CorbaClientDelegateImpl.java:118)
                     at org.omg.CORBA.portable.ObjectImpl._request(ObjectImpl.java:431)
                     at oracle.reports.engine._EngineClassStub.shutdown(_EngineClassStub.java:198)
                     at oracle.reports.server.EngineManager.shutdownEngine(EngineManager.java:1644)
                     at oracle.reports.server.JobManager.runJobInEngine(JobManager.java:1329)
                     at oracle.reports.server.JobManager.runJobLocal(JobManager.java:2236)
                     at oracle.reports.server.JobManager.dispatch(JobManager.java:1466)
                     at oracle.reports.server.ConnectionImpl.runJob(ConnectionImpl.java:1537)
                     at oracle.reports.server.ConnectionPOA._invoke(ConnectionPOA.java:460)
                     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
                     at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
                     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
                     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
                     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
                     at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
                     at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1213)
                     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:471)
                     at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:500)
                Caused by: java.net.ConnectException: Connection refused: connect
                     at sun.nio.ch.Net.connect(Native Method)
                     at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:507)
                     at java.nio.channels.SocketChannel.open(SocketChannel.java:146)
                     at com.sun.corba.se.impl.transport.DefaultSocketFactoryImpl.createSocket(DefaultSocketFactoryImpl.java:60)
                     at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.<init>(SocketOrChannelConnectionImpl.java:188)
                     ... 23 more
                
                ]]
                • 5. Re: reports 11g tracing
                  tony.g
                  Are you able to look this problem up on metalink?
                  • 6. Re: reports 11g tracing
                    Martijnke
                    Hi,

                    searched metalink

                    found some posts
                    one mentions this could be caused by a lack of a default printer, we have one so that's not applicable, this post also says : we turned tracing on, but does not explain how

                    another one talks about GIFs

                    so couldn't really find an answer there

                    equally inmportant : how do we turn tracing on for reports 11g (no enterprise manager installed)
                    • 7. Re: reports 11g tracing
                      InoL
                      How to setup tracing is described in them manual:
                      http://docs.oracle.com/cd/E15523_01/bi.1111/b32121/pbr_tune003.htm#sthref1452

                      It looks like it's different in 11g. In 10g and below you had the options trace_all etc. The 11g manual is not too clear about this I must say ("specify tracing level to Trace 32").