Parameters Error

Options
jcastro90
jcastro90
edited February 11, 2022 in Analytics #1
<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>

Comments

  • JFreeman
    JFreeman
    edited February 23, 2015 #2
    Options
    <p>Can you upload the report or a sample report that reproduces the issue?</p>
    <p> </p>
    <p>What is the full stack trace when this happens?</p>
    <p>Can you upload the .log file from the designer?</p>
    Warning No formatter is installed for the format ipb
  • micajblock
    micajblock E
    #3
    Options
    <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>
  • jcastro90
    jcastro90
    #4
    Options
    <p>Good Afternoon, there the log file.</p>
    <p> </p>
    <p> </p>
  • JFreeman
    JFreeman
    #5
    Options
    <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=&quot;492"]/method[@name=&quot;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 ipb
  • micajblock
    micajblock E
    edited February 23, 2015 #6
    Options
    <p>So what are you doing in the before open script? Can you share your design?</p>
  • jcastro90
    jcastro90
    #7
    Options
    <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>

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs