Hi, i am running the latest version of ofbiz with postgres. The product search in ecommerce works fine when using a single keyword, however when two or more keywords are entered i am getting the below error. Is it a bug, should i open a jira issue for it.
Please advise, Thanks, Rohit 2010-01-12 21:12:21,982 (TP-Processor20) [ ControlServlet.java:321:INFO ] [[[keywordsearch] Request Done- total:0.269,since last([keywordsearch] R...):0.269]] 2010-01-12 21:12:22,694 (TP-Processor20) [ ContextFilter.java:260:WARN ] [Filtered request]: /favicon.ico (/control/main) 2010-01-12 21:12:23,012 (TP-Processor2) [ ControlServlet.java:140:INFO ] [[[main] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2010-01-12 21:12:23,014 (TP-Processor2) [ RequestHandler.java:733:INFO ] Rendering View [main], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1 2010-01-12 21:12:23,160 (TP-Processor2) [ ProductStoreWorker.java:481:INFO ] getSurvey for product null 2010-01-12 21:12:23,886 (TP-Processor2) [ ControlServlet.java:321:INFO ] [[[main] Request Done- total:0.874,since last([main] Request Be...):0.874]] 2010-01-12 21:12:24,902 (TP-Processor9) [ ControlServlet.java:140:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]] 2010-01-12 21:12:24,907 (TP-Processor9) [ JkInputStream.java:196:INFO ] Receiving: getting request body chunk 96 96 2010-01-12 21:12:24,911 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: [] 2010-01-12 21:12:24,912 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: [] 2010-01-12 21:12:24,912 (TP-Processor9) [ RequestHandler.java:629:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success] 2010-01-12 21:12:24,912 (TP-Processor9) [ RequestHandler.java:733:INFO ] Rendering View [keywordsearch], sessionId=B3B4DC9539461C47F565AA8E223DCF60.jvm1 2010-01-12 21:12:24,927 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [abnormal], got set: [] 2010-01-12 21:12:24,927 (TP-Processor9) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [psychology], got set: [] 2010-01-12 21:12:24,928 (TP-Processor9) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet=[] keywordFixedOrSetAndList=[[%abnormal%, %psycholog%]] 2010-01-12 21:12:25,129 (TP-Processor9) [ GenericDAO.java:766:INFO ] Ran query in 199 milli-seconds: SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT), PROD.PRODUCT_ID FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY SUM(PK1.RELEVANCY_WEIGHT) DESC 2010-01-12 21:12:25,133 (TP-Processor9) [ ProductSearch.java:762:ERROR] ---- exception report ---------------------------------------------------------- Error getting results from the product search query Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT COUNT(1) FROM (SELECT COUNT(DISTINCT SUM(PK1.RELEVANCY_WEIGHT)) FROM (public.PRODUCT PROD LEFT OUTER JOIN public.PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID) INNER JOIN public.PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE (PROD.IS_VARIANT <> ? AND (PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID) TEMP_NAME (ERROR: aggregate function calls may not be nested) ---- cause --------------------------------------------------------------------- Exception: org.postgresql.util.PSQLException Message: ERROR: aggregate function calls may not be nested ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: ERROR: aggregate function calls may not be nested org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:386) org.ofbiz.entity.datasource.GenericDAO.selectCountByCondition(GenericDAO.java:1095) org.ofbiz.entity.util.EntityListIterator.getResultsSizeAfterPartialList(EntityListIterator.java:515) org.ofbiz.product.product.ProductSearch$ProductSearchContext.makeProductIdList(ProductSearch.java:749) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:224) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:958) org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source) KeywordSearch.run(KeywordSearch.groovy:35) org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149) org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412) org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:99) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:266) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-12 21:12:25,134 (TP-Processor9) [ GenericDelegator.java:832:ERROR] ---- exception report ---------------------------------------------------------- Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) ---- cause --------------------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block) ---- cause --------------------------------------------------------------------- Exception: org.postgresql.util.PSQLException Message: ERROR: current transaction is aborted, commands ignored until end of transaction block ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:418) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684) org.ofbiz.entity.GenericValue.create(GenericValue.java:125) org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:958) org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source) KeywordSearch.run(KeywordSearch.groovy:35) org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149) org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412) org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:99) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:266) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-12 21:12:25,135 (TP-Processor9) [ TransactionUtil.java:372:WARN ] ---- exception report ---------------------------------------------------------- [TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this stack trace shows where this is happening: Exception: java.lang.Exception Message: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction. ---- stack trace --------------------------------------------------------------- java.lang.Exception: Failure in create operation for entity [ProductSearchResult]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)). Rolling back transaction. org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:372) org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:319) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:835) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684) org.ofbiz.entity.GenericValue.create(GenericValue.java:125) org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:958) org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source) KeywordSearch.run(KeywordSearch.groovy:35) org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149) org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412) org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:99) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:266) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-12 21:12:25,136 (TP-Processor9) [ ProductSearch.java:801:ERROR] ---- exception report ---------------------------------------------------------- Error saving product search result info/stats Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:ProductSearchResult][createdStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][createdTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2010-01-12 21:12:25.133(java.sql.Timestamp)][lastUpdatedTxStamp,2010-01-12 21:12:24.916(java.sql.Timestamp)][numResults,10(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,32996(java.lang.String)][searchDate,2010-01-12 21:12:24.927(java.sql.Timestamp)][secondsTotal,0.205(java.lang.Double)][visitId,429998(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block)) ---- cause --------------------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO public.PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME, IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: current transaction is aborted, commands ignored until end of transaction block) ---- cause --------------------------------------------------------------------- Exception: org.postgresql.util.PSQLException Message: ERROR: current transaction is aborted, commands ignored until end of transaction block ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:418) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java:173) org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:119) org.ofbiz.entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:64) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:810) org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:684) org.ofbiz.entity.GenericValue.create(GenericValue.java:125) org.ofbiz.product.product.ProductSearch$ProductSearchContext.saveSearchResultInfo(ProductSearch.java:788) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:237) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:958) org.ofbiz.product.product.ProductSearchSession$getProductSearchResult.call(Unknown Source) KeywordSearch.run(KeywordSearch.groovy:35) org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:149) org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:412) org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:221) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:394) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:99) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:831) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:550) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:223) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:86) javax.servlet.http.HttpServlet.service(HttpServlet.java:710) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:266) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190) org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690) java.lang.Thread.run(Thread.java:619) -------------------------------------------------------------------------------- 2010-01-12 21:12:25,136 (TP-Processor9) [ TransactionUtil.java:376:INFO ] [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback only is already set. 2010-01-1 -- View this message in context: http://n4.nabble.com/Error-in-product-search-result-when-using-multiple-keywords-tp1012687p1012687.html Sent from the OFBiz - User mailing list archive at Nabble.com.
