4 Replies Latest reply on Aug 29, 2018 1:16 PM by StijnGabriels-Oracle

    Getting error while downloading the report in excel

    3521884

      Hello Experts,

       

      We have migrated to  Oracle Business Intelligence Product Version 12.2.1.3.0 (Build BIPS-20170820114118 64-bit).

       

      We have a report created in our analysis, and whenever a user is trying to download it in excel we are getting an error:-

       

       

      We have google all the option available, but its not working.

       

      Can anyone has hit the same problem.

       

      Thanks & Regards,

      Abhi

        • 1. Re: Getting error while downloading the report in excel
          Joel Acha

          Have you checked your log files? check the Java Host , Presentation Services and the BI Server log files and post any errors you see here if required.

          1 person found this helpful
          • 2. Re: Getting error while downloading the report in excel
            3521884

            Hello Joel,

             

            I tried to find the logs you suggested but I am getting the below error only in OBIJH:-

             

            2018-08-29T12:53:46.235+03:00] [messageprocessor] [WARNING] [] [saw.messageprocessor] [tid: 23] [ecid: 259f38a6-d1b6-4e6c-9222-c1806d47c175-00000002,0] Unexpected exception. Connection will be closed[[

            java.io.IOException: Broken pipe

            at sun.nio.ch.FileDispatcherImpl.write0(Native Method)

            at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)

            at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)

            at sun.nio.ch.IOUtil.write(IOUtil.java:65)

            at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:471)

            at com.siebel.analytics.javahost.io.ChannelWithTimeout.write(ChannelWithTimeout.java:174)

            at com.siebel.analytics.javahost.io.BlockingIOImpl.write(BlockingIOImpl.java:32)

            at com.siebel.analytics.javahost.io.BlockingIOOutputStream.writeBuffer(BlockingIOOutputStream.java:64)

            at com.siebel.analytics.javahost.io.BlockingIOOutputStream.flush(BlockingIOOutputStream.java:27)

            at com.siebel.analytics.javahost.io.BlockingIOOutputStream.write(BlockingIOOutputStream.java:48)

            at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)

            at java.io.BufferedOutputStream.write(BufferedOutputStream.java:126)

            at java.io.ByteArrayOutputStream.writeTo(ByteArrayOutputStream.java:167)

            at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolOutputStreamImpl.finishChunkInternal(SAWProtocolOutputStreamImpl.java:158)

            at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolOutputStreamImpl.finishMessageOnServerSide(SAWProtocolOutputStreamImpl.java:184)

            at com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolOutputStreamImpl.finishMessageOnServerSide(SAWProtocolOutputStreamImpl.java:169)

            at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:299)

            at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:200)

            at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223)

            at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:207)

            at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:155)

            at java.lang.Thread.run(Thread.java:748)

             

             

            ]]

            • 3. Re: Getting error while downloading the report in excel
              Robert Angel

              Is there any kind of security that could be blocking the socket in question?

              • 4. Re: Getting error while downloading the report in excel
                StijnGabriels-Oracle

                Hi Abhi,

                 

                I recommend article about configuring OBIEE 12c for Excel downloads:

                https://www.clearpeaks.com/obiee-12c-export-to-excel-issue/

                 

                Regards,
                Stijn