Is your system set up to not accept unqualified searches? What I do is use 'Request ID' != $NULL$
That works for us and we have our system set up to no accept unqualified searches. Plus, does this report run for you in BIRT Designer without any problems? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hristo Ninov Sent: Thursday, March 06, 2014 5:51 AM To: [email protected] Subject: Scheduled Web(Birt) Report throws exceptions for unqualifed search Hello, Have someone experienced issue like this: - Web (Birt) report (there is qual in it - 1=1, seen using Eclipse). - Schedule that report to send email with excel attachment. - Received email consists only of java exceptions lines. - Same lines appear in arjavaplugin-stderr-[DATE]: ---------------------------------------------------------------------------------------------------------------------------------------------- org.eclipse.birt.data.engine.odaconsumer.PreparedStatement execute SEVER: Cannot execute statement. org.eclipse.datatools.connectivity.oda.OdaException ; ERROR (361): An unqualified search was issues and the server has been configured to disallow unqualified searches. You must specify some search criteria to perform a search on this form; ...... 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) -------------------------------- Running manually this report is ok - so I guess issue lies in schedule qualification. I manually set it but this did not resolved the issue. Any similar experiences or ideas are welcome. Regards, Hristo _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"
