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 2008/09/03 08:29:44 UTC
[jira] Commented: (OFBIZ-1944) Errors listing entity in Webtools
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12627916#action_12627916 ]
Jacques Le Roux commented on OFBIZ-1944:
----------------------------------------
The error is related to Payment.effectiveDate field and begins in FindGeneric.run(FindGeneric.groovy:146
My 2 cents
> Errors listing entity in Webtools
> ---------------------------------
>
> Key: OFBIZ-1944
> URL: https://issues.apache.org/jira/browse/OFBIZ-1944
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: SVN trunk rev. 691020
> Reporter: Bruno Busco
>
> There are several runtime errors when accessing to the following links:
> https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=InventoryItemDetailForSum&find=true&VIEW_SIZE=50&VIEW_INDEX=0
> https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=InvoiceItemProductSummary&find=true&VIEW_SIZE=50&VIEW_INDEX=0
> https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=InvoiceItemCategorySummary&find=true&VIEW_SIZE=50&VIEW_INDEX=0
> The error is like this:
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://webtools/widget/EntityScreens.xml#FindGeneric]: org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.groovy] (SQL Exception while executing the following:SELECT SUM(IID.QUANTITY_ON_HAND_DIFF), II.INVENTORY_ITEM_TYPE_ID, II.FACILITY_ID, II.PRODUCT_ID, IID.EFFECTIVE_DATE FROM OFBIZ.INVENTORY_ITEM II INNER JOIN OFBIZ.INVENTORY_ITEM_DETAIL IID ON II.INVENTORY_ITEM_ID = IID.INVENTORY_ITEM_ID GROUP BY II.INVENTORY_ITEM_TYPE_ID, II.FACILITY_ID, II.PRODUCT_ID (The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions. )) (Error running Groovy script at location [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.groovy] (SQL Exception while executing the following:SELECT SUM(IID.QUANTITY_ON_HAND_DIFF), II.INVENTORY_ITEM_TYPE_ID, II.FACILITY_ID, II.PRODUCT_ID, IID.EFFECTIVE_DATE FROM OFBIZ.INVENTORY_ITEM II INNER JOIN OFBIZ.INVENTORY_ITEM_DETAIL IID ON II.INVENTORY_ITEM_ID = IID.INVENTORY_ITEM_ID GROUP BY II.INVENTORY_ITEM_TYPE_ID, II.FACILITY_ID, II.PRODUCT_ID (The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions. )))
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.