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 JULY 03, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.160419 and later
Information in this document applies to any platform.

Symptoms

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

  

Error In the Logs:

(1) bi_server1.log

####<Oct xx, xxxx 8:48:29 AM xxx> <Error> <HTTP> <xxxxxxx> <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: e25127a4-d041-485b-b269-4d8a5096b1bb-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)

(3) ohs1.log

[xxxx-11-04Txx:26:xx.9317-04:00] [OHS] [ERROR:32] [OH99999] [weblogic] [client_id: 3.xx.xxx.xx] [host_id: xxxxxxxxxx] [host_addr: xx.xx.xx.xx] [pid: 21444] [tid: 140184435812096] [user: xxxxx] [ecid: 005G7aVtFjh0bqXLtug8yX0005Eb0007es] [rid: 0] [VirtualHost: xx.xx.xx.xx:40745] ap_proxy: trying GET /analytics/res/v-2XfmW2-hwJA/sk_blafp/dvt/BIChart.swf at backend host xx.xx.xx.xx/30791, client xx.xx.xx.xx/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://xxxxxxxxxx.com/analytics/saw.dll?CacheStaticFiles.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms