[jira] [Created] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
Locked
[jira] [Created] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
 
|
GenericModelException in product search when there is no valid keyword in the query string
------------------------------------------------------------------------------------------ Key: OFBIZ-4712 URL: https://issues.apache.org/jira/browse/OFBIZ-4712 Project: OFBiz Issue Type: Bug Components: specialpurpose/ecommerce Affects Versions: Release Branch 11.04 Reporter: Atul Vani Priority: Minor Fix For: Release Branch 11.04 Below is the relevant log: 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} keywordFixedOrSetAndList={} 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] ---- exception report ---------------------------------------------------------- Error in product search Exception: org.ofbiz.entity.GenericModelException Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) java.lang.reflect.Method.invoke(Method.java:616) org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) KeywordSearch.run(KeywordSearch.groovy:35) org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) 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:339) 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:191) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:554) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) java.lang.Thread.run(Thread.java:636) -------------------------------------------------------------------------------- 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Updated] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Atul Vani updated OFBIZ-4712: ----------------------------- Attachment: OFBIZ-4712.patch Patch attached for a possible fix. However, with this patch the search api will start to return all of the products as search result in such cases. > GenericModelException in product search when there is no valid keyword in the query string > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-4712 > URL: https://issues.apache.org/jira/browse/OFBIZ-4712 > Project: OFBiz > Issue Type: Bug > Components: specialpurpose/ecommerce > Affects Versions: Release Branch 11.04 > Reporter: Atul Vani > Priority: Minor > Fix For: Release Branch 11.04 > > Attachments: OFBIZ-4712.patch > > > Below is the relevant log: > 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] > 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} > keywordFixedOrSetAndList={} > 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) > 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] > ---- exception report ---------------------------------------------------------- > Error in product search > Exception: org.ofbiz.entity.GenericModelException > Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) > org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) > KeywordSearch.run(KeywordSearch.groovy:35) > org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) > org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) > org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) > org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) > org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > 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:339) > 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:191) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > 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:554) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > java.lang.Thread.run(Thread.java:636) > -------------------------------------------------------------------------------- > 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
Re: [jira] [Updated] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
|
|
Good solution that it returns all products when no keyword is entered !
Heidi 2012/2/22 Atul Vani (Updated) (JIRA) <[hidden email]>: > > [ https://issues.apache.org/jira/browse/OFBIZ-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] > > Atul Vani updated OFBIZ-4712: > ----------------------------- > > Attachment: OFBIZ-4712.patch > > Patch attached for a possible fix. However, with this patch the search api will start to return all of the products as search result in such cases. > >> GenericModelException in product search when there is no valid keyword in the query string >> ------------------------------------------------------------------------------------------ >> >> Key: OFBIZ-4712 >> URL: https://issues.apache.org/jira/browse/OFBIZ-4712 >> Project: OFBiz >> Issue Type: Bug >> Components: specialpurpose/ecommerce >> Affects Versions: Release Branch 11.04 >> Reporter: Atul Vani >> Priority: Minor >> Fix For: Release Branch 11.04 >> >> Attachments: OFBIZ-4712.patch >> >> >> Below is the relevant log: >> 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] >> 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} >> keywordFixedOrSetAndList={} >> 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) >> 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] >> ---- exception report ---------------------------------------------------------- >> Error in product search >> Exception: org.ofbiz.entity.GenericModelException >> Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} >> ---- stack trace --------------------------------------------------------------- >> org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} >> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) >> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) >> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) >> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) >> org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) >> org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) >> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> java.lang.reflect.Method.invoke(Method.java:616) >> org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) >> org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) >> org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) >> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) >> KeywordSearch.run(KeywordSearch.groovy:35) >> org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) >> org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) >> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) >> org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) >> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) >> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) >> org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) >> org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) >> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) >> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) >> org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:637) >> javax.servlet.http.HttpServlet.service(HttpServlet.java:717) >> 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:339) >> 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:191) >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) >> 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:554) >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) >> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) >> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) >> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) >> java.lang.Thread.run(Thread.java:636) >> -------------------------------------------------------------------------------- >> 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results > > -- > This message is automatically generated by JIRA. > If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa > For more information on JIRA, see: http://www.atlassian.com/software/jira > > -- Olagos bvba http://www.olagos.eu http://www.olagos.com http://www.olagos.be http://www.olagos.nl Olagos team Heesterbos 5 2570 Duffel Belgium |
[jira] [Assigned] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-4712: ----------------------------------- Assignee: Anil K Patel > GenericModelException in product search when there is no valid keyword in the query string > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-4712 > URL: https://issues.apache.org/jira/browse/OFBIZ-4712 > Project: OFBiz > Issue Type: Bug > Components: specialpurpose/ecommerce > Affects Versions: Release Branch 11.04 > Reporter: Atul Vani > Assignee: Anil K Patel > Priority: Minor > Fix For: Release Branch 11.04 > > Attachments: OFBIZ-4712.patch > > > Below is the relevant log: > 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] > 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} > keywordFixedOrSetAndList={} > 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) > 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] > ---- exception report ---------------------------------------------------------- > Error in product search > Exception: org.ofbiz.entity.GenericModelException > Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) > org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) > KeywordSearch.run(KeywordSearch.groovy:35) > org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) > org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) > org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) > org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) > org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > 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:339) > 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:191) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > 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:554) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > java.lang.Thread.run(Thread.java:636) > -------------------------------------------------------------------------------- > 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Resolved] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel resolved OFBIZ-4712. --------------------------------- Resolution: Fixed Atul, Applied to trunk and 11.04. Thanks. > GenericModelException in product search when there is no valid keyword in the query string > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-4712 > URL: https://issues.apache.org/jira/browse/OFBIZ-4712 > Project: OFBiz > Issue Type: Bug > Components: specialpurpose/ecommerce > Affects Versions: Release Branch 11.04 > Reporter: Atul Vani > Assignee: Anil K Patel > Priority: Minor > Fix For: Release Branch 11.04 > > Attachments: OFBIZ-4712.patch > > > Below is the relevant log: > 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] > 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} > keywordFixedOrSetAndList={} > 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) > 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] > ---- exception report ---------------------------------------------------------- > Error in product search > Exception: org.ofbiz.entity.GenericModelException > Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) > org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) > KeywordSearch.run(KeywordSearch.groovy:35) > org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) > org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) > org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) > org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) > org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > 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:339) > 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:191) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > 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:554) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > java.lang.Thread.run(Thread.java:636) > -------------------------------------------------------------------------------- > 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
[jira] [Closed] (OFBIZ-4712) GenericModelException in product search when there is no valid keyword in the query string
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-4712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel closed OFBIZ-4712. ------------------------------- > GenericModelException in product search when there is no valid keyword in the query string > ------------------------------------------------------------------------------------------ > > Key: OFBIZ-4712 > URL: https://issues.apache.org/jira/browse/OFBIZ-4712 > Project: OFBiz > Issue Type: Bug > Components: specialpurpose/ecommerce > Affects Versions: Release Branch 11.04 > Reporter: Atul Vani > Assignee: Anil K Patel > Priority: Minor > Fix For: Release Branch 11.04 > > Attachments: OFBIZ-4712.patch > > > Below is the relevant log: > 2012-02-22 16:34:57,343 (http-0.0.0.0-18080-2) [ KeywordSearchUtil.java:235:INFO ] Expanded keyword [and], got set: [] > 2012-02-22 16:34:57,344 (http-0.0.0.0-18080-2) [ ProductSearch.java:271:INFO ] Finished initial setup of keywords, doingBothAndOr=false, andKeywordFixedSet={} > keywordFixedOrSetAndList={} > 2012-02-22 16:34:57,345 (http-0.0.0.0-18080-2) [ ProductSearch.java:622:INFO ] topCond=((pcm1ThruDate IS NULL OR pcm1ThruDate > '2012-02-22 16:34:57.331') AND pcm1FromDate < '2012-02-22 16:34:57.331' AND pcm1ProductCategoryId IN ('CATALOG1_SEARCH')) > 2012-02-22 16:34:57,350 (http-0.0.0.0-18080-2) [ ProductSearch.java:652:ERROR] > ---- exception report ---------------------------------------------------------- > Error in product search > Exception: org.ofbiz.entity.GenericModelException > Message: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericModelException: In selectListIteratorByCondition invalid field names specified: {totalRelevancy} > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:663) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:139) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1806) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:650) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:223) > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:959) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > java.lang.reflect.Method.invoke(Method.java:616) > org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:88) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite$StaticMetaMethodSiteNoUnwrapNoCoerce.invoke(StaticMetaMethodSite.java:148) > org.codehaus.groovy.runtime.callsite.StaticMetaMethodSite.call(StaticMetaMethodSite.java:88) > org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) > org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:132) > KeywordSearch.run(KeywordSearch.groovy:35) > org.ofbiz.widget.ModelWidgetAction$Script.runAction(ModelWidgetAction.java:416) > org.ofbiz.widget.ModelWidgetAction.runSubActions(ModelWidgetAction.java:117) > org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:184) > org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:396) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:135) > org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:97) > org.ofbiz.widget.screen.MacroScreenViewHandler.render(MacroScreenViewHandler.java:104) > org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:847) > org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:564) > org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:224) > org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87) > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > 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:339) > 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:191) > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > 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:554) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) > java.lang.Thread.run(Thread.java:636) > -------------------------------------------------------------------------------- > 2012-02-22 16:34:57,351 (http-0.0.0.0-18080-2) [ ProductSearch.java:662:WARN ] The eli is null, returning zero results -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |