[
https://issues.apache.org/jira/browse/OFBIZ-2733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-2733.
----------------------------------
Resolution: Cannot Reproduce
Fix Version/s: SVN trunk
Assignee: Jacques Le Roux
I cannot reproduce, this has certainly be fixed recently
> search in PROMOTIONS category causes ScreenRenderException
> ----------------------------------------------------------
>
> Key: OFBIZ-2733
> URL: https://issues.apache.org/jira/browse/OFBIZ-2733
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Environment: ofbiz running on opensuse 11.1
> Reporter: Wai Tam
> Assignee: Jacques Le Roux
> Fix For: SVN trunk
>
>
> when viewing PROMOTIONS category under "Demo Catalog". Click on "Search in
> Category" and commence a search for the PROMOTIONS category. An exception
> occurs.
> (note: I did not enter any values for the search. I just clicked on the
> "find" button.
> :ERROR MESSAGE:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen
> [component://product/widget/catalog/FindScreens.xml#keywordsearch]:
> org.ofbiz.base.util.GeneralException: Error running Groovy script at location
> [component://product/webapp/catalog/WEB-INF/actions/find/keywordsearch.groovy]
> (The current transaction is marked for rollback, not beginning a new
> transaction and aborting current operation; the rollbackOnly was caused by:
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))) (Error running
> Groovy script at location
> [component://product/webapp/catalog/WEB-INF/actions/find/keywordsearch.groovy]
> (The current transaction is marked for rollback, not beginning a new
> transaction and aborting current operation; the rollbackOnly was caused by:
> Failure in create operation for entity [ProductSearchResult]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))) (Error while
> inserting: [GenericEntity:ProductSearchResult][createdStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][createdTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][isAscending,N(java.lang.String)][lastUpdatedStamp,2009-07-15
> 16:33:13.417(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-15
> 16:33:13.334(java.sql.Timestamp)][numResults,9(java.lang.Long)][orderByName,KeywordRelevancy(java.lang.String)][productSearchResultId,10017(java.lang.String)][searchDate,2009-07-15
>
> 16:33:13.411(java.sql.Timestamp)][secondsTotal,0.0060(java.lang.Double)][visitId,10201(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> PRODUCT_SEARCH_RESULT (PRODUCT_SEARCH_RESULT_ID, VISIT_ID, ORDER_BY_NAME,
> IS_ASCENDING, NUM_RESULTS, SECONDS_TOTAL, SEARCH_DATE, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key
> constraint fails (`ofbiz/PRODUCT_SEARCH_RESULT`, CONSTRAINT `PROD_SCHRES_VST`
> FOREIGN KEY (`VISIT_ID`) REFERENCES `VISIT` (`VISIT_ID`)))))))
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
