Re :Re: Re :Re: Keyword search is not working
Locked
Re :Re: Re :Re: Keyword search is not working
 
|
The following is the exact error I am getting while trying to search a product
Error in product search Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '=') ---- stack trace --------------------------------------------------------------- org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '=') org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:407) org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:837) org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:173) org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1987) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:314) org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:185) org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:590) Thanks Purani 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.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 / > > 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: > > 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 > > 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 > > 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 --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs.Try it free. |
|
|
Need to validate the data that was put in. the Shorter way to get the
best results is to use the UI. it looks like, for previous post you imported data instead of using the UI to created products. I suggest you use the UI to create your products then test the keywords. dhilip kumar sent the following on 7/8/2006 4:36 AM: > The following is the exact error I am getting while trying to search a product > > > Error in product search > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '=') > ---- stack trace --------------------------------------------------------------- > org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation '=') > org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:407) > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:837) > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:173) > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1987) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:314) > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:185) > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:590) > > > > Thanks > Purani > > > > > > > > > > > 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.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 > > > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs.Try it free. |
|
|
In reply to this post by dhilip kumar
A tip for future debugging. Google is your friend.
When you see something that's strange in your log error, take the part that doesn't look to be containing any variables and do a google search. The pecurliar part of this error is: Illegal mix of collations and then it talks about differences in languages stuff. Doing a Google search on "Illegal mix of collations" returns this gem of a solution among some other mysql issues with explaining the whys of it all: https://www.plainblack.com/etcetera/dbdmysqlst-execute-failed-illegal-mix-of-collations/3 --- dhilip kumar <[hidden email]> wrote: > The following is the exact error I am getting > while trying to search a product > > > Error in product search > Exception: > org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception while executing the > following:SELECT DISTINCT SUM(PK1.RELEVANCY_WEIGHT) > AS TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID > FROM PRODUCT PROD LEFT OUTER JOIN > PRODUCT_CALCULATED_INFO PRODCI ON PROD.PRODUCT_ID = > PRODCI.PRODUCT_ID INNER JOIN PRODUCT_KEYWORD PK1 ON > PROD.PRODUCT_ID = PK1.PRODUCT_ID WHERE ((PK1.KEYWORD > LIKE ? OR PK1.KEYWORD LIKE ?)) GROUP BY > PROD.PRODUCT_ID ORDER BY TOTAL_RELEVANCY DESC > (Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and > (latin1_general_cs,IMPLICIT) for operation '=') > ---- stack trace > > org.ofbiz.entity.GenericDataSourceException: SQL > Exception while executing the following:SELECT > DISTINCT SUM(PK1.RELEVANCY_WEIGHT) AS > TOTAL_RELEVANCY, PROD.PRODUCT_ID AS PRODUCT_ID FROM > PRODUCT PROD LEFT OUTER JOIN PRODUCT_CALCULATED_INFO > PRODCI ON PROD.PRODUCT_ID = PRODCI.PRODUCT_ID INNER > JOIN PRODUCT_KEYWORD PK1 ON PROD.PRODUCT_ID = > PK1.PRODUCT_ID WHERE ((PK1.KEYWORD LIKE ? OR > PK1.KEYWORD LIKE ?)) GROUP BY PROD.PRODUCT_ID ORDER > BY TOTAL_RELEVANCY DESC (Illegal mix of collations > (latin1_swedish_ci,IMPLICIT) and > (latin1_general_cs,IMPLICIT) for operation '=') > > > > org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:837) > > org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:173) > > org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegator.java:1987) > > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doQuery(ProductSearch.java:314) > > org.ofbiz.product.product.ProductSearch$ProductSearchContext.doSearch(ProductSearch.java:185) > > org.ofbiz.product.product.ProductSearchSession.getProductSearchResult(ProductSearchSession.java:590) > > > > Thanks > Purani > > > > > > > > > > > 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.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 > > > > > 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: > > > > > > 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 > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |