OFBiz › OFBiz - User

Re :Re: Keyword search is not working

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 2 messages Options
puranisank
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re :Re: Keyword search is not working

puranisank
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.event.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=EL70492148788(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/catalog/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:> 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)))> [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]>> 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 this.This is a> critical error.Thanks inadvancePurani
cjhowe
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Re :Re: Keyword search is not working

cjhowe
Three things

1)Again, not enough 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.event.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=EL70492148788(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/catalog/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:>
> 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)))>
> [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]>>

> 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
> this.This is a> critical error.Thanks
inadvancePurani

Free forum by Nabble Edit this page