You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2010/12/28 12:38:45 UTC
[jira] Closed: (OFBIZ-2733) search in PROMOTIONS category causes
ScreenRenderException
[ 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.