Re :Re: Keyword search is not working

[puranisank]

We are using the same search UI of opentaps-8.3We didn\'t do any modifications in [hidden email] wroteIt looks like you are importing data instead of using the UI.The UI has some safe guards built in.I suggest you use the UI then export the resultant data.dhilip kumar sent the following on 7/8/2006 4:11 AM:> I changed the introduction date.Then it asked for \"SalesDiscontinuationDate\" then for \"SupportDiscontinuationDate\",\"CreatedDate\", LastModifiedDate\".> I changed all the above values. The keyword creation for the products are done successfully.> But still I am not able to get results for searches.> I think it may be due to the wrong dates given for the above fields.> I don\'t understand what is \"SalesDiscontinuationDate\",\"SupportDiscontinuationDate\",\"CreatedDate\", LastModifiedDate\".> > Can you please give me some suggestions. Since my email id is not displaying the messages properly I am sending from this id.&g
 t; > > > > > > > > > gh of the log, prior to that error it> will tell what service was started and failed.> > 2) The issue is that Product.introductionDate is null.> For whatever reason, the service is needing a> complete primary key where Product.introductionDate is> not null. If you give your product an introduction> date in the format 2006-07-08 it will work> > 3) Can you please use a different email server? It\'s> escaping characters and not making them right before> they get sent. This makes it very dificult to read> your messages.> > --- [hidden email] wrote:> >> The following is the error from the log>>> :-------------------------------------------------------------------------------->> 266797[ >> RequestHandler.java:281:ERROR] Request>> UpdateAllKeywords caused an error with the following>> message: Error calling event:>> org.ofbiz.webapp.ev
 ent.EventHandlerException:>> Problems processing event:>> org.ofbiz.base.util.GeneralRuntimeException: Error>> creating GenericValue (SQL Exception while getting>> value : introductionDate [INTRODUCTION_DATE] (6)>> (Value \'0000-00-00\' can not be represented as>> java.sql.Timestamp)) (Error creating GenericValue>> (SQL Exception while getting value :>> introductionDate [INTRODUCTION_DATE] (6) (Value>> \'0000-00-00\' can not be represented as>> java.sql.Timestamp)))266797[ >> RequestHandler.java:372:INFO ]>> [RequestHandler.doRequest]: Response is a>> view.266797[ >> RequestHandler.java:524:INFO ] servletName=control,>> view=main266797[ >> PrimaryKeyFinder.java:132:INFO ] Returning null>> because found incomplete primary key in find:>> [GenericEntity:Product][productId,null()]266890[&n>> bsp; ServiceDispatcher.java:447:DEBUG] [[Sync>> service finished-
 total:0.0,since last(Begin):0.0]]>> - \'catalog />>> getProductCategoryAndLimitedMembers\'266906[ >> GenericDelegator.java:600:ERROR] ---- exception>> report>>> ----------------------------------------------------------Failure>> in create operation for entity [ServerHit]:>> org.ofbiz.entity.GenericEntityException: Exception>> while inserting the following entity:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL7049
 2148788(java.lang.String)][re>>> questUrl,https://localhost:8443/catalog/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Long)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)]>> (while inserting:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL70492148788(java.lang.String)][requestUrl,https://localhost:8443/catalo
 g/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Lon>>> g)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)]>> (SQL Exception while executing the following:INSERT>> INTO SERVER_HIT (VISIT_ID, CONTENT_ID,>> HIT_START_DATE_TIME, HIT_TYPE_ID,>> INTERNAL_CONTENT_ID, NUM_OF_BYTES,>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, PARTY_ID,>> STATUS_ID, REQUEST_URL, REFERRER_URL,>> ID_BY_IP_CONTACT_MECH_ID,>> REF_BY_WEB_CONTACT_MECH_ID, SERVER_IP_ADDRESS,>> SERVER_HOST_NAME, LAST_UPDATED_STAMP,>> LAST_UPDATED_TX_STAMP, CREATED_STAMP,>> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry>> \'REQUEST\' for key 2))). Rolling back>> transaction.Exception:>> org.ofbiz.entity.GenericEntityExceptionMessage:>
 > Exception while inserting the following entity:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08>> 15:52>>>>> :15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08>> [hidden email] wroteIf>> I were to guess, your product doesn\'t have>> anintroduction date. I don\'t know why it would>> needthat date because you didn\'t post enough of the>> log.--- [hidden email] wrote:> I am>> getting the following error when tried>>> \"AutoCreateKeywordsForAllProducts\"> > Error>> calling event:>>> org.ofbiz.webapp.event.EventHandlerException:>>> Pr
 oblems processing event:>>> org.ofbiz.base.util.GeneralRuntimeException:>> Error> creating GenericValue (SQL Exception while>> getting> value : introductionDate>> [INTRODUCTION_DATE] (6)> (Value \'0000-00-00\'>> can not be represented as> java.sql.Timestamp))>> (Error creating GenericValue> (SQL Exception>> while getting value :> introductionDate >> [INTRODUCTION_DATE] (6) (Value> \'0000-00-00\'>> can not be represented as>>> java.sql.Timestamp)))>>> [hidden email]>> wroteThe> first page of the Catalog Manager in>> the centerarea> at the bottom there is a link>> that says AutoCreate> Keywords for All Products.>> Did you try that?---> [hidden email]>> wrote:> Yes, have> changed the flag.But>> still getting> the>>> same>>[hidden email]&g
 t;>>> wroteWhen you create a product, you have to set>> to> Y> the flag \"autoCreateKeywords\" (in the>> edit> product> page).Jacopopuranisan>>> [hidden email] wrote:> I> am working in>>> ecommerce of opentaps8.3I created a> new store>> of> product_store_id=10000 and>>>> product_store_group_id=SandS.I cleared the data>>> in> the entity>>> \"product_store_keyword_ovrd\".When I> search>> for> a product say ss-100, I am getting the>>> result> \"No Results fo>> und\" for all products I have>> stored in>>> the>table>\"Product\"[hidden email]>>>> wroteMore details,>>>> [hidden email]>>> wrote:>> Hi,Keyword search is not working>> for> us.Could I> please get some tips in>> knowing what> are the tables> involved in&g
 t;> this.This is a> critical error.> > Thanks> inadvancePurani> > > > > ---------------------------------> Sneak preview the all-new Yahoo.com. It\'s not radically different. Just radically better.

[BJ Freeman]

are you using the UI to create products, in the first place?
from what you have shown, it looks like you are importing the product
information.


[hidden email] sent the following on 7/8/2006 4:38 AM:
> We are using the same search UI of opentaps-8.3We didn\'t do any modifications in [hidden email] wroteIt looks like you are importing data instead of using the UI.The UI has some safe guards built in.I suggest you use the UI then export the resultant data.dhilip kumar sent the following on 7/8/2006 4:11 AM:> I changed the introduction date.Then it asked for \"SalesDiscontinuationDate\" then for \"SupportDiscontinuationDate\",\"CreatedDate\", LastModifiedDate\".> I changed all the above values. The keyword creation for the products are done successfully.> But still I am not able to get results for searches.> I think it may be due to the wrong dates given for the above fields.> I don\'t understand what is \"SalesDiscontinuationDate\",\"SupportDiscontinuationDate\",\"CreatedDate\", LastModifiedDate\".> > Can you please give me some suggestions. Since my email id is not displaying the messages properly I am sending from this id
.&g
>  t; > > > > > > > > > gh of the log, prior to that error it> will tell what service was started and failed.> > 2) The issue is that Product.introductionDate is null.> For whatever reason, the service is needing a> complete primary key where Product.introductionDate is> not null. If you give your product an introduction> date in the format 2006-07-08 it will work> > 3) Can you please use a different email server? It\'s> escaping characters and not making them right before> they get sent. This makes it very dificult to read> your messages.> > --- [hidden email] wrote:> >> The following is the error from the log>>> :-------------------------------------------------------------------------------->> 266797[ >> RequestHandler.java:281:ERROR] Request>> UpdateAllKeywords caused an error with the following>> message: Error calling event:>> org.ofbiz.webapp
.ev
>  ent.EventHandlerException:>> Problems processing event:>> org.ofbiz.base.util.GeneralRuntimeException: Error>> creating GenericValue (SQL Exception while getting>> value : introductionDate [INTRODUCTION_DATE] (6)>> (Value \'0000-00-00\' can not be represented as>> java.sql.Timestamp)) (Error creating GenericValue>> (SQL Exception while getting value :>> introductionDate [INTRODUCTION_DATE] (6) (Value>> \'0000-00-00\' can not be represented as>> java.sql.Timestamp)))266797[ >> RequestHandler.java:372:INFO ]>> [RequestHandler.doRequest]: Response is a>> view.266797[ >> RequestHandler.java:524:INFO ] servletName=control,>> view=main266797[ >> PrimaryKeyFinder.java:132:INFO ] Returning null>> because found incomplete primary key in find:>> [GenericEntity:Product][productId,null()]266890[&n>> bsp; ServiceDispatcher.java:447:DEBUG] [[Sync>> service finishe
d-
>  total:0.0,since last(Begin):0.0]]>> - \'catalog />>> getProductCategoryAndLimitedMembers\'266906[ >> GenericDelegator.java:600:ERROR] ---- exception>> report>>> ----------------------------------------------------------Failure>> in create operation for entity [ServerHit]:>> org.ofbiz.entity.GenericEntityException: Exception>> while inserting the following entity:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL7
049
>  2148788(java.lang.String)][re>>> questUrl,https://localhost:8443/catalog/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Long)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)]>> (while inserting:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][partyId,admin(java.lang.String)][referrerUrl,https://localhost:8443/catalog/control/login?externalLoginKey=EL70492148788(java.lang.String)][requestUrl,https://localhost:8443/cat
alo
>  g/control/UpdateAllKeywords(java.lang.String)][runningTimeMillis,234(java.lang.Lon>>> g)][serverHostName,envisage1(java.lang.String)][serverIpAddress,192.168.1.9(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,13891(java.lang.String)]>> (SQL Exception while executing the following:INSERT>> INTO SERVER_HIT (VISIT_ID, CONTENT_ID,>> HIT_START_DATE_TIME, HIT_TYPE_ID,>> INTERNAL_CONTENT_ID, NUM_OF_BYTES,>> RUNNING_TIME_MILLIS, USER_LOGIN_ID, PARTY_ID,>> STATUS_ID, REQUEST_URL, REFERRER_URL,>> ID_BY_IP_CONTACT_MECH_ID,>> REF_BY_WEB_CONTACT_MECH_ID, SERVER_IP_ADDRESS,>> SERVER_HOST_NAME, LAST_UPDATED_STAMP,>> LAST_UPDATED_TX_STAMP, CREATED_STAMP,>> CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,>> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry>> \'REQUEST\' for key 2))). Rolling back>> transaction.Exception:>> org.ofbiz.entity.GenericEntityExceptionMessage:&
gt;
>  > Exception while inserting the following entity:>>> [GenericEntity:ServerHit][contentId,catalog.UpdateAllKeywords(java.lang.String)][createdStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][createdTxStamp,2006-07-08>> 15:52>>>>> :15.562(java.sql.Timestamp)][hitStartDateTime,2006-07-08> 15:52:15.328(java.sql.Timestamp)][hitTypeId,REQUEST(java.lang.String)][lastUpdatedStamp,2006-07-08> 15:52:15.562(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-08>> [hidden email] wroteIf>> I were to guess, your product doesn\'t have>> anintroduction date. I don\'t know why it would>> needthat date because you didn\'t post enough of the>> log.--- [hidden email] wrote:> I am>> getting the following error when tried>>> \"AutoCreateKeywordsForAllProducts\"> > Error>> calling event:>>> org.ofbiz.webapp.event.EventHandlerException:>>>
 Pr
>  oblems processing event:>>> org.ofbiz.base.util.GeneralRuntimeException:>> Error> creating GenericValue (SQL Exception while>> getting> value : introductionDate>> [INTRODUCTION_DATE] (6)> (Value \'0000-00-00\'>> can not be represented as> java.sql.Timestamp))>> (Error creating GenericValue> (SQL Exception>> while getting value :> introductionDate >> [INTRODUCTION_DATE] (6) (Value> \'0000-00-00\'>> can not be represented as>>> java.sql.Timestamp)))>>> [hidden email]>> wroteThe> first page of the Catalog Manager in>> the centerarea> at the bottom there is a link>> that says AutoCreate> Keywords for All Products.>> Did you try that?---> [hidden email]>> wrote:> Yes, have> changed the flag.But>> still getting> the>>> same>>[hidden email]
g&g
>  t;>>> wroteWhen you create a product, you have to set>> to> Y> the flag \"autoCreateKeywords\" (in the>> edit> product> page).Jacopopuranisan>>> [hidden email] wrote:> I> am working in>>> ecommerce of opentaps8.3I created a> new store>> of> product_store_id=10000 and>>>> product_store_group_id=SandS.I cleared the data>>> in> the entity>>> \"product_store_keyword_ovrd\".When I> search>> for> a product say ss-100, I am getting the>>> result> \"No Results fo>> und\" for all products I have>> stored in>>> the>table>\"Product\"[hidden email]>>>> wroteMore details,>>>> [hidden email]>>> wrote:>> Hi,Keyword search is not working>> for> us.Could I> please get some tips in>> knowing what> are the tables> involved i
n&g
>  t;> this.This is a> critical error.> > Thanks> inadvancePurani> > > > > ---------------------------------> Sneak preview the all-new Yahoo.com. It\'s not radically different. Just radically better.