[jira] Created: (OFBIZ-1944) Errors listing entity in Webtools
Locked
[jira] Created: (OFBIZ-1944) Errors listing entity in Webtools
 
|
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. |
[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. |
[jira] Assigned: (OFBIZ-1944) Errors listing entity in Webtools
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Risaliti reassigned OFBIZ-1944: ------------------------------------- Assignee: Marco Risaliti > 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 > Assignee: Marco Risaliti > > 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. |
[jira] Updated: (OFBIZ-1944) Errors listing entity in Webtools
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Risaliti updated OFBIZ-1944: ---------------------------------- Attachment: FindGeneric.groovy This is an update of FindGeneric.groovy to solve the issue on view entity. I will provide a update as soon as I can. Thanks Marco > 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 > Assignee: Marco Risaliti > Attachments: FindGeneric.groovy > > > 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. |
[jira] Assigned: (OFBIZ-1944) Errors listing entity in Webtools
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Risaliti reassigned OFBIZ-1944: ------------------------------------- Assignee: (was: Marco Risaliti) > 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 > Attachments: FindGeneric.groovy, FindGeneric.patch > > > 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. |
[jira] Updated: (OFBIZ-1944) Errors listing entity in Webtools
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marco Risaliti updated OFBIZ-1944: ---------------------------------- Attachment: FindGeneric.patch Updated patch that can solve this issue. Can a framework committer take a look at this patch ? Thanks Marco > 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 > Assignee: Marco Risaliti > Attachments: FindGeneric.groovy, FindGeneric.patch > > > 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. |
[jira] Closed: (OFBIZ-1944) Errors listing entity in Webtools
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-1944. ---------------------------------- Resolution: Fixed Fix Version/s: SVN trunk Assignee: Jacques Le Roux Thanks Marco, A simplified version or your patch is committed in revision 708036. I used for loops instead of iterators. > 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 > Assignee: Jacques Le Roux > Fix For: SVN trunk > > Attachments: FindGeneric.groovy, FindGeneric.patch > > > 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. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |