Bug in Ecommerce Search of OFBIZ 9.04?

[Koon Sang]

Hi,

When I do a keyword search using the left bar "Search Catalog" screenlet in OFBIZ Ecommerce, I got some results.  But, when I click on "refine search" and enter the same keyword in the search screen, I got no results.  When I look at the log, it seems like there are some exceptions as shown below:

2010-03-15 19:25:23,599 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 15 screens in 0.016s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CommonScreens.xml
2010-03-15 19:25:23,850 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 7 screens in 0.011s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CartScreens.xml
2010-03-15 19:25:23,899 (http-0.0.0.0-8443-5) [    ConfigXMLReader.java:118:INFO ] controller loaded: 0.01s, 258 requests, 87 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
2010-03-15 19:25:23,930 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 29 screens in 0.013s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-03-15 19:25:24,288 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 8 screens in 0.011s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/ContentScreens.xml
2010-03-15 19:25:24,482 (http-0.0.0.0-8443-5) [     ControlServlet.java:299:INFO ] [[[keywordsearch] Request Done- total:53.728,since last([keywordsearch] R...):53.728]]
2010-03-15 19:25:39,700 (http-0.0.0.0-8443-5) [     ControlServlet.java:130:INFO ] [[[advancedsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-03-15 19:25:39,734 (http-0.0.0.0-8443-5) [    ConfigXMLReader.java:118:INFO ] controller loaded: 0.0090s, 258 requests, 87 views in jndi:/0.0.0.0/ecommerce/WEB-INF/controller.xml
2010-03-15 19:25:39,736 (http-0.0.0.0-8443-5) [     RequestHandler.java:697:INFO ] Rendering View [advancedsearch], sessionId=A5AA09360E1A6C802802BA2A018B6466.jvm1
2010-03-15 19:25:39,753 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 29 screens in 0.015s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CatalogScreens.xml
2010-03-15 19:25:39,856 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 15 screens in 0.012s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CommonScreens.xml
2010-03-15 19:25:39,967 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 7 screens in 0.01s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/CartScreens.xml
2010-03-15 19:25:40,261 (http-0.0.0.0-8443-5) [      ScreenFactory.java:129:INFO ] Got 8 screens in 0.01s from: file:/D:/projects/princeton/ofbiz/specialpurpose/ecommerce/widget/ContentScreens.xml
2010-03-15 19:25:40,451 (http-0.0.0.0-8443-5) [     ControlServlet.java:299:INFO ] [[[advancedsearch] Request Done- total:0.751,since last([advancedsearch] ...):0.751]]
2010-03-15 19:25:44,027 (http-0.0.0.0-8443-5) [     ControlServlet.java:130:INFO ] [[[keywordsearch] Request Begun, encoding=[UTF-8]- total:0.0,since last(Begin):0.0]]
2010-03-15 19:25:44,030 (http-0.0.0.0-8443-5) [     RequestHandler.java:593:INFO ] Ran Event [java:org.ofbiz.product.product.ProductSearchSession#checkDoKeywordOverride] from [request], result is [success]
2010-03-15 19:25:44,030 (http-0.0.0.0-8443-5) [     RequestHandler.java:697:INFO ] Rendering View [keywordsearch], sessionId=A5AA09360E1A6C802802BA2A018B6466.jvm1
2010-03-15 19:25:46,402 (http-0.0.0.0-8443-5) [         EntityExpr.java:271:WARN ]
---- exception report ----------------------------------------------------------
=-=-=-=-=-=-=-=-= Database type warning in EntityExpr =-=-=-=-=-=-=-=-= In entity field [DynamicViewEntity.pcm1ProductCategoryId] set the value passed in [javolution.util.FastList] is not compatible with the Java type of the field [String]
Exception: java.lang.Exception
Message: Location of database type warning
---- stack trace ---------------------------------------------------------------
java.lang.Exception: Location of database type warning
org.ofbiz.entity.condition.EntityExpr.checkRhsType(EntityExpr.java:271)
org.ofbiz.entity.condition.EntityExpr.makeWhereString(EntityExpr.java:168)
org.ofbiz.entity.condition.EntityJoinOperator.addSqlValue(EntityJoinOperator.java:67)
org.ofbiz.entity.condition.EntityConditionListBase.makeWhereString(EntityConditionListBase.java:89)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:676)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:140)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:2451)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:647)
org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:225)
org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:923)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:230)
groovy.lang.MetaClassImpl.invokeStaticMethod(MetaClassImpl.java:1105)
org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:749)
org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:170)
KeywordSearch.run(KeywordSearch.groovy:35)
org.ofbiz.base.util.GroovyUtil.runScriptAtLocation(GroovyUtil.java:117)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction.java:408)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.java:118)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:220)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:393)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:132)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:92)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandler.java:98)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:789)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:533)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:201)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:77)
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:259)
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.ofbiz.catalina.container.CrossSubdomainSessionValve.invoke(CrossSubdomainSessionValve.java:62)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
java.lang.Thread.run(Unknown Source)


Anyone has any idea?
Thank you.