OBIEE 12c : When An Analysis of Larger Records Exported to Excel, Resulting in Error: " Excel found unreadable content .." (Doc ID 2205965.1)

Last updated on DECEMBER 19, 2022

Applies to:

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) 12.2.1.0.160419 version,

• OBIEE is accessed via Oracle HTTP Server.
• When an analysis exported to Excel (huge data set of more than 50K rows), the file is corrupted and errored out as: "Excel found unreadable content.."

Error In the Logs:

(1) bi_server1.log

####<Oct xx, xxxx 8:48:29 AM xxx> <Error> <HTTP> <Server> <bi_server1> <[ACTIVE] ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <005Ffu6S4yoD^aXptst1iX000B0O000NRJ> <1476362909033> <[severity-value: 8] [rid: 0:4] [partition-id: 0] [partition-name: DOMAIN] > <BEA-101017> <[ServletContext@372697455[app:analytics module:analytics path:null spec-version:3.1]] Root cause of ServletException.
java.io.IOException: Connection reset by peer
at sun.nio.ch.FileDispatcherImpl.write0(Native Method)

(2) jh.log

[xxxx-10-24Txx:xx:11.605-04:00] [messageprocessor] [WARNING] [] [saw.messageprocessor] [tid: 14] [ecid: <>,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)

(3) ohs1.log

[xxxx-11-04Txx:26:xx.9317-04:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 3.xx.xxx.xx] [host_id: <host id>] [host_addr: <host>] [pid: 21444] [tid: 140184435812096] [user: <user>] [ecid: <>] [rid: 0] [VirtualHost: <host>:<port>] ap_proxy: trying GET /analytics/res/v-2XfmW2-hwJA/sk_blafp/dvt/BIChart.swf at backend host <host>/<port>, client <client>/59465, total tries 1; got exception 'WRITE_ERROR_TO_CLIENT [os error=104, line 575 of BaseProxy.cpp]: '; state: writing response body to client; not failing over, referer http://<Server>/analytics/saw.dll?CacheStaticFiles.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.