[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 
Problem with invisible Analytical Driver  XML
Forum Index » Technical Help - SpagoBI Server - REPORTING
Author Message
zsoltputnoky.spw

SpagoBI friend

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

Hello Forum,

I have an issue with the Analytical Driver when it is assigned to a document and set invisible:

Here is the scenario:

- Each user has an attribute called userid
- Created a LOV which is supposed to give back this value, it is a JavaScript with the following command returnValue('${userid}')
- Created an Analytical Driver which is using this LOV
- Created a BIRT report, which has a parameter in the query, something like ....where resource_short_name=?
- This dataset has a parameter, called param1, which is then assigned to a report parameter, called userid
- The report should print the resource name which is associated to the userid
- Deployed the document and assigned my analytical driver

Scenario 1:

- when the report is executed, SpagoBI is displays a little screen from which I can select the userid assigned to the currently logged in user. So far it is okay. But when I execute the report with this information, it does not print the resource name, but only the parameter given --> it is working properly in BIRT

Scenario 2:

- when I set the Analytical Driver to non visible (when it is assigned to the document), nothing is printed when the report is executed, but the usual error message appears:

org.eclipse.birt.report.engine.api.impl.ParameterValidationException: Required parameter userid is not set.
at org.eclipse.birt.report.engine.api.impl.EngineTask.validateAbstractScalarParameter(EngineTask.java:770)
at org.eclipse.birt.report.engine.api.impl.EngineTask.access$0(EngineTask.java:756)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterValidationVisitor.visitScalarParameter(EngineTask.java:686)
at org.eclipse.birt.report.engine.api.impl.EngineTask$ParameterVisitor.visit(EngineTask.java:1400)
at org.eclipse.birt.report.engine.api.impl.EngineTask.doValidateParameters(EngineTask.java:670)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:94)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at it.eng.spagobi.engines.birt.BirtReportServlet.runReport(BirtReportServlet.java:690)
at it.eng.spagobi.engines.birt.BirtReportServlet.service(BirtReportServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
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:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:722)

I am running SpagoBI 3.6 All-in-One on a Win7 64bit Pro OS, with Java 1.7.0_09

I experienced the same issue when try to link two reports together.

Thanks for helping out,

Zsolt
zsoltputnoky.spw

SpagoBI friend

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

Dear All,

Issue solved - Set the Analytical Driver Use Mode Details --> set this to ComboBox Values Selection and the hidden Analytical Driver works!!!!

Whooooooaaaaa, two days :)

Cheers,

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