JI1.1 Input Control -->Single Select Query

[alauddinctgbd]

Hi,

 

I am successfully connect with oracle 10g using JI1.1.0.

 

But when i want to use Single Select Query as Input Control type the following error comes when try to run that report.......

 

Error Message:

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14c72c8 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@3b678, attributes = map[[empty]]] in state 'checkForParams' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: No query executer factory class registered for null queries. Create a propery named net.sf.jasperreports.query.executer.factory.null.

 

Error Trace:

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14c72c8 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@3b678, attributes = map[[empty]]] in state 'checkForParams' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: No query executer factory class registered for null queries. Create a propery named net.sf.jasperreports.query.executer.factory.null.

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@14c72c8 targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@3b678, attributes = map[[empty]]] in state 'checkForParams' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: No query executer factory class registered for null queries. Create a propery named net.sf.jasperreports.query.executer.factory.null.

com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: No query executer factory class registered for null queries. Create a propery named net.sf.jasperreports.query.executer.factory.null. at net.sf.jasperreports.engine.util.JRQueryExecuterUtils.getQueryExecuterFactory(JRQueryExecuterUtils.java:56)

at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRQueryExecuterAdapter.executeQuery(JRQueryExecuterAdapter.java:68)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:788)

at com.jaspersoft.jasperserver.war.action.ReportParametersAction.executeQuery(ReportParametersAction.java:264)

at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:244)

at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123)

at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:91)

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.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231)

at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:141)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:67)

at org.springframework.webflow.AnnotatedAction.execute(AnnotatedAction.java:208)

at org.springframework.webflow.ActionExecutor.execute(ActionExecutor.java:54)

at org.springframework.webflow.ActionState.doEnter(ActionState.java:184)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Flow.start(Flow.java:531)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.start(FlowExecutionControlContextImpl.java:187)

at org.springframework.webflow.SubflowState.doEnter(SubflowState.java:131)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Transition.execute(Transition.java:224)

at org.springframework.webflow.TransitionableState.onEvent(TransitionableState.java:105)

at org.springframework.webflow.Flow.onEvent(Flow.java:545)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.signalEvent(FlowExecutionControlContextImpl.java:199)

at org.springframework.webflow.execution.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:239)

at org.springframework.webflow.executor.FlowExecutorImpl.signalEvent(FlowExecutorImpl.java:177)

at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:100)

at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:198)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)

at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)

at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)

at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationP

[swood]

Looks like no language for the query was set. Can you enter "SQL" and try again?

 

I just saw that the validation on the query entry screen does not check this.

 

 

 

Sherman

JasperSoft