Re: Error when clicking on shipment id from Sales Order

[Scott Gray]

Hi Eva




Three possible solutions:
1. Remove the order by from the view entity




Many thanks
Scott

HotWax Media
http://www.hotwaxmedia.com

On 23/07/2009, at 9:45 AM, Eva Bowman wrote:

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. 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?

Hello all,


Is this a bug?

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen

org.ofbiz.base.util.GeneralException: Error running Groovy script at
location

(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

than once in the order by list. Columns in the order by list must be
unique.)) (Error running Groovy script at location

(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

than once in the order by list. Columns in the order by list must be
unique.)))
--
View this message in context: 
http://www.nabble.com/Error-when-clicking-on-shipment-id-from-Sales-Order-tp24615025p24615025.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

I get the error below when I click on the shipment id link from Sales Order. [component://product/widget/facility/ ShipmentScreens.xml#ViewShipment]: [component://product/webapp/facility/WEB-INF/actions/shipment/ EditShipmentRouteSegments.groovy] SI.SEQUENCE_ID ASC, SI.SEQUENCE_ID ASC (A column has been specified more [component://product/webapp/facility/WEB-INF/actions/shipment/ EditShipmentRouteSegments.groovy] SI.SEQUENCE_ID ASC, SI.SEQUENCE_ID ASC (A column has been specified more

smime.p7s
Description: S/MIME cryptographic signature