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 OCTOBER 10, 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.

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
References


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