Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Getting exception in report as Outer Query result does not exist. How to handle this exception?
Migrateduser
<p>Hi,</p><p> </p><p>I have developed one report. Let me explain you structure of my report. List is containing two tables .List and both the tables are having different data binding. Taking value from List and using that value in filter in these</p><p>two tables. </p><p> </p><p>Now the issue is , I am getting below exception whenever there are no records in dataset for given parameters.</p><p> </p><p>Exception :</p><p> </p><div>org.mozilla.javascript.EvaluatorException: The outer query results does not exist. This might be caused by a "_outer" reference in a query without parent query. (unnamed script#10198)</div><div>at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)</div><div>at org.mozilla.javascript.Context.reportRuntimeError(Context.java:938)</div><div>at org.mozilla.javascript.Context.reportRuntimeError(Context.java:994)</div><div>at org.eclipse.birt.data.engine.script.JSResultSetRow.get(JSResultSetRow.java:121)</div><div>at org.mozilla.javascript.ScriptableObject.getProperty(ScriptableObject.java:1617)</div><div>at org.mozilla.javascript.ScriptRuntime.getObjectProp(ScriptRuntime.java:1437)</div><div>at org.mozilla.javascript.ScriptRuntime.getObjectProp(ScriptRuntime.java:1423)</div><div>at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3027)</div><div>at script(unnamed script:10198)</div><div>at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2487)</div><div>at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)</div><div>at org.mozilla.javascript.SecurityController$1.exec(SecurityController.java:193)</div><div>at org.eclipse.birt.report.engine.javascript.ScriptUtil$1.execWithDomain(ScriptUtil.java:59)</div><div>at org.mozilla.javascript.SecurityController.callWithDomain(SecurityController.java:189)</div><div>at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2474)</div><div>at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)</div><div>at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)</div><div>at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)</div><div>at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:175)</div><div>at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)</div><div>at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)</div><div>at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1001)</div><div>at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.doEvaluateRawExpression(ExprEvaluateUtil.java:281)</div><div>at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.doEvaluateRawExpression(ExprEvaluateUtil.java:405)</div><div>at org.eclipse.birt.data.engine.expression.ExprEvaluateUtil.evaluateConditionExpression(ExprEvaluateUtil.java:513)</div><div>at org.eclipse.birt.data.engine.impl.FilterByRow$FilterByRowHelper.process(FilterByRow.java:341)</div><div>at org.eclipse.birt.data.engine.impl.FilterByRow.process(FilterByRow.java:211)</div><div>at org.eclipse.birt.data.engine.executor.cache.RowResultSet.processFetchEvent(RowResultSet.java:160)</div><div>at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:121)</div><div>at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:91)</div><div>at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)</div><div>at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:316)</div><div>at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)</div><div>at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)</div><div>at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:73)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:153)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.doFiltering(FilterCalculator.java:116)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.applyFilters(FilterCalculator.java:89)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.FilterCalculator.applyFilters(FilterCalculator.java:63)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.RowProcessUtil.applyFilters(RowProcessUtil.java:177)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.doRowFiltering(ResultSetProcessUtil.java:333)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.populateResultSet(ResultSetProcessUtil.java:102)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.ResultSetProcessUtil.doPopulate(ResultSetProcessUtil.java:85)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareQueryResultSet(PassManager.java:108)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:126)</div><div>at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</div><div>at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:198)</div><div>at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:171)</div><div>at org.eclipse.birt.data.engine.executor.dscache.DataSourceQuery.execute(DataSourceQuery.java:201)</div><div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441)</div><div>at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1495)</div><div>at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)</div><div>at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)</div><div>at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:115)</div><div>at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:176)</div><div>at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)</div><div>at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)</div><div>at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1905)</div><div>at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</div><div>at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</div><div>at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</div><div>at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</div><div>at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</div><div>at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</div><div>at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:441)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.traverse(HTMLAbstractLM.java:442)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.handleVisibility(HTMLAbstractLM.java:374)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:123)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:70)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</div><div>at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</div><div>at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)</div><div>at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)</div><div>at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:111)</div><div>at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReportDocument(ReportLauncher.java:626)</div><div>at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:549)</div><div>at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:455)</div><div>at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:104)</div><div>at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)</div><div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div><div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)</div><div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)</div><div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)</div><div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)</div><div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div><div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div><div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div>at java.lang.reflect.Method.invoke(Method.java:597)</div><div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)</div><div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)</div><div>at org.eclipse.equinox.launcher.Main.run(Main.java:1408)</div><div>at org.eclipse.equinox.launcher.Main.main(Main.java:1384)</div><div> </div><div>How can I handle this exception ?</div><div> </div><div>Any help would be appreciated!! Thanks in Advance !!</div>
Find more posts tagged with
Comments
There are no comments yet