Parameters Error
<p>Good Afternoon, I use BIRT versión 3.2.22 right now download ACTUATE BIRT PROFESSIONAL with I-Hub F-Type. </p>
<p> </p>
<p>When try to run a report made with BIRT 3.2.22 obtain this error message:</p>
<p> </p>
<p>18004: There is an error processing your request. Error Code: 17070. PARAMETER1= There is an error in processing your request. Error Code: 17070.</p>
<p> </p>
<p>And doesn't run the report.</p>
<p> </p>
<p>Thank you for your help.</p>
<p> </p>
<p>When try to run a report made with BIRT 3.2.22 obtain this error message:</p>
<p> </p>
<p>18004: There is an error processing your request. Error Code: 17070. PARAMETER1= There is an error in processing your request. Error Code: 17070.</p>
<p> </p>
<p>And doesn't run the report.</p>
<p> </p>
<p>Thank you for your help.</p>
0
Comments
-
<p>In your workspace folder there is another folder name .metadata. In there there is a file .log. Delete it, re-start BD Pro, run your report again, then send post the .log file here and we can look at it.</p>
<p> </p>
<p>Thanks.</p>
0 -
<p>Is your parameter dynamically populating based on the contents of your data set?</p>
<p> </p>
<p>I see this error occurring in the log which could be the cause of the issue if your parameter is based on the data set:</p>
<blockquote class="ipsBlockquote">
<p> </p>
<p>!ENTRY com.actuate.birt.report.viewer 2 0 2015-02-23 14:56:04.849</p>
<div>!MESSAGE GetReportParameterTask: class com.actuate.reportapi.enginemanager.JREMException</div>
<div>!STACK 0</div>
<div>com.actuate.reportapi.enginemanager.JREMException: There is an error in processing your request. Error code: 17070.</div>
<div>at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)</div>
<div>at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256)</div>
<div>at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleBeforeOpen(DataSetScriptExecutor.java:107)</div>
<div>at org.eclipse.birt.data.engine.impl.DataSetRuntime.beforeOpen(DataSetRuntime.java:567)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.dataSetBeforeOpen(QueryExecutor.java:217)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:329)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)</div>
<div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)</div>
<div>at org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask.executeQuery(GetParameterDefinitionTask.java:648)</div>
<div>at org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask.getResultSetForParameter(GetParameterDefinitionTask.java:1374)</div>
<div>at org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask.getChoicesFromParameterQuery(GetParameterDefinitionTask.java:1348)</div>
<div>at org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask.doGetSelectionList(GetParameterDefinitionTask.java:521)</div>
<div>at org.eclipse.birt.report.engine.api.impl.GetParameterDefinitionTask.getSelectionList(GetParameterDefinitionTask.java:451)</div>
<div>at com.actuate.reportapi.engine.birt.GetReportParameterTask.addParameter(GetReportParameterTask.java:295)</div>
<div>at com.actuate.reportapi.engine.birt.GetReportParameterTask.doTask(GetReportParameterTask.java:535)</div>
<div>at com.actuate.reportapi.engine.Task.execute(Task.java:325)</div>
<div>at com.actuate.reportservice.ReportServiceLocal.getReportParameters(ReportServiceLocal.java:1752)</div>
<div>at com.actuate.activeportal.actions.AcSubmitJobAction.a(Unknown Source)</div>
<div>at com.actuate.activeportal.actions.AcSubmitJobAction.a(Unknown Source)</div>
<div>at com.actuate.activeportal.actions.AcSubmitJobAction.execute(Unknown Source)</div>
<div>at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)</div>
<div>at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)</div>
<div>at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)</div>
<div>at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)</div>
<div>at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:486)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)</div>
<div>at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)</div>
<div>at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:271)</div>
<div>at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:98)</div>
<div>at org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30)</div>
<div>at org.apache.jsp.birtAdapter.birtAdapter_jsp._jspService(birtAdapter_jsp.java:1589)</div>
<div>at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:111)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)</div>
<div>at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:486)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)</div>
<div>at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)</div>
<div>at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:271)</div>
<div>at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:98)</div>
<div>at org.eclipse.equinox.http.servlet.internal.RequestDispatcherAdaptor.forward(RequestDispatcherAdaptor.java:30)</div>
<div>at com.actuate.iv.adapter.ViewerAdapterServlet.doPost(ViewerAdapterServlet.java:54)</div>
<div>at com.actuate.iv.adapter.ViewerAdapterServlet.doGet(ViewerAdapterServlet.java:40)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)</div>
<div>at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)</div>
<div>at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:486)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)</div>
<div>at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:413)</div>
<div>at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)</div>
<div>at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)</div>
<div>at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)</div>
<div>at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)</div>
<div>at org.eclipse.jetty.server.Server.handle(Server.java:350)</div>
<div>at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)</div>
<div>at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:890)</div>
<div>at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:944)</div>
<div>at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:630)</div>
<div>at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)</div>
<div>at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:77)</div>
<div>at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:606)</div>
<div>at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:46)</div>
<div>at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603)</div>
<div>at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538)</div>
<div>at java.lang.Thread.run(Thread.java:745)</div>
<div>Caused by: org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY';":</div>
<div>Fail to execute script in function __bm_beforeOpen(). Source:</div>
<div>
</div>
<div>" + ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'; + "</div>
<div>
</div>
<div>A BIRT exception occurred. See next exception for more information.</div>
<div>missing ; before statement (/report/data-sets/oda-data-set[@id="492"]/method[@name="beforeOpen"]#1).</div>
<div>... 97 more</div>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_beforeOpen(). Source:</div>
<div>
</div>
<div>" + ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'; + "</div>
<div>
</div>
</blockquote>Warning No formatter is installed for the format ipb1 -
<p>So what are you doing in the before open script? Can you share your design?</p>
0 -
<p>Thank you, i found the error.</p>
<p> </p>
<p>I have a script on dataset COMPANY, that invoke an oracle procedure and that produce the error. I don't understand why on BIRT 3.2.22 doesn't show the error but in the new versión this is an terrible error, jajajaja.</p>
<p> </p>
<p>Thank you very much.</p>
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 119 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management