Posted by
puranisank on
Jul 08, 2006; 11:25am
URL: http://ofbiz.116.s1.nabble.com/Re-Re-Keyword-search-is-not-working-tp140593.html
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