[jira] Created: (OFBIZ-2733) search in PROMOTIONS category causes ScreenRenderException

[Nicolas Malin (Jira)]

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: yt


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.