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.
