Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Getting error while downloading the report in excel

Received Response
82
Views
4
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:40PM in Oracle Analytics Cloud and Server

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:-

pastedImage_0.png

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

Can anyone has hit the same problem.

Thanks & Regards,

Abhi

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    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.

  • User_B7ZTH
    User_B7ZTH Rank 5 - Community Champion

    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)

    ]]

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

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

  • StijnGabriels-Oracle
    StijnGabriels-Oracle Rank 2 - Community Beginner

    Hi Abhi,

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

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

    Regards,
    Stijn