To answer Todd, Yes I’m only try to do this with a web report Laurent, I looked over the docs and checked out the forms but I’m not sure what data goes into the parameters fields. I was able to get a status email on a immediately published report. I was an error paragraph.
Cannot execute the statement. org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1163) org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1127) org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96) org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62) org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99) org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170) org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75) com.bmc.arsys.plugins.report.RunReport.executeReport(RunReport.java:326) com.bmc.arsys.plugins.report.RunReport.runReport(RunReport.java:563) com.bmc.arsys.plugins.report.PublishReport$1.run(PublishReport.java:200) java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) java.util.concurrent.FutureTask.run(Unknown Source) java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) java.lang.Thread.run(Unknown Source) I was hoping to replace my escalation fired runmacro.exe command line Run Process that creates and emails a .csv file as an attachment. Still investigating why that isn’t working on the new server. I have some more digging to do. Thank you, --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of laurent matheo Sent: Wednesday, July 30, 2014 11:01 AM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: Using the Web Report Scheduler without ITSM installed ** Hi John, I looked at a 8.1 VM with only ARS installed and the Mid-Tier and I can see the "planning" icon, can plan and schedule a web report (using mid-tier). According to the documentation, you kinda can do the same thing using the forms directly: https://docs.bmc.com/docs/display/public/ars8000/About+publishing+and+scheduling+reports Laurent. On 30 Jul, 2014,at 04:27 PM, "Reiser, John J" <john.j.rei...@lmco.com<mailto:john.j.rei...@lmco.com>> wrote: Hello Listers, We have successfully, finally moved to MS SQL 2008 ARS 8.1.00 Windows Server 2008 R2 Standard We are a non-ITSM setup so I think that may be the problem. Is there a configuration setting or Form to enable using the Report publishing and Scheduling. I saw Jason Miller’s write up about allowing non-admin users the capability but I just want to be able to set up a few daily/Weekly reports to get emailed to a few folks. I had a runmacro process to do this in the past but have not been able to get it working on the new system. So, can I use the Web Report Scheduler on a home grown form in a barebones ARServer setup? Thank you, --- John J. Reiser Remedy Developer/Administrator SeniorSoftware Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"