It's all about the answers!

Ask a question

Download As Spreadsheet (.csv)" using IE11 reports java.io.IOException error


vinay kumar bondugula (7111844) | asked Jan 04 '19, 4:51 p.m.

Hi,


Our team is trying to dynamic query (i.e. provide the values once run the query) the workitems using id's separated by comma and able to execute the query. But when we try to download the results as .csv, it fails on IE11, but was successful and able to download the .csv using Chrome and Firefox. The below is the error we receive when tried to download the query as spreadsheet using IE. Please let us know how to overcome the issue.

RTC server/client version: 6.0.3 iFix13.
Database: SQL

{"errorMessage":"Expecting either "," or "}" at line/column: line 1, column 1,480","errorClass":"java.io.IOException","errorTrace":["com.ibm.team.repository.common.json.internal.Parser.parseArray(Parser.java:105)","com.ibm.team.repository.common.json.internal.Parser.parseValue(Parser.java:149)","com.ibm.team.repository.common.json.internal.Parser.parseObject(Parser.java:63)","com.ibm.team.repository.common.json.internal.Parser.parseValue(Parser.java:151)","com.ibm.team.repository.common.json.internal.Parser.parseObject(Parser.java:63)","com.ibm.team.repository.common.json.internal.Parser.parseValue(Parser.java:151)","com.ibm.team.repository.common.json.internal.Parser.parse(Parser.java:31)","com.ibm.team.repository.common.json.JSONObject.parse(JSONObject.java:72)","com.ibm.team.workitem.service.internal.query.ResultSetSerializer.serializeQueryResults(ResultSetSerializer.java:324)","com.ibm.team.workitem.service.internal.query.ResultSetSerializer.serializeItem(ResultSetSerializer.java:133)","com.ibm.team.gateway.service.internal.AbstractRestService.serializeItem(AbstractRestService.java:255)","com.ibm.team.gateway.service.internal.ItemRestService.doReadResponse(ItemRestService.java:180)","com.ibm.team.gateway.service.internal.ItemRestService.perform_GET(ItemRestService.java:96)","com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:84)","sun.reflect.GeneratedMethodAccessor288.invoke(Unknown Source)","sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)","java.lang.reflect.Method.invoke(Method.java:620)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)","com.sun.proxy.$Proxy476.service(Unknown Source)","com.ibm.team.repository.service.internal.ItemRenderService.forward(ItemRenderService.java:452)","com.ibm.team.repository.service.internal.ItemRenderService.perform_GET(ItemRenderService.java:144)","com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:84)","sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)","sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)","java.lang.reflect.Method.invoke(Method.java:620)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)","org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)","com.sun.proxy.$Proxy586.service(Unknown Source)","com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:1010)","com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2593)","com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2388)","com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1836)","javax.servlet.http.HttpServlet.service(HttpServlet.java:668)","org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)","org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)","org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)","org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)","javax.servlet.http.HttpServlet.service(HttpServlet.java:668)","org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:152)","com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)","javax.servlet.http.HttpServlet.service(HttpServlet.java:668)","com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)","com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)","com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)","com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)","com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)","com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)","com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)","com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)","com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)","com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)","com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967)","com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)","com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3951)","com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)","com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1014)","com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)","com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)","com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)","com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)","com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)","com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)","com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)","com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)","com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)","com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)","com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)","com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)","com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)","com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)"],"errorCode":500,"errorTraceMarshall":[{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseArray","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":105},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseValue","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":149},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseObject","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":63},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseValue","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":151},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseObject","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":63},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parseValue","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":151},{"errorTraceFileName":"Parser.java","errorTraceMethodName":"parse","errorTraceClassName":"com.ibm.team.repository.common.json.internal.Parser","errorTraceLineNumber":31},{"errorTraceFileName":"JSONObject.java","errorTraceMethodName":"parse","errorTraceClassName":"com.ibm.team.repository.common.json.JSONObject","errorTraceLineNumber":72},{"errorTraceFileName":"ResultSetSerializer.java","errorTraceMethodName":"serializeQueryResults","errorTraceClassName":"com.ibm.team.workitem.service.internal.query.ResultSetSerializer","errorTraceLineNumber":324},{"errorTraceFileName":"ResultSetSerializer.java","errorTraceMethodName":"serializeItem","errorTraceClassName":"com.ibm.team.workitem.service.internal.query.ResultSetSerializer","errorTraceLineNumber":133},{"errorTraceFileName":"AbstractRestService.java","errorTraceMethodName":"serializeItem","errorTraceClassName":"com.ibm.team.gateway.service.internal.AbstractRestService","errorTraceLineNumber":255},{"errorTraceFileName":"ItemRestService.java","errorTraceMethodName":"doReadResponse","errorTraceClassName":"com.ibm.team.gateway.service.internal.ItemRestService","errorTraceLineNumber":180},{"errorTraceFileName":"ItemRestService.java","errorTraceMethodName":"perform_GET","errorTraceClassName":"com.ibm.team.gateway.service.internal.ItemRestService","errorTraceLineNumber":96},{"errorTraceFileName":"TeamRawService.java","errorTraceMethodName":"service","errorTraceClassName":"com.ibm.team.repository.service.TeamRawService","errorTraceLineNumber":84},{"errorTraceFileName":null,"errorTraceMethodName":"invoke","errorTraceClassName":"sun.reflect.GeneratedMethodAccessor288","errorTraceLineNumber":-1},{"errorTraceFileName":"DelegatingMethodAccessorImpl.java","errorTraceMethodName":"invoke","errorTraceClassName":"sun.reflect.DelegatingMethodAccessorImpl","errorTraceLineNumber":56},{"errorTraceFileName":"Method.java","errorTraceMethodName":"invoke","errorTraceClassName":"java.lang.reflect.Method","errorTraceLineNumber":620},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"invoke","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord","errorTraceLineNumber":361},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"access$0","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord","errorTraceLineNumber":347},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"invoke","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler","errorTraceLineNumber":56},{"errorTraceFileName":null,"errorTraceMethodName":"service","errorTraceClassName":"com.sun.proxy.$Proxy476","errorTraceLineNumber":-1},{"errorTraceFileName":"ItemRenderService.java","errorTraceMethodName":"forward","errorTraceClassName":"com.ibm.team.repository.service.internal.ItemRenderService","errorTraceLineNumber":452},{"errorTraceFileName":"ItemRenderService.java","errorTraceMethodName":"perform_GET","errorTraceClassName":"com.ibm.team.repository.service.internal.ItemRenderService","errorTraceLineNumber":144},{"errorTraceFileName":"TeamRawService.java","errorTraceMethodName":"service","errorTraceClassName":"com.ibm.team.repository.service.TeamRawService","errorTraceLineNumber":84},{"errorTraceFileName":null,"errorTraceMethodName":"invoke","errorTraceClassName":"sun.reflect.GeneratedMethodAccessor133","errorTraceLineNumber":-1},{"errorTraceFileName":"DelegatingMethodAccessorImpl.java","errorTraceMethodName":"invoke","errorTraceClassName":"sun.reflect.DelegatingMethodAccessorImpl","errorTraceLineNumber":56},{"errorTraceFileName":"Method.java","errorTraceMethodName":"invoke","errorTraceClassName":"java.lang.reflect.Method","errorTraceLineNumber":620},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"invoke","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord","errorTraceLineNumber":361},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"access$0","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord","errorTraceLineNumber":347},{"errorTraceFileName":"ExportProxyServiceRecord.java","errorTraceMethodName":"invoke","errorTraceClassName":"org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler","errorTraceLineNumber":56},{"errorTraceFileName":null,"errorTraceMethodName":"service","errorTraceClassName":"com.sun.proxy.$Proxy586","errorTraceLineNumber":-1},{"errorTraceFileName":"AbstractTeamServerServlet.java","errorTraceMethodName":"doRestService","errorTraceClassName":"com.ibm.team.repository.servlet.AbstractTeamServerServlet","errorTraceLineNumber":1010},{"errorTraceFileName":"AbstractTeamServerServlet.java","errorTraceMethodName":"handleRequest2","errorTraceClassName":"com.ibm.team.repository.servlet.AbstractTeamServerServlet","errorTraceLineNumber":2593},{"errorTraceFileName":"AbstractTeamServerServlet.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.team.repository.servlet.AbstractTeamServerServlet","errorTraceLineNumber":2388},{"errorTraceFileName":"AbstractTeamServerServlet.java","errorTraceMethodName":"service","errorTraceClassName":"com.ibm.team.repository.servlet.AbstractTeamServerServlet","errorTraceLineNumber":1836},{"errorTraceFileName":"HttpServlet.java","errorTraceMethodName":"service","errorTraceClassName":"javax.servlet.http.HttpServlet","errorTraceLineNumber":668},{"errorTraceFileName":"ServletManager.java","errorTraceMethodName":"service","errorTraceClassName":"org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper","errorTraceLineNumber":180},{"errorTraceFileName":"ServletRegistration.java","errorTraceMethodName":"service","errorTraceClassName":"org.eclipse.equinox.http.servlet.internal.ServletRegistration","errorTraceLineNumber":61},{"errorTraceFileName":"ProxyServlet.java","errorTraceMethodName":"processAlias","errorTraceClassName":"org.eclipse.equinox.http.servlet.internal.ProxyServlet","errorTraceLineNumber":128},{"errorTraceFileName":"ProxyServlet.java","errorTraceMethodName":"service","errorTraceClassName":"org.eclipse.equinox.http.servlet.internal.ProxyServlet","errorTraceLineNumber":76},{"errorTraceFileName":"HttpServlet.java","errorTraceMethodName":"service","errorTraceClassName":"javax.servlet.http.HttpServlet","errorTraceLineNumber":668},{"errorTraceFileName":"BridgeServlet.java","errorTraceMethodName":"service","errorTraceClassName":"org.eclipse.equinox.servletbridge.BridgeServlet","errorTraceLineNumber":152},{"errorTraceFileName":"JazzServlet.java","errorTraceMethodName":"service","errorTraceClassName":"com.ibm.team.repository.server.servletbridge.JazzServlet","errorTraceLineNumber":74},{"errorTraceFileName":"HttpServlet.java","errorTraceMethodName":"service","errorTraceClassName":"javax.servlet.http.HttpServlet","errorTraceLineNumber":668},{"errorTraceFileName":"ServletWrapper.java","errorTraceMethodName":"service","errorTraceClassName":"com.ibm.ws.webcontainer.servlet.ServletWrapper","errorTraceLineNumber":1232},{"errorTraceFileName":"ServletWrapper.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.servlet.ServletWrapper","errorTraceLineNumber":781},{"errorTraceFileName":"ServletWrapper.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.servlet.ServletWrapper","errorTraceLineNumber":480},{"errorTraceFileName":"ServletWrapperImpl.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.servlet.ServletWrapperImpl","errorTraceLineNumber":178},{"errorTraceFileName":"WebAppFilterChain.java","errorTraceMethodName":"invokeTarget","errorTraceClassName":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","errorTraceLineNumber":136},{"errorTraceFileName":"WebAppFilterChain.java","errorTraceMethodName":"doFilter","errorTraceClassName":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","errorTraceLineNumber":97},{"errorTraceFileName":"BridgeFilter.java","errorTraceMethodName":"processDelegate","errorTraceClassName":"com.ibm.team.repository.server.servletbridge.BridgeFilter","errorTraceLineNumber":165},{"errorTraceFileName":"BridgeFilter.java","errorTraceMethodName":"doFilter","errorTraceClassName":"com.ibm.team.repository.server.servletbridge.BridgeFilter","errorTraceLineNumber":198},{"errorTraceFileName":"FilterInstanceWrapper.java","errorTraceMethodName":"doFilter","errorTraceClassName":"com.ibm.ws.webcontainer.filter.FilterInstanceWrapper","errorTraceLineNumber":195},{"errorTraceFileName":"WebAppFilterChain.java","errorTraceMethodName":"doFilter","errorTraceClassName":"com.ibm.ws.webcontainer.filter.WebAppFilterChain","errorTraceLineNumber":91},{"errorTraceFileName":"WebAppFilterManager.java","errorTraceMethodName":"doFilter","errorTraceClassName":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","errorTraceLineNumber":967},{"errorTraceFileName":"WebAppFilterManager.java","errorTraceMethodName":"invokeFilters","errorTraceClassName":"com.ibm.ws.webcontainer.filter.WebAppFilterManager","errorTraceLineNumber":1107},{"errorTraceFileName":"WebApp.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.webapp.WebApp","errorTraceLineNumber":3951},{"errorTraceFileName":"WebGroup.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.webapp.WebGroup","errorTraceLineNumber":304},{"errorTraceFileName":"WebContainer.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.WebContainer","errorTraceLineNumber":1014},{"errorTraceFileName":"WSWebContainer.java","errorTraceMethodName":"handleRequest","errorTraceClassName":"com.ibm.ws.webcontainer.WSWebContainer","errorTraceLineNumber":1817},{"errorTraceFileName":"WCChannelLink.java","errorTraceMethodName":"ready","errorTraceClassName":"com.ibm.ws.webcontainer.channel.WCChannelLink","errorTraceLineNumber":200},{"errorTraceFileName":"HttpInboundLink.java","errorTraceMethodName":"handleDiscrimination","errorTraceClassName":"com.ibm.ws.http.channel.inbound.impl.HttpInboundLink","errorTraceLineNumber":463},{"errorTraceFileName":"HttpInboundLink.java","errorTraceMethodName":"handleNewRequest","errorTraceClassName":"com.ibm.ws.http.channel.inbound.impl.HttpInboundLink","errorTraceLineNumber":530},{"errorTraceFileName":"HttpInboundLink.java","errorTraceMethodName":"processRequest","errorTraceClassName":"com.ibm.ws.http.channel.inbound.impl.HttpInboundLink","errorTraceLineNumber":316},{"errorTraceFileName":"HttpICLReadCallback.java","errorTraceMethodName":"complete","errorTraceClassName":"com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback","errorTraceLineNumber":88},{"errorTraceFileName":"AioReadCompletionListener.java","errorTraceMethodName":"futureCompleted","errorTraceClassName":"com.ibm.ws.tcp.channel.impl.AioReadCompletionListener","errorTraceLineNumber":175},{"errorTraceFileName":"AbstractAsyncFuture.java","errorTraceMethodName":"invokeCallback","errorTraceClassName":"com.ibm.io.async.AbstractAsyncFuture","errorTraceLineNumber":217},{"errorTraceFileName":"AsyncChannelFuture.java","errorTraceMethodName":"fireCompletionActions","errorTraceClassName":"com.ibm.io.async.AsyncChannelFuture","errorTraceLineNumber":161},{"errorTraceFileName":"AsyncFuture.java","errorTraceMethodName":"completed","errorTraceClassName":"com.ibm.io.async.AsyncFuture","errorTraceLineNumber":138},{"errorTraceFileName":"ResultHandler.java","errorTraceMethodName":"complete","errorTraceClassName":"com.ibm.io.async.ResultHandler","errorTraceLineNumber":204},{"errorTraceFileName":"ResultHandler.java","errorTraceMethodName":"runEventProcessingLoop","errorTraceClassName":"com.ibm.io.async.ResultHandler","errorTraceLineNumber":775},{"errorTraceFileName":"ResultHandler.java","errorTraceMethodName":"run","errorTraceClassName":"com.ibm.io.async.ResultHandler$2","errorTraceLineNumber":905},{"errorTraceFileName":"ThreadPool.java","errorTraceMethodName":"run","errorTraceClassName":"com.ibm.ws.util.ThreadPool$Worker","errorTraceLineNumber":1892}]}

Thanks,
Vinay

Be the first one to answer this question!


Register or to post your answer.