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.
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.
--- [EMAIL PROTECTED] 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
[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
---------------------------------
Sneak preview the all-new Yahoo.com. It's not radically different. Just radically better.
