Report Could Not Be Generated When Running on upgraded web server

mmah

Hi there,

While performing a test run on our upgraded web server, the report could not be generated and displays two notable exceptions notably RunAndRender with the PreparedQuery exception.

We recently upgraded our web server to Weblogic 10.3 from 10.0. Previously, when we tested in 10.0, the report can be generated without a problem.

The reports were designed on BIRT 2.3.1.

I'm not sure that given Weblogic 10.3 uses JDK 1.6.05, perhaps that creates the problem for the reports.

Please help as we need to solve this urgently.

The complete stacktrace is as follows:

org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:72)
at com.premia.report.engine.WebReport.doGet(WebReport.java:191)
at com.premia.report.engine.WebReport.doPost(WebReport.java:205)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:292)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3498)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2180)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2086)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1406)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.lang.AssertionError
at org.eclipse.birt.data.engine.impl.PreparedQuery.prepareExpression(PreparedQuery.java:420)
at org.eclipse.birt.data.engine.impl.PreparedQuery.prepareExpressions(PreparedQuery.java:365)
at org.eclipse.birt.data.engine.impl.PreparedQuery.prepareGroup(PreparedQuery.java:315)
at org.eclipse.birt.data.engine.impl.PreparedQuery.prepare(PreparedQuery.java:199)
at org.eclipse.birt.data.engine.impl.PreparedQuery.(PreparedQuery.java:122)
at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.(PreparedDataSourceQuery.java:75)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.(PreparedOdaDSQuery.java:62)
at org.eclipse.birt.data.engine.impl.PreparedQueryUtil.newInstance(PreparedQueryUtil.java:154)
at org.eclipse.birt.data.engine.impl.DataEngineImpl.prepare(DataEngineImpl.java:419)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:341)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.prepare(DataRequestSessionImpl.java:506)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doPrepareQuery(AbstractDataEngine.java:203)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:167)
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:109)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:51)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:59)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:149)
... 17 more