Description sudarshan Mising name 2013-04-03 02:46:51 EDT

Created attachment 229265 [details]
Screenshot of the actual error occurred  in BIRT Report

BIRT Build : 4.2.2
DB : Oracle 11g
OS : Windows XP

Following error message is received when a parameter value is passed from ReportEngine API to BIRT report.



Cannot get the type for parameter: 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter ty
pe.
SQL error #1:Unsupported feature
 ;
    java.sql.SQLException: Unsupported feature
org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred
 during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: QueryStatus
Cannot get the type for parameter: 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter ty
pe.
SQL error #1:Unsupported feature
 ;
    java.sql.SQLException: Unsupported feature
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec
ute(DataRequestSessionImpl.java:644)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(
DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Ab
stractDataEngine.java:267)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.exec
uteQueries(ExtendedGenerateExecutor.java:205)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.exec
ute(ExtendedGenerateExecutor.java:65)
        at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(
ExtendedItemExecutor.java:62)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicat
eItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt
emExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReport
ItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
        at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resum
eLayout(HTMLInlineStackingLM.java:111)
        at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layou
tNodes(HTMLInlineStackingLM.java:160)
        at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:70)
        at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
        at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren
(HTMLTableLM.java:132)
        at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:70)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage
LM.java:92)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay
out(HTMLReportLayoutEngine.java:100)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAnd
RenderTask.java:180)
        at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRe
nderTask.java:77)
        at sb.ops.it.ecm.cqm.mis.dashboard.impl.DashboardService.generateReport(
DashboardService.java:50)
        at sb.ops.it.ecm.cqm.mis.dashboard.impl.DashboardService.getManagerDashb
oardHTML(DashboardService.java:70)
        at sb.ops.it.ecm.cqm.web.delegate.dashboard.impl.DashboardDeligate.getMa
nagerDashboardHTML(DashboardDeligate.java:22)
        at sb.ops.it.ecm.cqm.web.action.mis.MISActionBean.getUserScoreCardHTML(M
ISActionBean.java:105)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(Dispa
tcherHelper.java:442)
        at net.sourceforge.stripes.controller.ExecutionContext.proceed(Execution
Context.java:158)
        at net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.inter
cept(BeforeAfterMethodInterceptor.java:113)
        at net.sourceforge.stripes.controller.ExecutionContext.proceed(Execution
Context.java:155)
        at net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionCon
text.java:74)
        at net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandle
r(DispatcherHelper.java:440)
        at net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandl
er(DispatcherServlet.java:285)
        at net.sourceforge.stripes.controller.DispatcherServlet.doPost(Dispatche
rServlet.java:167)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511
)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1221)
        at net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilt
er.java:246)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at sb.ops.it.ecm.cqm.web.filter.HibernateSessionFilter.doFilter(Hibernat
eSessionFilter.java:37)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at com.planetj.servlet.filter.compression.CompressingFilter.doFilter(Com
pressingFilter.java:270)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(Servlet
Handler.java:1212)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
99)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
a:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
82)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:7
66)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450)

        at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
lerCollection.java:230)
        at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
java:114)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
52)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:54
2)
        at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
nnection.java:928)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
va:410)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.j
ava:582)
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare th
e query execution for the data set: QueryStatus
Cannot get the type for parameter: 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter ty
pe.
SQL error #1:Unsupported feature
 ;
    java.sql.SQLException: Unsupported feature
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Quer
yExecutor.java:345)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQue
ry.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQuer
yResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Pre
paredDataSourceQuery.java:178)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(Prepared
OdaDSQuery.java:145)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Pre
paredDataSourceQuery.java:159)
        at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.popula
tePreparedQuery(PreparedJointDataSourceQuery.java:555)
        at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.popula
tePreparedQuery(PreparedJointDataSourceQuery.java:504)
        at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery.access
$2(PreparedJointDataSourceQuery.java:490)
        at org.eclipse.birt.data.engine.impl.PreparedJointDataSourceQuery$JointD
ataSetQueryExecutor.createOdiQuery(PreparedJointDataSourceQuery.java:587)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Quer
yExecutor.java:325)
        at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQue
ry.java:455)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQuer
yResults(PreparedDataSourceQuery.java:190)
        at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Pre
paredDataSourceQuery.java:178)
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec
ute(DataRequestSessionImpl.java:624)
        ... 66 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get
 the type for parameter: 1.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get parameter ty
pe.
SQL error #1:Unsupported feature
 ;
    java.sql.SQLException: Unsupported feature
        at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newExceptio
n(ExceptionHandler.java:55)
        at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwExcept
ion(ExceptionHandler.java:108)
        at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwExcept
ion(ExceptionHandler.java:96)
        at org.eclipse.birt.data.engine.odaconsumer.ParameterMetaData.getRuntime
ParameterType(ParameterMetaData.java:237)
        at org.eclipse.birt.data.engine.odaconsumer.ParameterMetaData.<init>(Par
ameterMetaData.java:97)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.mergeParam
HintsWithMetaData(PreparedStatement.java:1674)
        at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getParamet
erMetaData(PreparedStatement.java:1525)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.setInputParamet
erBinding(DataSourceQuery.java:1103)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.addParameterDef
ns(DataSourceQuery.java:574)
        at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSou
rceQuery.java:290)
        at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecut
or.prepareOdiQuery(PreparedOdaDSQuery.java:442)
        at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(Quer
yExecutor.java:341)
        ... 80 more
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get param
eter type.
SQL error #1:Unsupported feature
 ;
    java.sql.SQLException: Unsupported feature
        at org.eclipse.birt.report.data.oda.jdbc.ParameterMetaData.getParameterT
ype(ParameterMetaData.java:161)
        at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaParameterMe
taData.getParameterType(OdaParameterMetaData.java:177)
        at org.eclipse.birt.data.engine.odaconsumer.ParameterMetaData.getRuntime
ParameterType(ParameterMetaData.java:233)
        ... 88 more
Caused by: java.sql.SQLException: Unsupported feature
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:208)
        at oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(
DatabaseError.java:499)
        at oracle.jdbc.driver.OracleParameterMetaData.getParameterType(OraclePar
ameterMetaData.java:157)
        at org.eclipse.birt.report.data.oda.jdbc.ParameterMetaData.getParameterT
ype(ParameterMetaData.java:155)
        ... 90 more
[11:59:19] DEBUG net.sourceforge.stripes.controller.ExecutionContext  - Transiti
oning to lifecycle stage ResolutionExecution
[11:59:19] DEBUG net.sourceforge.stripes.controller.HttpCacheInterceptor  - Look
ing for HttpCache on sb.ops.it.ecm.cqm.web.action.mis.MISActionBean.getUserScore
CardHTML()
[11:59:19] DEBUG net.sourceforge.stripes.controller.HttpCacheInterceptor  - Foun
d HttpCache for sb.ops.it.ecm.cqm.web.action.mis.MISActionBean.getUserScoreCardH
TML()
[11:59:19] DEBUG net.sourceforge.stripes.controller.HttpCacheInterceptor  - Disa
bling client-side caching for response
[11:59:19] DEBUG net.sourceforge.stripes.controller.ExecutionContext  - Transiti
oning to lifecycle stage RequestComplete