Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Problem with Scheduling Report using Add Job Component

  1. #1
    Join Date
    Dec 2010
    Posts
    6

    Exclamation Problem with Scheduling Report using Add Job Component

    Hi,
    I have created an xaction "Scheduling_Test.xaction" which has the Steelwheels Income Statement prpt in it. When I execute the xaction it works fine and sends email.
    I had scheduled this "Scheduling_Test.xaction" xaction using Admin Console even that worked well!
    Now i want to try scheduling the same report using Add Job Component.
    I have called the "Scheduling_Test.xaction" in the Main.xaction. When i run this xaction i get the message "Job Scheduled -- Check Scheduler Administrator to verify status." and in the Admin console it reflects the newly created schedule by the Main.xaction. It had executed once and even had sent mail. But the next time it threw errors. I tried again a couple of times but getting the same error. I had made no changes to the file. I am confused, if it worked the first time then why afterward it started to throw errors??
    Any help would be appreciated.
    Regards

    Following is the error:

    15:54:00,187 ERROR [Logger]
    misc-org.pentaho.platform.engine.core.system.PentahoSystem:PentahoSystem.
    ERROR_0029 - Output handler type not specified in reference: myOutput
    15:54:00,234 ERROR [SolutionEngine] 56229134-53a5-11e0-ad1a-59cd08d499
    54:SOLUTION-ENGINE:Scheduling_Test.xaction: Action Sequence execution
    failed, see details below
    | Error Time: Monday, March 21, 2011 3:54:00 PM IST
    | Session ID: joe
    | Instance Id: 56229134-53a5-11e0-ad1a-59cd08d49954
    | Action Sequence: Scheduling_Test.xaction
    | Execution Stack:
    EXECUTING ACTION: Pentaho Report (SimpleReportingComponent)
    | Action Class: SimpleReportingComponent
    | Action Desc: Pentaho Report
    | Loop Index (1-based): 0
    Stack Tracerg.pentaho.platform.api.engine.ActionExecutionException:
    RuntimeContext.ERROR_0017 - Action failed to execute
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .executeComponent(RuntimeContext.java:1306)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .executeAction(RuntimeContext.java:1260)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .performActions(RuntimeContext.java:1159)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .executeLoop(RuntimeContext.java:1103)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .executeSequence(RuntimeContext.java:985)
    at org.pentaho.platform.engine.services.runtime.RuntimeContext
    .executeSequence(RuntimeContext.java:895)
    at org.pentaho.platform.engine.services.solution.SolutionEngin
    e.executeInternal(SolutionEngine.java:399)
    at org.pentaho.platform.engine.services.solution.SolutionEngin
    e.execute(SolutionEngine.java:317)
    at org.pentaho.platform.engine.services.solution.SolutionEngin
    e.execute(SolutionEngine.java:193)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcc
    essorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingM
    ethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.pentaho.platform.web.http.context.a.invoke(SourceFile:1
    89)
    at $Proxy10.execute(Unknown Source)
    at org.pentaho.platform.engine.services.BaseRequestHandler.han
    dleActionRequest(BaseRequestHandler.java:159)
    at org.pentaho.platform.scheduler.QuartzExecute.execute(Quartz
    Execute.java:198)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleTh
    readPool.java:520)
    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:1291)
    ... 18 more

    Below is the xml of the Main.xaction:

    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence>
    <title>Main</title>
    <version>1</version>
    <logging-level>ERROR</logging-level>
    <documentation>
    <author/>
    <description>Scheduling with the Add Job component.</description>
    <help/>
    <result-type/>
    <icon/>
    </documentation>

    <inputs/>

    <outputs/>

    <resources/>

    <component-name>org.pentaho.component.JobSchedulerComponent</component-name>
    <actions>
    <action-definition>
    <component-name>JobSchedulerComponent</component-name>
    <action-type>Scheduling_test</action-type>
    <action-inputs/>
    <component-definition>
    <jobAction>startJob</jobAction>
    <solution><![CDATA[MY_FILE]]></solution>
    <path><![CDATA[Scheduling]]></path>
    <action><![CDATA[Scheduling_Test.xaction]]></action>
    <jobName><![CDATA[Schedule_Job3]]></jobName>
    <triggerName><![CDATA[Schedule_Trigger1]]></triggerName>
    <cronString><![CDATA[0 54 15 ? * *]]></cronString>
    <triggerType><![CDATA[cron]]></triggerType>
    </component-definition>
    </action-definition>

    </actions>
    </action-sequence>
    Last edited by Aukenus; 03-21-2011 at 06:55 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.