Search Results: Saanjhi.com

1645 results for 'BSC=BUS020000'

Human Resources Management - [Tripathi, Pratibha] $20.69

Responsible AI: Implement an Ethical Approach in Your Organization - Responsible AI: Implement an Ethical Approach in Your Organization ~~$134.00~~ $131.28

Responsible AI Implement an Ethical Approach in your Organization - [Gambelin, Olivia] $45.99

New Values-Based Safety - New Values-Based Safety ~~$34.95~~ $30.37

- $45.39

Evolving You Nine enduring principles for lasting leadership growth - [Madhosingh, Dr. Samantha] ~~$36.99~~ $30.18

Evolving You Nine enduring principles for lasting leadership growth - [Madhosingh, Dr. Samantha] ~~$24.99~~ $22.24

Fathers of Invention: An American Story of Family, Faith and Innovation - Fathers of Invention: An American Story of Family, Faith and Innovation $19.81

Biometrics and Neuroscience Research in Business and Management: Advances and Applications - Biometrics and Neuroscience Research in Business and Management: Advances and Applications $133.48

de Gruyter Handbook of Organizational Conflict Management - de Gruyter Handbook of Organizational Conflict Management ~~$49.99~~ $38.78

Successful Business Model Transformations in Disruptive Times A conceptual framework for establish - [Rudolph, Thomas, Schweizer, Markus] ~~$32.99~~ $27.53

Family Business Transformation: Strategic Orientation and Business Modelling - Family Business Transformation: Strategic Orientation and Business Modelling $133.48

LLC Beginner s Guide A Dummies Guide Book on How to Start Your Own Business - [Jack, Richmond] ~~$18.99~~ $18.27

Brian Tracy s Master Course For Business Success - [Tracy, Brian] ~~$19.95~~ $18.90

How Not to be a Leadership D ckhead - [Sallis, Steve] $15.78

Outlier Mindset: A Guide to Living With Purpose and Evolving Exponentially - Outlier Mindset: A Guide to Living With Purpose and Evolving Exponentially $22.46

FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: java.lang.IllegalArgumentException: Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.entity.GenericEntityException: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) (Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.entity.GenericEntityException: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: java.lang.IllegalArgumentException: Error running script at location [component://snj2/groovyScripts/catalog/ProductSummary.groovy]: org.apache.ofbiz.entity.GenericEntityException: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:348) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1607) at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:455) at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:380) at org.apache.ofbiz.entity.util.EntityQuery.queryOne(EntityQuery.java:421) at org.apache.ofbiz.entity.util.EntityQuery$queryOne$2.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:83) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) ... 85 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1581) ... 92 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) ... 87 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more FreeMarker template error: Java method "org.apache.ofbiz.widget.renderer.ScreenRenderer.render(String)" threw an exception when invoked on org.apache.ofbiz.widget.renderer.ScreenRenderer object "org.apache.ofbiz.widget.renderer.ScreenRenderer@428dff86"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: ${screens.render(productsummaryScreen)} [in template "component://snj2/template/catalog/KeywordSearch.ftl" at line 83, column 15] ---- 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:362) at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:239) at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:200) at freemarker.core.Environment.visitIteratorBlock(Environment.java:595) at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:81) at freemarker.core.IteratorBlock.accept(IteratorBlock.java:67) at freemarker.core.Environment.visit(Environment.java:326) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.visit(Environment.java:332) at freemarker.core.Environment.process(Environment.java:305) at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:263) at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:167) at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:216) at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:140) at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:906) at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:127) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:943) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:214) at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:860) at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:98) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:280) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:1001) at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:653) at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) 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.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:324) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:338) 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:528) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:873) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:670) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476) 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:748) Caused by: org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#productsummary]: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))))) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) at sun.reflect.GeneratedMethodAccessor100.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) ... 71 more Caused by: org.apache.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 create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:143) at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ... 80 more Caused by: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:178) at org.apache.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:115) at org.apache.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:883) at org.apache.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:743) at org.apache.ofbiz.snjgooglebase.ingramApi.searchRequestTypes12349Enhanced(ingramApi.java:491) at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:100) at org.apache.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:57) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:395) at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:227) at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) at org.apache.ofbiz.service.LocalDispatcher$runSync.call(Unknown Source) at ProductSummary.run(ProductSummary.groovy:81) at org.apache.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:204) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:342) at org.apache.ofbiz.base.util.ScriptUtil.executeScript(ScriptUtil.java:324) at org.apache.ofbiz.widget.model.AbstractModelAction$Script.runAction(AbstractModelAction.java:633) at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:142) at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:273) at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ... 80 more Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:434) at org.apache.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) ... 102 more Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:430) ... 103 more

Money Back

Love it! Use it! Reuse it!

Free Shipping

Shipping is on us

Free Support

24/24 available

Best Deal

Quality guaranteed

OFBiz Message

:ERROR MESSAGE:

org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://snj2/widget/CatalogScreens.xml#keywordsearch]: org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))) (Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [ProductCategory]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,Antiques & Collectibles | Buying & Selling | Online Sales (See also BUSINESS & ECONOMICS - E-Commerce(java.lang.String)][createdStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][createdTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][lastUpdatedStamp,2025-04-20 00:48:37.853(java.sql.Timestamp)][lastUpdatedTxStamp,2025-04-20 00:48:34.752(java.sql.Timestamp)][productCategoryId,ANT057040(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(100)))))

Science

Math

General

1645 results for 'BSC=BUS020000'

Money Back

Free Shipping

Free Support

Best Deal