Error while trying to export statistics

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

MSelke
Posts: 28
Joined: Thu Feb 25, 2016 11:19 am

Error while trying to export statistics

Post by MSelke »

Hello,

We discovered a bug in our OpenEMM environment, when we try to export a statistic for a mailing.

Our Versions:
OpenEMM Maintenance Tool (OMT) v20.10.073
Runtime Version: 20.10.075
OpenEMM Frontend Version: 20.10.000.148
System-Url: https://news.<Domain>.com
OpenEMM Backend Version: 20.10.000.126

I get the following Error in the log for the statistics (/webapps/statistics/logs/ReportEngine_2021_04_08_12_21_39.log)

Sep 27, 2021 6:10:17 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: Invalid javascript expression: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)
org.eclipse.birt.report.engine.api.EngineException: Invalid javascript expression: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)

Is this bug already known? Can we fix it with an update?

Best Regards

Martin
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Error while trying to export statistics

Post by maschoff »

Please provide detailed info how to reproduce (click path).
OpenEMM Maintainer
MSelke
Posts: 28
Joined: Thu Feb 25, 2016 11:19 am

Re: Error while trying to export statistics

Post by MSelke »

I provided two screenshots. In the browser console we see that the request is pending for about thirty seconds and then the error site appear.

https://drive.google.com/file/d/1-9TmaA ... i88jV/view

https://drive.google.com/file/d/1mpTBdy ... lov70/view

I hope you can get enough information from the images.
maschoff
Site Admin
Posts: 2597
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: Error while trying to export statistics

Post by maschoff »

The export created a PDF file via the command line tool wkhtmltox. To do this, OpenEMM has to call itsself. Please check your settings with OMT in menu Configuration -> Change basic configuration. Also check, if a proxy blocks your server from calling itsself.
OpenEMM Maintainer
MSelke
Posts: 28
Joined: Thu Feb 25, 2016 11:19 am

Re: Error while trying to export statistics

Post by MSelke »

Hello, i get some additional Informations.

I checked your hints and this is configured correctly. I get the information that the export is not working only for this, or a few newsletter, but most of the newsletter exports are working fine.

I give you the full stacktrace. Can your see there something?

Code: Select all

Sep 27, 2021 6:10:17 PM org.eclipse.birt.report.engine.script.internal.ScriptExecutor addException
WARNING: Invalid javascript expression: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)
org.eclipse.birt.report.engine.api.EngineException: Invalid javascript expression: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)
	at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleAfterRender(ReportScriptExecutor.java:203)
	at org.eclipse.birt.report.engine.api.impl.EngineTask.closeRender(EngineTask.java:2069)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:185)
	at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
	at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)
	at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
	at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
	at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
	at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
	at jdk.internal.reflect.GeneratedMethodAccessor924.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
	at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
	at jdk.internal.reflect.GeneratedMethodAccessor923.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
	at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
	at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
	at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
	at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
	at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
	at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
	at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
	at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.agnitas.reporting.birt.external.web.filter.BirtNoDocumentParameterInterceptor.doFilter(BirtNoDocumentParameterInterceptor.java:57)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.agnitas.reporting.birt.external.web.filter.BirtInterceptingFilter.doFilter(BirtInterceptingFilter.java:65)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.agnitas.reporting.birt.external.web.filter.BIRTLanguageFilter.doFilter(BIRTLanguageFilter.java:40)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:666)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.eclipse.birt.core.exception.CoreException: Invalid javascript expression: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)
	at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:300)
	at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:159)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:791)
	at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:720)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScriptInternal(ScriptExecutor.java:118)
	at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScript(ScriptExecutor.java:105)
	at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleAfterRender(ReportScriptExecutor.java:195)
	... 66 more
Caused by: org.mozilla.javascript.EvaluatorException: Can't find method com.agnitas.reporting.birt.external.dataset.BIRTDataSet.dropTempTable(null). (/report/method[@name="afterRender"]#1)
	at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:77)
	at org.mozilla.javascript.Context.reportRuntimeError(Context.java:913)
	at org.mozilla.javascript.Context.reportRuntimeError(Context.java:969)
	at org.mozilla.javascript.Context.reportRuntimeError1(Context.java:932)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:144)
	at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)
	at org.mozilla.javascript.gen._report_method__name__afterRender___41704._c_script_0(/report/method[@name="afterRender"]:1)
	at org.mozilla.javascript.gen._report_method__name__afterRender___41704.call(/report/method[@name="afterRender"])
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)
	at org.mozilla.javascript.gen._report_method__name__afterRender___41704.call(/report/method[@name="afterRender"])
	at org.mozilla.javascript.gen._report_method__name__afterRender___41704.exec(/report/method[@name="afterRender"])
	at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:291)
	... 72 more

Post Reply