Unable to download detail report to Excel in obiee12c

sandy45252

Hi Everyone,

I am using obiee 12c version 12.2.1.2 on clustered node. The issue here is i am unable to download the detail report with data more than 65k  records.

When i try to download the report in excel after a while i get this error

"There was an error processing your download.
Please check with your administrator."

And when i check the logs i see "Broken Pipe".

Made all changes recommended in internet, starting from updating the instance config with download limit and odbc limit

brideconnection properties in config file and update the config.xml with below changes

XMLP>
<InputStreamLimitInKB>2048000</InputStreamLimitInKB>
<ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>
</XMLP>

 

Increased the jvm size of javahost to 4096 for excel download.and also increase stuck thread time in biserver to 1200sec to avoid any timeout error

After all this necessary changes i am unable to download details report with more than 65K records.

Listing out errors from presentation server

[2017-04-07T11:21:34Z] [OBIPS] [WARNING:1] [] [saw.httpserver.request.showrequest] [ecid: 86780147-498a-499b-9807-e0f93cb887c3-000001ef,0:3] [tid: 4230870784] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: weblogic] Request received.

Type: POST            Headers:

Accept=text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

Accept-Encoding=gzip, deflate

Accept-Language=en-US,en;q=0.8,te;q=0.6

Cache-Control=max-age=0

Connection=Keep-Alive

Content-Length=2257

Content-Type=application/x-www-form-urlencoded

Cookie=ORA_BIPS_LBINFO=15b48079e4a; ORA_BIPS_NQID=al7ifo3acklta8c9cnh9amrjh366920ouo9h6222om0pbuk9zOr07UFe9WUlkgm; ORA_BI_SESSTOK=sHtgTg0ElsGXbWp4Y5_CxVqLTjFkm4Xo4sq581l4fxKzFN3VNGpCtQAhIPg4SxC8WFiLCIP_CkS26D3zD33gPmDPc8D8gpD4o1_l-Q2yHS2667zc_XAuVcmfZHT-6z5Q; ORA_BI_SESSPARAM=TEFORz1lbiZBQ0M9ZmFsc2U=

Host=ebi12c

Origin=http://localhost

Proxy-Client-IP=localhost

Referer=http://localhost/analyticsInternals/saw.dll?Dashboard

Upgrade-Insecure-Requests=1

User-Agent=Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36

X-Forwarded-For=localhost

x-weblogic-cluster-hash=6CFhkS+5fM9pSime68a3Pef6mBw

X-WebLogic-KeepAliveSecs=30

X-WebLogic-Request-ClusterInfo=true

            Request params:

Go

Extension=.xlsx

path=/shared/Enterprise Reporting/Sales and Sales Ops/Management Dashboards/Reports/SSO20.01 - Global Sales Compensation - Revenue Report

ItemName=SSO20.01 - Global Sales Compensation - Revenue Report

SearchID=0kr66098qm7ac5r6nbtknprp9m

Action=Download

DownloadId=1491563037782

_scid=N2gIDx2aQ25rIK6nJJeK

Style=EQuinix

clientStateXml=<sawst:envState xmlns:sawst="com.siebel.analytics.web/state/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlVersion="200811100"><sawst:container cid="d:dashboard" xsi:type="sawst:topLevelStateContainer" persistPageState="true"><sawst:container cid="p:8ourv1335o90l25s" xsi:type="sawst:page" firstVisit="true" links="efrdc"><sawst:container cid="s:d10inv81v5h4uo5g" xsi:type="sawst:section" rendered="true"><sawst:container cid="g:46hjtn7ko6udtsnt" xsi:type="sawst:dashprompt" links="-"/></sawst:container><sawst:container cid="r:8velu4eoeko3lfd1" xsi:type="sawst:report" links="mfrde" defaultView="compoundView!1" searchId="0kr66098qm7ac5r6nbtknprp9m" folder="/shared/Enterprise Reporting/Sales and Sales Ops/Management Dashboards/Reports" itemName="SSO20.01 - Global Sales Compensation - Revenue Report"><sawst:container cid="v:compoundView!1" xsi:type="sawst:view"><sawst:container cid="v:tableView!1" xsi:type="sawst:view" clientViewportRowStart="17" clientViewportRowEnd="32" clientViewportColStart="0" clientViewportColEnd="1"/></sawst:container></sawst:container><sawst:container cid="s:lt84eqs9c1o7ko2l" xsi:type="sawst:section" rendered="true"/></sawst:container><sawst:container cid="f:dpstate" xsi:type="sawst:dashpromptstate" statepoolId="924hsg23s50moat3344uubsuae"/></sawst:container></sawst:envState>

Format=excel2007

ViewState=ihmcp9vrgsgqm8h0svvi8kaun2

bNotSaveCommand=true

ViewID=d:dashboard~p:8ourv1335o90l25s~r:8velu4eoeko3lfd1

[[

File:httpserver.cpp

Line:354

Location:

  saw.httpserver.request.showrequest

  saw.httpserver.request.longRunning

  saw.httpserver.processrequest

  saw.rpc.server.responder

  saw.rpc.server

  saw.rpc.server.handleConnection

  saw.rpc.server.dispatch

  saw.threadpool.socketrpcserver

  saw.threads

AuthProps: AuthSchema=SSO|IMPERSONATE=weblogic|NQ_SESSION.SERVICEINSTANCEKEY=biservice|PWD=******|UID=system_user|User=weblogic|GUID=weblogic

SessionID: remote.3.m0pbuk9

ElapsedSeconds: 756

RemoteIP: remote

HighwaterBytes: 6229600

SIKey: biservice

]]

[2017-04-07T11:21:34Z] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.finalize] [ecid: 86780147-498a-499b-9807-e0f93cb887c3-000001ef,0:3] [tid: 4230870784] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] An error occurred during execution of "send". Broken pipe [Socket:33][[

File:socket.cpp

Line:861

Location:

  saw.rpc.variablemos.finalize

  saw.rpc.server.responder

  saw.rpc.server

  saw.rpc.server.handleConnection

  saw.rpc.server.dispatch

  saw.threadpool.socketrpcserver

  saw.threads

]]

[2017-04-07T11:21:34Z] [OBIPS] [ERROR:31] [] [saw.rpc.variablemos.finalize] [ecid: 86780147-498a-499b-9807-e0f93cb887c3-000001ef,0:3] [tid: 4230870784] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] An error occurred during execution of "send". Broken pipe [Socket:33][[

File:socket.cpp

Line:861

Location:

  saw.rpc.variablemos.finalize

  saw.rpc.server.responder

  saw.rpc.server

  saw.rpc.server.handleConnection

  saw.rpc.server.dispatch

  saw.threadpool.socketrpcserver

  saw.threads

]]

Thanks,

Sandeep