FreeMarker template error: Java method "org.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.ofbiz.widget.renderer.ScreenRenderer object "org.ofbiz.widget.renderer.ScreenRenderer@1daf78ee"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render("component://leitold... [in template "component://leitold/template/include/Header.ftl" at line 113, column 3] ---- Java stack trace (for programmers): ---- freemarker.core._TemplateModelException: [... Exception message was already printed; see it above ...] at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:289) at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:261) at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:65) at freemarker.core.MethodCall._eval(MethodCall.java:65) at freemarker.core.Expression.eval(Expression.java:81) at freemarker.core.DollarVariable.calculateInterpolatedStringOrMarkup(DollarVariable.java:96) at freemarker.core.DollarVariable.accept(DollarVariable.java:59) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:261) at org.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:459) at org.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at org.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:89) at javax.servlet.http.HttpServlet.service(HttpServlet.java:622) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:720) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:391) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318) at org.ofbiz.product.category.ftl.CatalogUrlSeoTransform.forwardUri(CatalogUrlSeoTransform.java:605) at org.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:65) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:868) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:750) Caused by: org.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://leitold/widget/CommonScreens.xml#mainnavigation]: java.lang.IllegalArgumentException: Error running script at location [component://leitold/groovyScripts/catalog/ProductCategories.groovy]: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted) (SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted)) (Error running script at location [component://leitold/groovyScripts/catalog/ProductCategories.groovy]: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted) (SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted))) at org.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:1458) at freemarker.ext.beans.ReflectionCallableMemberDescriptor.invokeMethod(ReflectionCallableMemberDescriptor.java:56) at freemarker.ext.beans.MemberAndArguments.invokeMethod(MemberAndArguments.java:51) at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:61) ... 62 more Caused by: java.lang.IllegalArgumentException: Error running script at location [component://leitold/groovyScripts/catalog/ProductCategories.groovy]: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted) (SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted)) at org.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:348) at org.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 71 more Caused by: org.ofbiz.entity.GenericEntityException: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted) (SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted)) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1603) at org.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:447) at org.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:378) at org.ofbiz.entity.util.EntityQuery$queryList$5.call(Unknown Source) at ProductCategories.fillTree(ProductCategories.groovy:35) at ProductCategories$fillTree.callCurrent(Unknown Source) at ProductCategories.run(ProductCategories.groovy:91) at org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:183) at org.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) ... 76 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT PRODUCT_CATEGORY_ID, PARENT_PRODUCT_CATEGORY_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM PRODUCT_CATEGORY_ROLLUP WHERE (((PARENT_PRODUCT_CATEGORY_ID = ?) AND (((THRU_DATE IS NULL OR THRU_DATE > ?) AND (FROM_DATE IS NULL OR FROM_DATE <= ?))))) ORDER BY SEQUENCE_NUM ASC (Query execution was interrupted) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:401) at org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:786) at org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140) at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1547) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1583) ... 84 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLQueryInterruptedException: Query execution was interrupted at sun.reflect.GeneratedConstructorAccessor315.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:398) ... 88 more