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 [EMAIL
PROTECTED] 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.--- [EMAIL PROTECTED] 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)))> [EMAIL PROTECTED] 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?---> [EMAIL
PROTECTED] wrote:> Yes, have> changed the flag.But still
getting> the same>>[EMAIL PROTECTED]>> wroteWhen you create a
product, you have to set to> Y> the flag \"autoCreateKeywords\" (in the
edit> product> page).Jacopopuranisan> [EMAIL PROTECTED] 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\"[EMAIL PROTECTED]>> wroteMore details,>>
[EMAIL PROTECTED]> 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
