Mi cesta 0 items
Consulta tu cesta Subtotal: 0,00 €
Recomendados
Portada
45,00 €
IVA incluido
Comprar
Portada
15,00 €
IVA incluido
Comprar
Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] The problematic instruction: ---------- ==> ${screens.render('component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail')} [on line 83, column 113 in component://UpvGEStore/webapp/UpvGEStoreWebapp/catalog/minifeaturedbooksScreenlet.ftl] ---------- Java backtrace for programmers: ---------- freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:167) at freemarker.core.Environment.visit(Environment.java:416) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.Environment.process(Environment.java:189) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:216) at org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:205) at org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:250) at org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:110) at org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1000) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:842) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:589) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:748) Caused by: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail]: org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://order/webapp/ordermgr/WEB-INF/actions/entry/catalog/ProductDetail.groovy] (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset))) (Error running Groovy script at location [component://order/webapp/ordermgr/WEB-INF/actions/entry/catalog/ProductDetail.groovy] (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)))) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:421) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at sun.reflect.GeneratedMethodAccessor172.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:840) at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:104) ... 113 more Caused by: org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://order/webapp/ordermgr/WEB-INF/actions/entry/catalog/ProductDetail.groovy] (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset))) at org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:426) at org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:220) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) ... 120 more Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:159) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1778) at org.ofbiz.entity.GenericDelegator.findByAnd(GenericDelegator.java:1697) at sun.reflect.GeneratedMethodAccessor168.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133) at ProductDetail.run(ProductDetail.groovy:234) at org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421) ... 123 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:390) at org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:757) at org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1746) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1781) at org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:343) at org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalcForDisplay(TaxAuthorityServices.java:105) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.accounting.servicedef.services_95$tax_46$xml_35$calcTaxForDisplay.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/accounting/servicedef/services_tax.xml#calcTaxForDisplay:63) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at org.ofbiz.product.price.PriceServices.addGeneralResults(PriceServices.java:678) at org.ofbiz.product.price.PriceServices.calculateProductPrice(PriceServices.java:552) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.product.servicedef.services_95$pricepromo_46$xml_35$calculateProductPrice.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/product/servicedef/services_pricepromo.xml#calculateProductPrice:29) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:129) at ProductDetail.run(ProductDetail.groovy:175) ... 124 more Caused by: java.sql.SQLException: Io exception: Connection reset at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:994) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1074) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387) ... 159 more Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] The problematic instruction: ---------- ==> ${screens.render('component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail')} [on line 87, column 113 in component://UpvGEStore/webapp/UpvGEStoreWebapp/catalog/minifeaturedbooksScreenlet.ftl] ---------- Java backtrace for programmers: ---------- freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:167) at freemarker.core.Environment.visit(Environment.java:416) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.Environment.process(Environment.java:189) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:216) at org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:205) at org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:250) at org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:110) at org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1000) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:842) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:589) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:748) Caused by: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset))) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:421) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at sun.reflect.GeneratedMethodAccessor172.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:840) at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:104) ... 113 more Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:159) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:387) ... 120 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:390) at org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:757) at org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1746) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1781) at org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:343) at org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalcForDisplay(TaxAuthorityServices.java:105) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.accounting.servicedef.services_95$tax_46$xml_35$calcTaxForDisplay.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/accounting/servicedef/services_tax.xml#calcTaxForDisplay:63) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at org.ofbiz.product.price.PriceServices.addGeneralResults(PriceServices.java:678) at org.ofbiz.product.price.PriceServices.calculateProductPrice(PriceServices.java:552) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.product.servicedef.services_95$pricepromo_46$xml_35$calculateProductPrice.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/product/servicedef/services_pricepromo.xml#calculateProductPrice:29) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:129) at ProductDetail.run(ProductDetail.groovy:175) at org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421) at org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:220) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) ... 120 more Caused by: java.sql.SQLException: Io exception: Connection reset at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:994) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1074) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387) ... 159 more
Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] The problematic instruction: ---------- ==> ${screens.render('component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail')} [on line 102, column 105 in component://UpvGEStore/webapp/UpvGEStoreWebapp/catalog/minifeaturedbooksScreenlet.ftl] ---------- Java backtrace for programmers: ---------- freemarker.template.TemplateModelException: Method public java.lang.String org.ofbiz.widget.screen.ScreenRenderer.render(java.lang.String) throws org.ofbiz.base.util.GeneralException,java.io.IOException,org.xml.sax.SAXException,javax.xml.parsers.ParserConfigurationException threw an exception when invoked on org.ofbiz.widget.screen.ScreenRenderer@4b27b3fa with arguments of types [java.lang.String,] at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:134) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:167) at freemarker.core.Environment.visit(Environment.java:416) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:102) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.Environment.process(Environment.java:189) at org.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:216) at org.ofbiz.widget.screen.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:205) at org.ofbiz.widget.screen.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:250) at org.ofbiz.widget.screen.HtmlWidget.renderWidgetString(HtmlWidget.java:110) at org.ofbiz.widget.screen.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1000) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$IncludeScreen.renderWidgetString(ModelScreenWidget.java:575) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:703) at org.ofbiz.widget.screen.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:166) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:735) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:295) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:671) at org.ofbiz.widget.screen.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:136) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:227) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) at org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:842) at org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:589) at org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:227) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:269) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) at java.lang.Thread.run(Thread.java:748) Caused by: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://UpvGEStore/widget/UpvCatalogScreens.xml#minifeaturedbooksDetail]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset))) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:421) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at sun.reflect.GeneratedMethodAccessor172.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:840) at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:104) ... 109 more Caused by: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:159) at org.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:131) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:387) ... 116 more Caused by: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:390) at org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:757) at org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) at org.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1746) at org.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1781) at org.ofbiz.accounting.tax.TaxAuthorityServices.getTaxAdjustments(TaxAuthorityServices.java:343) at org.ofbiz.accounting.tax.TaxAuthorityServices.rateProductTaxCalcForDisplay(TaxAuthorityServices.java:105) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.accounting.servicedef.services_95$tax_46$xml_35$calcTaxForDisplay.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/accounting/servicedef/services_tax.xml#calcTaxForDisplay:63) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at org.ofbiz.product.price.PriceServices.addGeneralResults(PriceServices.java:678) at org.ofbiz.product.price.PriceServices.calculateProductPrice(PriceServices.java:552) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.ofbiz.service.ModelServiceReader$GenericInvokerImpl.runSync(ModelServiceReader.java:761) at _$gen.file_58$.disco2.home.tomcat.OFBIZ.ofbizupv.applications.product.servicedef.services_95$pricepromo_46$xml_35$calculateProductPrice.runSync(file:/disco2/home/tomcat/OFBIZ/ofbizupv/applications/product/servicedef/services_pricepromo.xml#calculateProductPrice:29) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:399) at org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:226) at org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:165) at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:129) at ProductDetail.run(ProductDetail.groovy:175) at org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:421) at org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:121) at org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:220) at org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) at org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) at sun.reflect.GeneratedMethodAccessor172.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:840) at freemarker.ext.beans.OverloadedMethodModel.exec(OverloadedMethodModel.java:104) at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.DollarVariable.accept(DollarVariable.java:76) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:209) at freemarker.core.IfBlock.accept(IfBlock.java:82) ... 105 more Caused by: java.sql.SQLException: Io exception: Connection reset at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:994) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1074) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3415) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3460) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:387) ... 159 more
Open For Business Message

:ERROR MESSAGE:
org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://UpvGEStore/widget/ecommerce/CommonScreens.xml#bottombar]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in findByCondition operation for entity [TaxAuthorityRateProduct]: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset). Rolling back transaction.org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset) (SQL Exception while executing the following:SELECT TAX_AUTHORITY_RATE_SEQ_ID, TAX_AUTH_GEO_ID, TAX_AUTH_PARTY_ID, TAX_AUTHORITY_RATE_TYPE_ID, PRODUCT_STORE_ID, PRODUCT_CATEGORY_ID, TITLE_TRANSFER_ENUM_ID, MIN_ITEM_PRICE, MIN_PURCHASE, TAX_SHIPPING, TAX_PERCENTAGE, TAX_PROMOTIONS, FROM_DATE, THRU_DATE, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM OFBIZ10.TAX_AUTHORITY_RATE_PRODUCT WHERE ((PRODUCT_STORE_ID = ? OR PRODUCT_STORE_ID IS NULL) AND ((TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?) OR (TAX_AUTH_PARTY_ID = ? AND TAX_AUTH_GEO_ID = ?)) AND (PRODUCT_CATEGORY_ID IS NULL OR PRODUCT_CATEGORY_ID IN (?, ?, ?, ?)) AND (MIN_ITEM_PRICE IS NULL OR MIN_ITEM_PRICE <= ?) AND (MIN_PURCHASE IS NULL OR MIN_PURCHASE <= ?)) ORDER BY MIN_ITEM_PRICE ASC, MIN_PURCHASE ASC, FROM_DATE ASC (Io exception: Connection reset)))