ofbiz-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anil K Patel (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (OFBIZ-2821) Error when clicking on shipment id from Sales Order
Date Sat, 16 Aug 2014 13:42:19 GMT

     [ https://issues.apache.org/jira/browse/OFBIZ-2821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Anil K Patel closed OFBIZ-2821.
-------------------------------


> Error when clicking on shipment id from Sales Order
> ---------------------------------------------------
>
>                 Key: OFBIZ-2821
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2821
>             Project: OFBiz
>          Issue Type: Bug
>          Components: product
>    Affects Versions: Release Branch 09.04, Trunk
>            Reporter: Vince Clark
>            Assignee: Anil K Patel
>         Attachments: OFBIZ-2821.patch
>
>
> Copied and pasted from thread on ML. Note that the error occurs anywhere that you click
on a shipment link, not just from an order.
> Original post be Eva Bowman
> Hello all,
> I get the error below when I click on the shipment id link from Sales Order. Is this
a bug?
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://product/widget/facility/ShipmentScreens.xml#ViewShipment]:
org.ofbiz.base.util.GeneralException: Error running Groovy script at location [component://product/webapp/facility/WEB-INF/actions/shipment/EditShipmentRouteSegments.groovy]
(SQL Exception while executing the following:SELECT SVC.STATUS_ID, SVC.STATUS_ID_TO, SVC.CONDITION_EXPRESSION,
SVC.TRANSITION_NAME, SI.STATUS_TYPE_ID, SI.STATUS_CODE, SI.SEQUENCE_ID, SI.DESCRIPTION FROM
dbo.STATUS_VALID_CHANGE SVC INNER JOIN dbo.STATUS_ITEM SI ON SVC.STATUS_ID_TO = SI.STATUS_ID
WHERE (SVC.STATUS_ID = ?) ORDER BY SI.SEQUENCE_ID ASC, SI.SEQUENCE_ID ASC (A column has been
specified more than once in the order by list. Columns in the order by list must be unique.))
(Error running Groovy script at location [component://product/webapp/facility/WEB-INF/actions/shipment/EditShipmentRouteSegments.groovy]
(SQL Exception while executing the following:SELECT SVC.STATUS_ID, SVC.STATUS_ID_TO, SVC.CONDITION_EXPRESSION,
SVC.TRANSITION_NAME, SI.STATUS_TYPE_ID, SI.STATUS_CODE, SI.SEQUENCE_ID, SI.DESCRIPTION FROM
dbo.STATUS_VALID_CHANGE SVC INNER JOIN dbo.STATUS_ITEM SI ON SVC.STATUS_ID_TO = SI.STATUS_ID
WHERE (SVC.STATUS_ID = ?) ORDER BY SI.SEQUENCE_ID ASC, SI.SEQUENCE_ID ASC (A column has been
specified more than once in the order by list. Columns in the order by list must be unique.)))
> Response by Scott Gray:
> Hi Eva
> Yes it is a bug although not reproducible OOTB because derby doesn't  
> complain about order by items not being unique.  The problem occurs  
> because the view entity is adding sequenceId to the order by list and  
> then the actual delegator call also passes in the same order by,  
> causing the duplication.
> Three possible solutions:
> 1. Remove the order by from the view entity
> 2. Remove the order by from any code querying the view entity (there  
> are quite a few)
> 3. Enhance the OrderByList class to throw out any duplicate  
> OrderByItem objects
> I'm thinking 2 and 3 combined is probably the best solution.  If you  
> have time could please create a jira issue for the bug?
> Many thanks
> Scott 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message