Problem execute Pentaho Report from xation

[dgonzalez]

Hi,

I have a report, only "hello world", that i can execute in local and bi-server.
I have other xactions with "data from relational", "parameters", etc., that work perfectly in bi-server.
My problem is when i try to call a report from xaction, I get the following error:

2012-07-03 13:16:51,652 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 96abd178-c500-11e1-aa6d-fba8163e1eb2:SOLUTION-ENGINE:hello_report.xaction: Action Sequence execution failed, see details below
| Error Time: martes 3 de julio de 2012 13H16' CEST
| Session ID: joe
| Instance Id: 96abd178-c500-11e1-aa6d-fba8163e1eb2
| Action Sequence: hello_report.xaction
| Execution Stack:
EXECUTING ACTION: test (SimpleReportingComponent)
| Action Class: SimpleReportingComponent
| Action Desc: test
| Loop Index (1-based): 0
Stack Tracerg.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - [es_18] Activity failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1315)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.web.servlet.ViewAction.handleActionRequest(ViewAction.java:167)
at org.pentaho.platform.web.servlet.ViewAction.doGet(ViewAction.java:316)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
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 org.pentaho.platform.web.http.filters.PentahoWebContextFilter.doFilter(PentahoWebContextFilter.java:102)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.PentahoRequestContextFilter.doFilter(PentahoRequestContextFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.pentaho.platform.web.http.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:134)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.wrapper.SecurityContextHolderAwareRequestFilter.doFilterHttp(SecurityContextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SystemStatusFilter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.pentaho.platform.web.http.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:113)
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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:680)
Caused by: java.lang.NullPointerException
at org.pentaho.platform.engine.services.solution.PojoComponent.executeAction(PojoComponent.java:429)
at org.pentaho.platform.engine.services.solution.ComponentBase.execute(ComponentBase.java:463)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1296)
... 73 more

I have the latest version of the suite and bi-server. I tried to put the input resource url, file, solution-file, with the published report... can you help me please?
Thanks!!!

[dgonzalez]

Anybody?, so, Can somebody give me a working example of xaction that calls a report. i will try to execute it in my server to see the diferences.

[Javier_MX]

I would set the parameters in the report and publish directly into the BI server.
Avoid the xaction files, they will be deprecated.
Or check PDS: http://wiki.pentaho.com/download/attachments/11862386/creating_action_sequences.pdf

[Taqua]

It looks as if your output declaration is wrong. You do not tell the system *where* you want to put the output. Have a look at the bi-developers-samples that ship with the platform for a bunch of examples.

Under "reporting/unified-file-format" you will find some examples that use the prpt reporting system.

But in general, I would stick to the advice given by Javier: "Avoid the xactions" unless there is a task that absolutely requires them (like bursting). There is no need to use xactions if you just want to run a report.

[dgonzalez]

Thanks a lot, I found the error, I selected "outputReport" in the output and I should've selected "content". I don't understand why this kind of errors won't show a "little more" clearly on logs.


So, I need to use xaction because I need to get custom parameters, execute jobs, execute some queries, and then show a report. Will xaction be deprecated?? so, what should I use if the report isn't enough??

[camposer]

About this...

I was like 3 hours literally fighting against xactions... At the end, the problem was described in the PDF attached by Javier_MX, you just need to read it carefully... Anatomy of and Action Sequence -> Output Types.

Here is my xaction (the "problematic part bolded). Is a simple example with 3 parameters, calling a PRPT file and printing its output directly in the browser. I hope to write more about this in my blog.

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
<title>%title</title>
<version>1</version>
<logging-level>DEBUG</logging-level>
<documentation>
<author>camposer</author>
<description>%description</description>
<help>%help</help>
<result-type/>
<icon/>
</documentation>


<inputs>
<param_date_since type="string">
<sources>
<request>param_date_since</request>
</sources>
<default-value><![CDATA[2012-07-01]]></default-value>
</param_date_since>
<param_date_until type="string">
<sources>
<request>param_date_until</request>
</sources>
<default-value><![CDATA[2012-07-10]]></default-value>
</param_date_until>
<param_channel type="string">
<sources>
<request>param_channel</request>
</sources>
<default-value><![CDATA[1]]></default-value>
</param_channel>
</inputs>


<outputs>
<reportOutput type="content" is-output-parameter="true">
<destinations>
<response>content</response>
</destinations>
</reportOutput>
</outputs>


<resources>
<report-definition>
<solution-file>
<location>MainUsers.prpt</location>
<mime-type>application/zip</mime-type>
</solution-file>
</report-definition>
</resources>

<actions>
<action-definition>
<component-name>SecureFilterComponent</component-name>
<action-type>Prompt/Secure Filter</action-type>
<action-inputs>
<param_date_since type="date"/>
<param_date_until type="date"/>
<param_channel type="string"/>
</action-inputs>
<component-definition>
<selections>
<param_date_since filter="none" style="text-box">
<title>param_date_since</title>
</param_date_since>
<param_date_until filter="none" style="text-box"/>
<param_channel filter="none">
<title>param_channel</title>
</param_channel>
</selections>
</component-definition>
</action-definition>

<action-definition>
<component-name>SimpleReportingComponent</component-name>
<action-type>MainUsers</action-type>
<action-inputs>
<param_date_since type="date"/>
<param_date_until type="date"/>
<param_channel type="string"/>
</action-inputs>
<action-resources>
<report-definition type="resource"/>
</action-resources>
<action-outputs>
<outputstream type="content" mapping="reportOutput"/>
</action-outputs>
<component-definition>
<useContentRepository><![CDATA[true]]></useContentRepository>
<outputType><![CDATA[application/pdf]]></outputType>
<paginate><![CDATA[false]]></paginate>
</component-definition>
</action-definition>

</actions>
</action-sequence>