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

Reply via email to