<p>Hello</p>
<p> </p>
<p>I am using birt 4.3.2 to design a rptdesign report and trying to deploy the rptdesign to the websphere with the birt runtime 4.5. However I found out that when the rptdesign that had been set connection to the datasource, it will only gives error message as below (even there is only one data in the rptdesign)</p>
<div style="color:#FF0000;"><span style="font-size:10px;"><span>- </span> org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.<br>
AxisFault<br><br>
faultCode: {<a data-ipb='nomediaparse' href='
http://schemas.xmlsoap.org/soap/envelope/}Server.userException'>http://schemas.xmlsoap.org/soap/envelope/}Server.userException</a><br><br>
faultSubcode:<br><br>
faultString: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.<br><br>
faultActor:<br><br>
faultNode:<br><br>
faultDetail:<br><br>
{<a data-ipb='nomediaparse' href='
http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException:'>http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException:</a>Error happened while running the report. <br><br>
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1115)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:943)<br><br>
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)<br><br>
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)<br><br>
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.RunFragment.doService(RunFragment.java:120)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.service(FramesetFragment.java:86)<br><br>
at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(ViewerServlet.java:181)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:160)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)<br><br>
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1635)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)<br><br>
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)<br><br>
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:965)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:508)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)<br><br>
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3994)<br><br>
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)<br><br>
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945)<br><br>
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)<br><br>
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:516)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:307)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:278)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)<br><br>
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)<br><br>
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)<br><br>
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)<br><br>
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)<br><br>
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)<br><br>
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)<br><br>
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)<br><br>
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1662)<br><br>
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.<br><br>
at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2392)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:191)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)<br><br>
... 41 more<br><br>
Caused by: java.lang.NoSuchMethodError: com/ibm/icu/lang/UCharacter.getBidiPairedBracket(I)I<br><br>
at com.ibm.icu.text.Bidi.bracketProcessChar(Bidi.java:2278)<br><br>
at com.ibm.icu.text.Bidi.resolveExplicitLevels(Bidi.java:2482)<br><br>
at com.ibm.icu.text.Bidi.setPara(Bidi.java:4051)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5373)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5260)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.isBidi(BidiEngine.java:328)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.process(BidiEngine.java:64)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiTransform.transform(BidiTransform.java:39)<br><br>
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiResultSetMetaData.getColumnName(BidiResultSetMetaData.java:56)<br><br>
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSetMetaData.getColumnName(OdaResultSetMetaData.java:91)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.getColumnName(ResultSetMetaData.java:92)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init>(ProjectedColumns.java:57)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetProjectedColumns(PreparedStatement.java:433)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:378)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.addColumnHint(PreparedStatement.java:994)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addColumnHints(DataSourceQuery.java:734)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:410)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:347)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)<br><br>
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:349)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)<br><br>
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)<br><br>
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)<br><br>
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:285)<br><br>
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)<br><br>
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)<br><br>
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)<br><br>
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)<br><br>
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)<br><br>
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)<br><br>
... 43 more<br><br><br><br>
{<a data-ipb='nomediaparse' href='
http://xml.apache.org/axis/}hostname:TR-3-10'>http://xml.apache.org/axis/}hostname:TR-3-10</a><br><br>
{}:org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.<br><br>
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1115)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:943)<br><br>
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)<br><br>
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)<br><br>
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.RunFragment.doService(RunFragment.java:120)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.service(FramesetFragment.java:86)<br><br>
at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(ViewerServlet.java:181)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:160)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)<br><br>
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1635)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)<br><br>
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)<br><br>
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:965)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:508)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)<br><br>
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3994)<br><br>
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)<br><br>
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945)<br><br>
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)<br><br>
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:516)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:307)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:278)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)<br><br>
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)<br><br>
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)<br><br>
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)<br><br>
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)<br><br>
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)<br><br>
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)<br><br>
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)<br><br>
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1662)<br><br>
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.<br><br>
at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2392)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:191)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)<br><br>
... 41 more<br><br>
Caused by: java.lang.NoSuchMethodError: com/ibm/icu/lang/UCharacter.getBidiPairedBracket(I)I<br><br>
at com.ibm.icu.text.Bidi.bracketProcessChar(Bidi.java:2278)<br><br>
at com.ibm.icu.text.Bidi.resolveExplicitLevels(Bidi.java:2482)<br><br>
at com.ibm.icu.text.Bidi.setPara(Bidi.java:4051)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5373)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5260)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.isBidi(BidiEngine.java:328)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.process(BidiEngine.java:64)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiTransform.transform(BidiTransform.java:39)<br><br>
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiResultSetMetaData.getColumnName(BidiResultSetMetaData.java:56)<br><br>
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSetMetaData.getColumnName(OdaResultSetMetaData.java:91)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.getColumnName(ResultSetMetaData.java:92)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init>(ProjectedColumns.java:57)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetProjectedColumns(PreparedStatement.java:433)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:378)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.addColumnHint(PreparedStatement.java:994)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addColumnHints(DataSourceQuery.java:734)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:410)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:347)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)<br><br>
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:349)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)<br><br>
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)<br><br>
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)<br><br>
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:285)<br><br>
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)<br><br>
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)<br><br>
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)<br><br>
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)<br><br>
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)<br><br>
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)<br><br>
... 43 more<br><br><br><br><br><br>
org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.<br><br>
at org.apache.axis.AxisFault.makeFault(AxisFault.java:101)<br><br>
at org.eclipse.birt.report.utility.BirtUtility.makeAxisFault(BirtUtility.java:777)<br><br>
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:94)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.RunFragment.doService(RunFragment.java:120)<br><br>
at org.eclipse.birt.report.presentation.aggregation.layout.FramesetFragment.service(FramesetFragment.java:86)<br><br>
at org.eclipse.birt.report.servlet.ViewerServlet.__doGet(ViewerServlet.java:181)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doGet(BirtSoapMessageDispatcherServlet.java:160)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)<br><br>
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br><br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)<br><br>
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1694)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1635)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)<br><br>
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)<br><br>
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)<br><br>
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:965)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:508)<br><br>
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)<br><br>
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3994)<br><br>
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:276)<br><br>
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:945)<br><br>
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)<br><br>
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:516)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:307)<br><br>
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:278)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)<br><br>
at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)<br><br>
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)<br><br>
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)<br><br>
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)<br><br>
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)<br><br>
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)<br><br>
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)<br><br>
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)<br><br>
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1662)<br><br>
Caused by: org.eclipse.birt.report.service.api.ReportServiceException: Error happened while running the report.<br><br>
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(ReportEngineService.java:1115)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:943)<br><br>
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)<br><br>
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(BirtRunAndRenderActionHandler.java:76)<br><br>
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br><br>
... 38 more<br><br>
Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.<br><br>
at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2392)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:191)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br><br>
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)<br><br>
... 41 more<br><br>
Caused by: java.lang.NoSuchMethodError: com/ibm/icu/lang/UCharacter.getBidiPairedBracket(I)I<br><br>
at com.ibm.icu.text.Bidi.bracketProcessChar(Bidi.java:2278)<br><br>
at com.ibm.icu.text.Bidi.resolveExplicitLevels(Bidi.java:2482)<br><br>
at com.ibm.icu.text.Bidi.setPara(Bidi.java:4051)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5373)<br><br>
at com.ibm.icu.text.Bidi.<init>(Bidi.java:5260)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.isBidi(BidiEngine.java:328)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiEngine.process(BidiEngine.java:64)<br><br>
at org.eclipse.birt.report.data.bidi.utils.core.BidiTransform.transform(BidiTransform.java:39)<br><br>
at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiResultSetMetaData.getColumnName(BidiResultSetMetaData.java:56)<br><br>
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaResultSetMetaData.getColumnName(OdaResultSetMetaData.java:91)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ResultSetMetaData.getColumnName(ResultSetMetaData.java:92)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.ProjectedColumns.<init>(ProjectedColumns.java:57)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.doGetProjectedColumns(PreparedStatement.java:433)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:378)<br><br>
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.addColumnHint(PreparedStatement.java:994)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.addColumnHints(DataSourceQuery.java:734)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:410)<br><br>
at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:347)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)<br><br>
at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:349)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)<br><br>
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)<br><br>
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)<br><br>
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)<br><br>
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:285)<br><br>
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)<br><br>
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)<br><br>
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)<br><br>
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)<br><br>
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)<br><br>
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)<br><br>
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)<br><br>
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)<br><br>
... 43 more</span></div>
<div style="color:#FF0000;"><span style="color:rgb(0,0,0);">However, when I </span><span style="color:#000000;">deploy to tomcat, everything is all right.</span></div>
<div style="color:#FF0000;"> </div>
<div style="color:#FF0000;"><span style="color:#000000;">I am sure that I had followed the instruction from </span></div>
<div style="color:#FF0000;"><a data-ipb='nomediaparse' href='
http://wiki.eclipse.org/BirtPOJO_Viewer_WebSphere_Deployment'><span style="color:#000000;">
http://wiki.eclipse.org/BirtPOJO_Viewer_WebSphere_Deployment</span></a></div>
<div style="color:#FF0000;"><span style="color:#000000;">and had type details in web.xml and ibm-web-bnd.xml, also I got my db user name and password right but the websphere seems doesn't load the report which come with datasource.</span></div>
<div style="color:#FF0000;"> </div>
<div style="color:#FF0000;"><span style="color:#000000;">Anyone know what's happen?</span></div>
