Home
Analytics
Date parameters
bren1519
New user here and I've followed the tutorial on adding a user prompt to the report and managed to get there eventually. What I actually want is to have a between two dates prompt. I can get the single prompt on the attendance date but can't figure out how to make it prompt using a "between" expression.
thx
Brenda
Find more posts tagged with
Comments
mwilliams
Hi Brenda,
So, you want to have a query like, 'select * from blah where date between ? and ?' and have the user be prompted for the two dates? If so, you just need to write your query like above, create two report parameters, one for each date and link them to the dataSet parameters that were created when you added the two '?'s to the query.
Hope this helps. Let me know if you have questions.
bren1519
Brilliant! Thx very much, it's all working now.
Regards,
Brenda
mwilliams
Brenda,
Not a problem. Always glad to help! Let us know whenever you have questions!
krsnow
I know this post is a few months old but I have a follow up question.
What if I want a conditional select statement that includes the date parameters? How do I use the between params inside a subset?
Example of my statement:
select m.item, i.itemnum, i.description, m.actualdate, m.storeloc,
(select sum(a) from m where m.itemnum = i.itemnum and m.storeloc is null and m.actualdate between ? and ?) as count_blahblah,
I need the ? to be the parameters I'm binding later in the full where statement.
Also, what is the point to having to use MXReportSqlFormat.getStartDayTimestampFuction(params["startdate"]) in the "where" clause to get BIRT to recognize the date/time format?
mwilliams
I'm not sure I'm understanding your question completely. You want to use the same parameters you're using in your select statement above in the where statement later as well? Or something else? Please let me know.
krsnow
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72212" data-time="1294868379" data-date="12 January 2011 - 02:39 PM"><p>
I'm not sure I'm understanding your question completely. You want to use the same parameters you're using in your select statement above in the where statement later as well? Or something else? Please let me know.<br /></p></blockquote>
<br />
First, thanks for responding!<br />
<br />
Here is my sql:<br />
<br />
"SELECT m.itemnum, i.description, m.storeloc, m.actualdate,"<br />
+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue,"<br />
+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue"<br />
+ " FROM matusetrans m "<br />
+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum"<br />
+ " WHERE" <br />
+ " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"])"<br />
+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"])" <br />
+ " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate"<br />
;<br />
<br />
<br />
I keep getting errors on preview so I want to make sure I'm using the parameter inserts correctly.
mwilliams
You're building this in your beforeOpen or in the property binding for the dataSet? What is the error that you're getting?
krsnow
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="72218" data-time="1294870477" data-date="12 January 2011 - 03:14 PM"><p>
You're building this in your beforeOpen or in the property binding for the dataSet? What is the error that you're getting?<br /></p></blockquote>
<br />
I'm building this in the Open Method. The params are unbound to my knowledge since they are user input only.<br />
<br />
The error I'm getting is(I posted the whole error):<br />
<br />
The following items have errors: <br />
<br />
<br />
Table (id = 7): <br />
+ There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());<br />
maximoDataSet.open();<br />
<br />
var sqlText = new String();<br />
<br />
// Add query to sqlText variable.<br />
sqlText = "SELECT m.itemnum, i.description, m.storeloc, m.actualdate, "<br />
+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue, "<br />
+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue "<br />
+ " FROM matusetrans m "<br />
+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum "<br />
+ " WHERE " <br />
+ " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]) "<br />
+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]) " <br />
+ " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate "<br />
;<br />
<br />
maximoDataSet.setQuery(sqlText);". <br />
Error.ScriptEvaluationError ( 1 time(s) )<br />
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();// Add query to sqlText variable.sqlText = "SELECT m.itemnum, i.description, m.storeloc, m.actualdate, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue "+ " FROM matusetrans m "+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum "+ " WHERE " + " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]) "+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]) " + " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate ";maximoDataSet.setQuery(sqlText);". at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:76) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:159) at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleOpen(ScriptDataSetScriptExecutor.java:66) at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.open(ScriptDataSetRuntime.java:68) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.open(PreparedScriptDSQuery.java:234) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:210) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:743) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:183) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:148) at org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:85) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:120) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:210) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1641) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:62) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:73) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:35) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(HTMLPageLM.java:123) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:81) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:85) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:205) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:142) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source)Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: unterminated string literal (DataSet[dataSet].__bm_OPEN#14) Script source: DataSet[dataSet].__bm_OPEN, line: 1, text:function __bm_OPEN() {maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();// Add query to sqlText variable.sqlText = "SELECT m.itemnum, i.description, m.storeloc, m.actualdate, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue "+ " FROM matusetrans m "+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum "+ " WHERE " + " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]) "+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]) " + " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate ";maximoDataSet.setQuery(sqlText);} . See next exception for more information.Error evaluating Javascript expression. Script engine error: unterminated string literal (DataSet[dataSet].__bm_OPEN#14) Script source: DataSet[dataSet].__bm_OPEN, line: 1, text:function __bm_OPEN() {maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();// Add query to sqlText variable.sqlText = "SELECT m.itemnum, i.description, m.storeloc, m.actualdate, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue "+ " FROM matusetrans m "+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum "+ " WHERE " + " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]) "+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]) " + " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate ";maximoDataSet.setQuery(sqlText);} at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118) at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:552) at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:74) at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71) ... 63 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: unterminated string literal (DataSet[dataSet].__bm_OPEN#14) Script source: DataSet[dataSet].__bm_OPEN, line: 1, text:function __bm_OPEN() {maximoDataSet = MXReportDataSetProvider.create(this.getDataSource().getName(), this.getName());maximoDataSet.open();var sqlText = new String();// Add query to sqlText variable.sqlText = "SELECT m.itemnum, i.description, m.storeloc, m.actualdate, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_directissue, "+ " (SELECT SUM(m.quantity) FROM matusetrans m WHERE i.itemnum = m.itemnum AND m.storeloc IS NOT NULL AND m.actualdate BETWEEN '"+ params["startdate"] +"' and '"+ params["enddate"] +"')AS count_storeissue "+ " FROM matusetrans m "+ " LEFT OUTER JOIN item i ON m.itemnum = i.itemnum "+ " WHERE " + " and m.actualdate >= " + MXReportSqlFormat.getStartDayTimestampFunction(params["startdate"]) "+ " and m.actualdate <= " + MXReportSqlFormat.getEndDayTimestampFunction(params["enddate"]) " + " Group by m.itemnum, i.itemnum, i.description, m.storeloc, m.actualdate ";maximoDataSet.setQuery(sqlText);} at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:281) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:105) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:137) at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:548) ... 65 moreCaused by: org.mozilla.javascript.EvaluatorException: unterminated string literal (DataSet[dataSet].__bm_OPEN#14) at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:95) at org.mozilla.javascript.DefaultErrorReporter.error(DefaultErrorReporter.java:82) at org.mozilla.javascript.Parser.addError(Parser.java:120) at org.mozilla.javascript.TokenStream.getToken(TokenStream.java:514) at org.mozilla.javascript.Parser.peekToken(Parser.java:138) at org.mozilla.javascript.Parser.memberExprTail(Parser.java:1648) at org.mozilla.javascript.Parser.memberExpr(Parser.java:1640) at org.mozilla.javascript.Parser.unaryExpr(Parser.java:1500) at org.mozilla.javascript.Parser.mulExpr(Parser.java:1429) at org.mozilla.javascript.Parser.addExpr(Parser.java:1417) at org.mozilla.javascript.Parser.shiftExpr(Parser.java:1390) at org.mozilla.javascript.Parser.relExpr(Parser.java:1364) at org.mozilla.javascript.Parser.eqExpr(Parser.java:1320) at org.mozilla.javascript.Parser.bitAndExpr(Parser.java:1309) at org.mozilla.javascript.Parser.bitXorExpr(Parser.java:1298) at org.mozilla.javascript.Parser.bitOrExpr(Parser.java:1287) at org.mozilla.javascript.Parser.andExpr(Parser.java:1275) at org.mozilla.javascript.Parser.orExpr(Parser.java:1263) at org.mozilla.javascript.Parser.condExpr(Parser.java:1246) at org.mozilla.javascript.Parser.assignExpr(Parser.java:1228) at org.mozilla.javascript.Parser.assignExpr(Parser.java:1234) at org.mozilla.javascript.Parser.expr(Parser.java:1217) at org.mozilla.javascript.Parser.statementHelper(Parser.java:1104) at org.mozilla.javascript.Parser.statement(Parser.java:616) at org.mozilla.javascript.Parser.parseFunctionBody(Parser.java:409) at org.mozilla.javascript.Parser.function(Parser.java:515) at org.mozilla.javascript.Parser.parse(Parser.java:342) at org.mozilla.javascript.Parser.parse(Parser.java:287) at org.mozilla.javascript.Context.compileImpl(Context.java:2349) at org.mozilla.javascript.Context.compileString(Context.java:1372) at org.mozilla.javascript.Context.compileString(Context.java:1361) at org.eclipse.birt.core.script.JavascriptEvalUtil.getCompiledScript(JavascriptEvalUtil.java:155) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:94) ... 67 more<br />
+ There are errors evaluating script "if (!maximoDataSet.fetch())<br />
return (false);<br />
<br />
// Add a line for each output column<br />
// The specific get method should match the data type of the output column.<br />
row["itemnum"] = maximoDataSet.getString("itemnum");<br />
row["storeloc"] = maximoDataSet.getString("storeloc");<br />
row["actualdate"] = maximoDataSet.getTimestamp("actualdate");<br />
row["description"] = maximoDataSet.getString("description");<br />
row["count_directissue"] = maximoDataSet.getInteger("count_directissue");<br />
row["count_storeissue"] = maximoDataSet.getInteger("count_storeissue"); <br />
<br />
return (true);". <br />
Error.ScriptEvaluationError ( 1 time(s) )<br />
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (!maximoDataSet.fetch()) return (false);// Add a line for each output column// The specific get method should match the data type of the output column.row["itemnum"] = maximoDataSet.getString("itemnum");row["storeloc"] = maximoDataSet.getString("storeloc");row["actualdate"] = maximoDataSet.getTimestamp("actualdate");row["description"] = maximoDataSet.getString("description");row["count_directissue"] = maximoDataSet.getInteger("count_directissue");row["count_storeissue"] = maximoDataSet.getInteger("count_storeissue"); return (true);". at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:76) at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:159) at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:100) at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:84) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:247) at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:148) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:91) at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:62) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:275) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:250) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:213) at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:66) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:66) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:123) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:83) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:65) at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:210) at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:124) at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:106) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:213) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:743) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:183) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:148) at org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:85) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:120) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:210) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1641) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:62) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:73) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:35) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(HTMLPageLM.java:123) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:81) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:85) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:205) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:142) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source)Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred: Error evaluating Javascript expression. Script engine error: ReferenceError: "maximoDataSet" is not defined. (DataSet[dataSet].__bm_FETCH#2) Script source: DataSet[dataSet].__bm_FETCH, line: 1, text:__bm_FETCH(). See next exception for more information.Error evaluating Javascript expression. Script engine error: ReferenceError: "maximoDataSet" is not defined. (DataSet[dataSet].__bm_FETCH#2) Script source: DataSet[dataSet].__bm_FETCH, line: 1, text:__bm_FETCH() at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:118) at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:552) at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:79) at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:71) ... 78 moreCaused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "maximoDataSet" is not defined. (DataSet[dataSet].__bm_FETCH#2) Script source: DataSet[dataSet].__bm_FETCH, line: 1, text:__bm_FETCH() at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:281) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:105) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:137) at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:548) ... 80 moreCaused by: org.mozilla.javascript.EcmaError: ReferenceError: "maximoDataSet" is not defined. (DataSet[dataSet].__bm_FETCH#2) at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3240) at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3230) at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3303) at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1632) at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1571) at org.mozilla.javascript.gen.c186._c1(DataSet[dataSet].__bm_FETCH:2) at org.mozilla.javascript.gen.c186.call(DataSet[dataSet].__bm_FETCH) at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:105) at org.mozilla.javascript.gen.c12._c0(DataSet[dataSet].__bm_FETCH:1) at org.mozilla.javascript.gen.c12.call(DataSet[dataSet].__bm_FETCH) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:304) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2769) at org.mozilla.javascript.gen.c12.call(DataSet[dataSet].__bm_FETCH) at org.mozilla.javascript.gen.c12.exec(DataSet[dataSet].__bm_FETCH) at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:98) ... 82 more<br />
+ Unhandled exception when executing script <br />
Error.UnhandledScriptError ( 1 time(s) )<br />
detail : org.eclipse.birt.report.engine.api.EngineException: Unhandled exception when executing script at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:149) at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:139) at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:119) at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:84) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:247) at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:148) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:91) at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:62) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:275) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:250) at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:213) at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:66) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:111) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:66) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:123) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:83) at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:65) at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:210) at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:124) at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:106) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:213) at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:743) at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:183) at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:148) at org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:85) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:120) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:210) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1641) at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:62) at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:73) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:35) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layoutChildren(HTMLPageLM.java:123) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:81) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:85) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:205) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:142) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source) at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source) at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source) at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source) at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:740) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(EclipseErrorReportValve.java:153) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683) at java.lang.Thread.run(Unknown Source)Caused by: org.eclipse.birt.data.engine.core.DataException: data.engine.BadFetchScriptReturnType at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:109) ... 76 more
mwilliams
It looks like it might be a syntax error in your code. It's caused by an unterminated string, it says. You might double check that all your quotes are correct and that the correct sections of your query string you build are highlighted as strings in your script.