Getting error while downloading the report in excel

Question

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

StijnGabriels-Oracle · Answer

Hi Abhi,

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

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

Regards,
Stijn

Robert Angel · Answer

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

User_B7ZTH · Answer

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)

]]