Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT exception in WebSphere connecting to DB@
BIRT exception in WebSphere connecting to DB@ [message #725931] Fri, 16 September 2011 04:18 Go to next message
abdullahchothia is currently offline abdullahchothia
Messages: 1
Registered: September 2011
Junior Member
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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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?
Previous Topic:BIRT issue in websphere (Cannot process the org.eclipse.birt.report.data.oda)
Next Topic:How to set the max Y axis scale value in a chart script?
Goto Forum:
  


Current Time: Tue Jul 22 19:42:59 EDT 2014

Powered by FUDForum. Page generated in 0.02162 seconds