cancel
Showing results for 
Search instead for 
Did you mean: 

html error while downloading table entries to Excel.

Former Member
0 Kudos

Hi,

I am getting an error while downloading table entries from webdynpro to excel. After some entries below error script comes and this is not comming all the times.

Is this because of large size?Can anyone please suggest me on this?

<u>Here is the dump:</u>

[code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>Error Report</title>

<style>

td {font-family : Arial, Tahoma, Helvetica, sans-serif; font-size : 14px;}

A:link

A:visited

A:active

</style>

</head>

<body marginwidth="0" marginheight="0" leftmargin="0" topmargin="0" rightmargin="0">

<table width="100%" cellspacing="0" cellpadding="0" border="0" align="left" height="75">

<tr bgcolor="#FFFFFF">

<td align="left" colspan="2" height="48"><font face="Arial, Verdana, Helvetica" size="4" color="#666666"><b> 500 Internal Server Error</b></font></td>

</tr>

<tr bgcolor="#3F73A3">

<td height="23" width="84"><img width=1 height=1 border=0 alt=""></td>

<td height="23"><img width=1 height=1 border=0 alt=""></td>

<td align="right" height="23"><font face="Arial, Verdana, Helvetica" size="2" color="#FFFFFF"><b>SAP J2EE Engine/6.40 </b></font></td>

</tr>

<tr bgcolor="#9DCDFD">

<td height="4" colspan="3"><img width=1 height=1 border=0 alt=""></td>

</tr>

</table>

<br><br><br><br><br><br>

<p><font face="Arial, Verdana, Helvetica" size="3" color="#000000"><b> Application error occurs during processing the request.</b></font></p>

<p><font face="Arial, Verdana, Helvetica" size="2" color="#000000"><table><tr><td valign="top"><b> Details:</b></td><td valign="top"><PRE><pre>com.sap.engine.services.servlets_jsp.server.exceptions.WebIllegalStateException: The stream has already been committed.

at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:792)

at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:780)

at com.sap.engine.services.servlets_jsp.server.runtime.client.HttpServletResponseFacade.sendError(HttpServletResponseFacade.java:768)

at com.sap.tc.webdynpro.serverimpl.core.url.WebDynproExchangeHandler.responseCachedWebResource(WebDynproExchangeHandler.java:98)

at com.sap.tc.webdynpro.serverimpl.core.url.WebDynproExchangeHandler.doExchange(WebDynproExchangeHandler.java:189)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doExchangeProcessing(DispatcherServlet.java:164)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doContent(DispatcherServlet.java:119)

at com.sap.tc.webdynpro.serverimpl.defaultimpl.DispatcherServlet.doGet(DispatcherServlet.java:48)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:391)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:265)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:345)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:323)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:865)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:240)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

</pre></PRE></font></td></tr></table></font></p>

</body>

</html>[/code]

Thanks,

Sanjeev

Accepted Solutions (0)

Answers (1)

Answers (1)

BeGanz
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hallo Sanjeev,

How do you exactly "download the table entries from Web Dynpro to Excel?"

I wrote a new <b>Wiki Code Tutorial </b>which demonstrates how to download an Excel file from a Web Dynpro <i>Table </i>UI element <b>on-demand</b>. In this scenario the resource gets re-created on every request. The solution is based on re-initializing the context with a new 0-byte resource object within the calculated context attribute getter method.

See <a href="https://wiki.sdn.sap.com/wiki/display/Snippets/ExportingTableDatainWebDynproJava-SAPNetWeaver04s">Exporting Table Data in Web Dynpro Java - SAP NetWeaver 04s</a>

Regards, Bertram