Hi All,<br />
<br />
We have BIRT 2.2.1 deployed into our Java app (WAS 5.1.1 app server) as a custom viewer and are getting the following error in the server logs when running the following reports from within the application.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
[09/01/09 17:54:08:656 GMT] 2ef88561 SystemErr R 09-Jan-2009 17:54:08 org.eclipse.birt.report.engine.api.impl.RunAndRenderTask doRun
SEVERE: An error happened while running the report. Cause:
java.lang.StringIndexOutOfBoundsException: String index out of range: 2
at java.lang.String.substring(String.java(Compiled Code))
at com.ibm.db2.jcc.c.l.a(l.java:888)
at com.ibm.db2.jcc.c.md.getMessage(md.java:244)
at com.ibm.db2.jcc.c.md.a(md.java:284)
at com.ibm.db2.jcc.c.SqlException.getMessage(SqlException.java:194)
at java.lang.Throwable.getLocalizedMessage(Throwable.java(Compiled Code))
at org.eclipse.birt.report.data.oda.jdbc.JDBCException.getSQLExceptionMesssage(JDBCException.java:202)
at org.eclipse.birt.report.data.oda.jdbc.JDBCException.getMessage(JDBCException.java:155)
at java.lang.Throwable.getLocalizedMessage(Throwable.java(Compiled Code))
at java.lang.Throwable.toString(Throwable.java(Compiled Code))
at org.eclipse.datatools.connectivity.oda.OdaException.toString(OdaException.java:203)
at java.lang.Throwable.<init>(Throwable.java(Inlined Compiled Code))
at java.lang.Exception.<init>(Exception.java(Compiled Code))
at org.eclipse.birt.core.exception.BirtException.<init>(BirtException.java(Compiled Code))
at org.eclipse.birt.data.engine.core.DataException.<init>(DataException.java(Compiled Code))
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.handleException(ResultSet.java(Compiled Code))
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(ResultSet.java(Compiled Code))
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java(Compiled Code))
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java(Compiled Code))
at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java(Compiled Code))
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java(Compiled Code))
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:261)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initOdaResult(SmartCacheHelper.java:149)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:76)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:53)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:97)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:61)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:185)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:90)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:72)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:208)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:77)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:510)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:338)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:767)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:217)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:157)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:83)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:157)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:117)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:182)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java(Inlined Compiled Code))
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java(Compiled Code))
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:61)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java(Compiled Code))
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java(Inlined Compiled Code))
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java(Compiled Code))
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java(Compiled Code))
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:85)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:106)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:140)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:68)
at com.pirean.reporting.util.ReportHandler.runAndRender(ReportHandler.java:196)
at com.pirean.reporting.services.ReportViewer.doGet(ReportViewer.java:184)
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:936)
</pre>
<br />
When running the same reports in the BIRT designer against the same data source they both work without any issue.<br />
<br />
At first glance looks like a substring issue, although there are no references to to any substrings in the designs<br />
<br />
Can anyone shed some light on the possible problem?<br />
<br />
Many Thanks<br />
Eugene
