My Oracle Support Banner

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 15, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.160419 and later
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 to 12.2.1.4.0 [Release 12g]
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> <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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 (1) Weblogic Server
 (2) Java Host Configuration
 (3) OHS Configuration


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