[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Implementing Multiple Value Parameter in SpagoBI 4.0 with BIRT  XML
Forum Index » Technical Help - SpagoBI Server - REPORTING
Author Message
zsoltputnoky.spw

SpagoBI friend

Joined: 03/12/2012 16:13:48
Messages: 94
Offline

Dear All,

I try to build a simple report which has two parameters. The user should be able to select the parameter from a combo-box. Parameters are string type.

My query looks like this: select * from table where id IN (?)

I created an LOV with fixed values, connected it to an Analytical Driver and then to the document. When I execute the document, I receive the following message:

it.eng.spagobi.commons.utilities.SpagoBIServiceExceptionHandler.logError: The error full stack trace is:
it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: Cannot evaluate errors on parameters validation
at it.eng.spagobi.commons.utilities.SpagoBIServiceExceptionHandler.getWrappedException(SpagoBIServiceExceptionHandler.java:85)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.handleException(AbstractSpagoBIAction.java:163)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(AbstractSpagoBIAction.java:70)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:41
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:109)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:82)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1760)
at java.lang.Thread.run(Thread.java:662)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: Cannot evaluate errors on parameters validation
at it.eng.spagobi.analiticalmodel.execution.service.GetUrlForExecutionAction.handleNormalExecution(GetUrlForExecutionAction.java:337)
at it.eng.spagobi.analiticalmodel.execution.service.GetUrlForExecutionAction.doService(GetUrlForExecutionAction.java:75)
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(AbstractSpagoBIAction.java:6
... 22 more
Caused by: java.lang.NullPointerException
at it.eng.spagobi.analiticalmodel.document.handlers.ExecutionInstance.mergeValuesAndDescriptions(ExecutionInstance.java:817)
at it.eng.spagobi.analiticalmodel.document.handlers.ExecutionInstance.getValidationErrorsOnValues(ExecutionInstance.java:796)
at it.eng.spagobi.analiticalmodel.document.handlers.ExecutionInstance.getParametersErrors(ExecutionInstance.java:625)
at it.eng.spagobi.analiticalmodel.execution.service.GetUrlForExecutionAction.handleNormalExecution(GetUrlForExecutionAction.java:335)
... 24 more


Do any of you managed to make this work?

Thanks alot,

Zsolt

This message was edited 1 time. Last update was at 21/11/2013 17:43:48

 
Forum Index » Technical Help - SpagoBI Server - REPORTING
Go to:   
Powered by JForum 2.1.9 © JForum Team