Skip to Content
0
May 09, 2012 at 12:35 AM

Job Chain fails when using query filter as the constraint type for a parameter

23 Views

Hi Everyone,

I have created reports to get the list of jobs with status 'error'. I am able to submit the System_ReportRun and obtain the report in HTML format.

I created a job chain, with System_ReportRun in step 1 and System_MailSend in step 2. Now when i maintain the Report name hardcoded in the job chains, the job is successful and sends me a mail.

But i want to define a parameter, so that i can select the report i want to generate at job submission. So i defined a parameter and used query filter as the constraint type.

Now when i submit, i get the drop down with all the reports available

, but when i select any one of them and submit, the job chain ends up in error with the following log:

-- JOB RUN STACK TRACE --

java.lang.RuntimeException: Unable to find report Report:GLOBAL.PTP_BIWEEKLY_ERROR_REPORT

at com.redwood.scheduler.system.jobs.CreateReportFromReportObject.runInternal(CreateReportFromReportObject.java:227)

at com.redwood.scheduler.system.jobs.CreateReportFromReportObject.run(CreateReportFromReportObject.java:135)

at com.redwood.scheduler.system.jobs.CommonSystemJob.execute(CommonSystemJob.java:53)

at com.redwood.scheduler.systemjobservice.impl.JobWorker.doWork(JobWorker.java:241)

at com.redwood.scheduler.infrastructure.workqueue.Worker.run(Worker.java:64)

at java.lang.Thread.run(Thread.java:579)

can someone please help me solve the error?

Attachments

report1.png (44.1 kB)
report2.png (26.4 kB)
report3.png (12.9 kB)