| BIRT exception in WebSphere connecting to DB@ [message #725931] |
Fri, 16 September 2011 04:18  |
Eclipse User |
|
|
|
I am using BIRT in WebSphere and trying to connect to DB2.
When I try to view my table I get this exception:
org.eclipse.birt.report.service.api.ReportServiceException: Required parameter clientCode is not set.
at org.eclipse.birt.report.service.ReportEngineService.throwDummyException(Unknown Source)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source)
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown Source)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.processMessage(Unknown Source)
at org.apache.axis.providers.java.JavaProvider.invoke(Unknown Source)
at org.apache.axis.strategies.InvocationStrategy.visit(Unknown Source)
at org.apache.axis.SimpleChain.doVisiting(Unknown Source)
at org.apache.axis.SimpleChain.invoke(Unknown Source)
at org.apache.axis.handlers.soap.SOAPService.invoke(Unknown Source)
at org.apache.axis.server.AxisServer.invoke(Unknown Source)
at org.apache.axis.transport.http.AxisServlet.doPost(Unknown Source)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.apache.axis.transport.http.AxisServletBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(Unknown Source)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(Unknown Source)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(Unknown Source)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(Unknown Source)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(Unknown Source)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at org.mortbay.jetty.servlet.ServletHandler.dispatch(Unknown Source)
at org.mortbay.jetty.servlet.ServletHandler.handle(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.http.HttpServer.service(Unknown Source)
at org.mortbay.http.HttpConnection.service(Unknown Source)
at org.mortbay.http.HttpConnection.handleNext(Unknown Source)
at org.mortbay.http.HttpConnection.handle(Unknown Source)
at org.mortbay.http.SocketListener.handleConnection(Unknown Source)
at org.mortbay.util.ThreadedServer.handle(Unknown Source)
at org.mortbay.util.ThreadPool$PoolThread.run(Unknown Source)
Caused by: org.eclipse.birt.report.engine.api.impl.ParameterValidationException: Required parameter clientCode is not set.
at org.eclipse.birt.report.engine.api.impl.EngineTask.validateScalarParameter(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(Unknown Source)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(Unknown Source)
... 49 more
Also, when I try to run my SQL queries I get a BIRT Exception:
A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.3.2.r232_v20090211
Error Code:odaconsumer.CannotGetResultSetMetaData
Error Message:Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DB2ADMIN;SELECT;PPDBASE.VISIT_HISTORY, DRIVER=3.50.152
SQL error #2: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-551;42501;DB2ADMIN|SELECT|PPDBASE.VISIT_HISTORY, DRIVER=3.50.152
SQL error #3: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-551;42501;DB2ADMIN|SELECT|PPDBASE.VISIT_HISTORY, DRIVER=3.50.152
Any Help?
|
|
|
| Re: BIRT exception in WebSphere connecting to DB@ [message #726137 is a reply to message #725931] |
Fri, 16 September 2011 12:18  |
| Eclipse User |
|
|
|
The first error you are getting is because you have a required parameter
in the report design that is not getting set.
Jason
On 9/16/2011 4:18 AM, abdullahchothia wrote:
> I am using BIRT in WebSphere and trying to connect to DB2.
>
> When I try to view my table I get this exception:
>
> org.eclipse.birt.report.service.api.ReportServiceException: Required
> parameter clientCode is not set.
> at
> org.eclipse.birt.report.service.ReportEngineService.throwDummyException(Unknown
> Source)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown
> Source)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.apache.axis.providers.java.RPCProvider.invokeMethod(Unknown Source)
> at org.apache.axis.providers.java.RPCProvider.processMessage(Unknown
> Source)
> at org.apache.axis.providers.java.JavaProvider.invoke(Unknown Source)
> at org.apache.axis.strategies.InvocationStrategy.visit(Unknown Source)
> at org.apache.axis.SimpleChain.doVisiting(Unknown Source)
> at org.apache.axis.SimpleChain.invoke(Unknown Source)
> at org.apache.axis.handlers.soap.SOAPService.invoke(Unknown Source)
> at org.apache.axis.server.AxisServer.invoke(Unknown Source)
> at org.apache.axis.transport.http.AxisServlet.doPost(Unknown Source)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown
> Source)
> at javax.servlet.http.HttpServlet.service(Unknown Source)
> at org.apache.axis.transport.http.AxisServletBase.service(Unknown Source)
> at javax.servlet.http.HttpServlet.service(Unknown Source)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(Unknown
> Source)
> at
> org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(Unknown
> Source)
> at
> org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(Unknown
> Source)
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(Unknown
> Source)
> at
> org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(Unknown
> Source)
> at javax.servlet.http.HttpServlet.service(Unknown Source)
> at
> org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(Unknown
> Source)
> at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
> at org.mortbay.jetty.servlet.ServletHandler.dispatch(Unknown Source)
> at org.mortbay.jetty.servlet.ServletHandler.handle(Unknown Source)
> at org.mortbay.http.HttpContext.handle(Unknown Source)
> at org.mortbay.http.HttpContext.handle(Unknown Source)
> at org.mortbay.http.HttpServer.service(Unknown Source)
> at org.mortbay.http.HttpConnection.service(Unknown Source)
> at org.mortbay.http.HttpConnection.handleNext(Unknown Source)
> at org.mortbay.http.HttpConnection.handle(Unknown Source)
> at org.mortbay.http.SocketListener.handleConnection(Unknown Source)
> at org.mortbay.util.ThreadedServer.handle(Unknown Source)
> at org.mortbay.util.ThreadPool$PoolThread.run(Unknown Source)
> Caused by:
> org.eclipse.birt.report.engine.api.impl.ParameterValidationException:
> Required parameter clientCode is not set.
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.validateScalarParameter(Unknown
> Source)
> at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(Unknown
> Source)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(Unknown
> Source)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(Unknown
> Source)
> at
> org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(Unknown
> Source)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(Unknown
> Source)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(Unknown
> Source)
> ... 49 more
>
>
> Also, when I try to run my SQL queries I get a BIRT Exception:
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.3.2.r232_v20090211
> Error Code:odaconsumer.CannotGetResultSetMetaData
> Error Message:Cannot get the result set metadata.
> SQL statement does not return a ResultSet object.
> SQL error #1: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501,
> SQLERRMC=DB2ADMIN;SELECT;PPDBASE.VISIT_HISTORY, DRIVER=3.50.152
> SQL error #2: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,
> SQLERRMC=2;-551;42501;DB2ADMIN|SELECT|PPDBASE.VISIT_HISTORY,
> DRIVER=3.50.152
> SQL error #3: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098,
> SQLERRMC=2;-551;42501;DB2ADMIN|SELECT|PPDBASE.VISIT_HISTORY,
> DRIVER=3.50.152
>
>
>
> Any Help?
|
|
|
Powered by
FUDForum. Page generated in 0.03478 seconds
Home