[ http://issues.apache.org/jira/browse/OFBIZ-290?page=all ]
Jacopo Cappellato closed OFBIZ-290.
-----------------------------------
Resolution: Fixed
I recently fixed this issue.
> Replacement of return items order does not work
> -----------------------------------------------
>
> Key: OFBIZ-290
> URL: http://issues.apache.org/jira/browse/OFBIZ-290
> Project: OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: order
> Affects Versions: SVN trunk
> Reporter: Marco Risaliti
> Priority: Minor
>
> It's a copy of the old-jira issue
> http://jira.undersunconsulting.com/browse/OFBIZ-678 from Si Chen.
> ==============================================
> When creating a return for return items of type "REPLACEMENT", we get this
> error:
> org.ofbiz.webapp.event.EventHandlerException: Service invocation error
> (Problems with the transaction: The current transaction is marked for
> rollback, not beginning a new transaction and aborting current operation; the
> rollbackOnly was caused by: Service [storeOrder] threw an unexpected
> exception/errororg.ofbiz.service.ServiceValidationException: The following
> required parameter is missing: orderTerms
> (The following required parameter is missing: orderTerms
> ); See logs for more detail)
> Digging into the log a little deeper we find:
> 15640199 (http-0.0.0.0-8443-Processor1) [ ServiceEcaRule.java:134:INFO ]
> Running Service ECA Service: processReplacementReturn, triggered by rule on
> Service: updateReturnHeader
> 15640252 (http-0.0.0.0-8443-Processor1) [OrderReturnServices.java:914:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Exception: org.ofbiz.entity.GenericModelException
> Message: Could not find relation for relationName: OrderShipmentPreference
> for value
> [GenericEntity:OrderHeader][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2006-01-19
> 10:26:54.42(java.sql.Timestamp)][createdTxStamp,2006-01-19
> 10:26:53.82(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2006-01-19
>
> 10:26:54.075(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,3349.25(java.lang.Double)][internalCode,null()][isRushOrder,null()][lastUpdatedStamp,2006-01-19
> 10:28:33.97(java.sql.Timestamp)][lastUpdatedTxStamp,2006-01-19
> 10:28:28.36(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2006-01-19
>
> 10:26:54.075(java.sql.Timestamp)][orderId,WS10021(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][productStoreId,9000(java.lang.String)][remainingSubTotal,3067.16(java.lang.Double)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,10036(java.lang.String)][webSiteId,OrderEntry(java.lang.String)]
>
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.entity.GenericModelException: Could not find relation for
> relationName: OrderShipmentPreference for value
> [GenericEntity:OrderHeader][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2006-01-19
> 10:26:54.42(java.sql.Timestamp)][createdTxStamp,2006-01-19
> 10:26:53.82(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2006-01-19
>
> 10:26:54.075(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,3349.25(java.lang.Double)][internalCode,null()][isRushOrder,null()][lastUpdatedStamp,2006-01-19
> 10:28:33.97(java.sql.Timestamp)][lastUpdatedTxStamp,2006-01-19
> 10:28:28.36(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2006-01-19
>
> 10:26:54.075(java.sql.Timestamp)][orderId,WS10021(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][productStoreId,9000(java.lang.String)][remainingSubTotal,3067.16(java.lang.Double)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,10036(java.lang.String)][webSiteId,OrderEntry(java.lang.String)]
>
> org.ofbiz.entity.GenericDelegator.getRelated(GenericDelegator.java:2010)
> org.ofbiz.entity.GenericDelegator.getRelated(GenericDelegator.java:1967)
> org.ofbiz.entity.GenericValue.getRelated(GenericValue.java:166)
> org.ofbiz.order.order.OrderReturnServices.processReplacementReturn(OrderReturnServices.java:912)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
> org.ofbiz.service.engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.java:101)
>
> org.ofbiz.service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:63)
>
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:339)
> and:
> 15640256 (http-0.0.0.0-8443-Processor1) [ ModelService.java:401:ERROR]
> [ModelService.validate] : {storeOrder} : (IN) Required test error:
> org.ofbiz.service.ServiceValidationException: The following required
> parameter is missing: orderTerms
> 15640260 (http-0.0.0.0-8443-Processor1) [ ServiceDispatcher.java:325:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Incoming context (in runSync : storeOrder) does not match expected
> requirements
> Exception: org.ofbiz.service.ServiceValidationException
> Message: The following required parameter is missing: orderTerms
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.ServiceValidationException: The following required
> parameter is missing: orderTerms
> org.ofbiz.service.ModelService.validate(ModelService.java:440)
> org.ofbiz.service.ModelService.validate(ModelService.java:398)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:323)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:213)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:110)
> org.ofbiz.order.order.OrderReturnServices.processReplacementReturn(OrderReturnServices.java:982)
>
> and:
> 15640323 (http-0.0.0.0-8443-Processor1) [ TransactionUtil.java:286:INFO ]
> [TransactionUtil.setRollbackOnly] transaction rollback only not set, rollback
> only is already set.
> 15640325 (http-0.0.0.0-8443-Processor1) [ ServiceDispatcher.java:407:ERROR]
> Service Error [updateReturnStatusFromReceipt]: ERROR: Could not complete the
> Update Return Status From ShipmentReceipt
> [file:/home/si/eclipse/workspace/ofbiz/applications/order/script/org/ofbiz/order/order/OrderReturnServices.xml#updateReturnStatusFromReceipt]
> process [problem invoking the [updateReturnHeader] service with the map
> named [returnHeaderCtx] containing [[statusId=RETURN_RECEIVED,
> returnId=10015, userLogin=[GenericEntity:UserLogin][createdStamp,2006-01-18
> 09:38:04.268(java.sql.Timestamp)][createdTxStamp,2006-01-18
> 09:38:03.557(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,null()][hasLoggedOut,null()][isSystem,null()][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2006-01-18
> 09:38:04.541(java.sql.Timestamp)][lastUpdatedTxStamp,2006-01-18
> 09:38:04.342(java.sql.Timestamp)][partyId,admin(java.lang.String)][passwordHint,null()][successiveFailedLogins,null()][userLoginId,admin(java.lang.String)],
> locale=en_US]]: Problems with the transaction. (The following required
> parameter is missing: orderTerms
> )]
>
>
> All Comments Work Log Change History Sort Order:
> Comment by Si Chen [03/Feb/06 06:21 PM] [ Permlink ]
> Fixed the first problem SVN r 6674. Looks like second one is due to this code
> not being brought up to date with new ship groups. So I guess nobody is using
> this right now....
> Comment by Marco Risaliti [06/Sep/06 04:55 PM] [ Permlink ]
> Is this still an issue or this can be closed ?
> Thanks
> Marco
> Comment by Si Chen [07/Sep/06 11:41 AM] [ Permlink ]
> I'm not aware that it's been fixed. Have you tried to create a replacement
> order on a return? What happens?
> Comment by Marco Risaliti [07/Sep/06 06:42 PM] [ Permlink ]
> Hi Si,
> I have tried it and now seems there are still errors for replacement :
> org.ofbiz.webapp.event.EventHandlerException: Service invocation error
> (Problems with the transaction: The current transaction is marked for
> rollback, not beginning a new transaction and aborting current operation; the
> rollbackOnly was caused by: Service Error [processRefundReturn]: Unable to
> refund order #WS10081; there are no available payment preferences.; See logs
> for more detail)
> Thanks
> Marco
> Comment by Marco Risaliti [07/Sep/06 06:44 PM] [ Permlink ]
> This is part of the log :
> 2006-09-08 01:40:42,332 (http-0.0.0.0-8443-Processor1) [
> TransactionUtil.java:278:INFO ] [TransactionUtil.setRollbackOnly] transaction
> rollback only not set, rollback only is already set.
> 2006-09-08 01:40:42,332 (http-0.0.0.0-8443-Processor1) [
> ServiceDispatcher.java:410:ERROR] Service Error [quickReceiveReturn]: ERROR:
> Could not complete the Quick Receive Entire Return
> [file:/C:/ofbiz_new/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#quickReceiveReturn]
> process [problem invoking the [receiveInventoryProduct] service with the map
> named [receiveCtx] containing [[unitCost=0.0,
> inventoryItemTypeId=NON_SERIAL_INV_ITEM, statusId=INV_RETURNED,
> productId=GZ-1004, returnItemSeqId=00001, returnId=10002,
> quantityAccepted=1.0, facilityId=WebStoreWarehouse, shipmentId=10045,
> comments=Returned Item RA# 10002, datetimeReceived=2006-09-08 01:40:40.85,
> quantityRejected=0.0,
> userLogin=[GenericEntity:UserLogin][createdStamp,2006-07-09
> 15:34:09.743(java.sql.Timestamp)][createdTxStamp,2006-07-09
> 15:34:09.432(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,N(java.lang.String)][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2006-07-09
> 15:34:34.462(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-09
> 15:34:34.308(java.sql.Timestamp)][partyId,null()][passwordHint,Do Not Enable
> This
> Account(java.lang.String)][successiveFailedLogins,null()][userLoginId,system(java.lang.String)],
> locale=it_IT]]: Problems with the transaction. (The current transaction is
> marked for rollback, not beginning a new transaction and aborting current
> operation; the rollbackOnly was caused by: Service Error
> [processRefundReturn]: Unable to refund order #WS10081; there are no
> available payment preferences.)]
> 2006-09-08 01:40:42,332 (http-0.0.0.0-8443-Processor1) [
> TransactionUtil.java:278:INFO ] [TransactionUtil.setRollbackOnly] transaction
> rollback only not set, rollback only is already set.
> 2006-09-08 01:40:42,332 (http-0.0.0.0-8443-Processor1) [
> ServiceDispatcher.java:450:DEBUG] [[Sync service finished- total:2.343,since
> last(Begin):2.343]] - 'entity-default / quickReceiveReturn'
> 2006-09-08 01:40:42,332 (http-0.0.0.0-8443-Processor1) [
> EntityEcaAction.java:113:ERROR]
> ---- exception report
> ----------------------------------------------------------
> Error running Entity ECA action service
> Exception: org.ofbiz.service.GenericServiceException
> Message: Error running Entity ECA action service: ERROR: Could not complete
> the Quick Receive Entire Return
> [file:/C:/ofbiz_new/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#quickReceiveReturn]
> process [problem invoking the [receiveInventoryProduct] service with the map
> named [receiveCtx] containing [[unitCost=0.0,
> inventoryItemTypeId=NON_SERIAL_INV_ITEM, statusId=INV_RETURNED,
> productId=GZ-1004, returnItemSeqId=00001, returnId=10002,
> quantityAccepted=1.0, facilityId=WebStoreWarehouse, shipmentId=10045,
> comments=Returned Item RA# 10002, datetimeReceived=2006-09-08 01:40:40.85,
> quantityRejected=0.0,
> userLogin=[GenericEntity:UserLogin][createdStamp,2006-07-09
> 15:34:09.743(java.sql.Timestamp)][createdTxStamp,2006-07-09
> 15:34:09.432(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,N(java.lang.String)][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2006-07-09
> 15:34:34.462(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-09
> 15:34:34.308(java.sql.Timestamp)][partyId,null()][passwordHint,Do Not Enable
> This
> Account(java.lang.String)][successiveFailedLogins,null()][userLoginId,system(java.lang.String)],
> locale=it_IT]]: Problems with the transaction. (The current transaction is
> marked for rollback, not beginning a new transaction and aborting current
> operation; the rollbackOnly was caused by: Service Error
> [processRefundReturn]: Unable to refund order #WS10081; there are no
> available payment preferences.)]
> ---- stack trace
> ---------------------------------------------------------------
> org.ofbiz.service.GenericServiceException: Error running Entity ECA action
> service: ERROR: Could not complete the Quick Receive Entire Return
> [file:/C:/ofbiz_new/applications/product/script/org/ofbiz/shipment/receipt/ShipmentReceiptServices.xml#quickReceiveReturn]
> process [problem invoking the [receiveInventoryProduct] service with the map
> named [receiveCtx] containing [[unitCost=0.0,
> inventoryItemTypeId=NON_SERIAL_INV_ITEM, statusId=INV_RETURNED,
> productId=GZ-1004, returnItemSeqId=00001, returnId=10002,
> quantityAccepted=1.0, facilityId=WebStoreWarehouse, shipmentId=10045,
> comments=Returned Item RA# 10002, datetimeReceived=2006-09-08 01:40:40.85,
> quantityRejected=0.0,
> userLogin=[GenericEntity:UserLogin][createdStamp,2006-07-09
> 15:34:09.743(java.sql.Timestamp)][createdTxStamp,2006-07-09
> 15:34:09.432(java.sql.Timestamp)][currentPassword,47ca69ebb4bdc9ae0adec130880165d2cc05db1a(java.lang.String)][disabledDateTime,null()][enabled,N(java.lang.String)][hasLoggedOut,null()][isSystem,Y(java.lang.String)][lastCurrencyUom,null()][lastLocale,null()][lastUpdatedStamp,2006-07-09
> 15:34:34.462(java.sql.Timestamp)][lastUpdatedTxStamp,2006-07-09
> 15:34:34.308(java.sql.Timestamp)][partyId,null()][passwordHint,Do Not Enable
> This
> Account(java.lang.String)][successiveFailedLogins,null()][userLoginId,system(java.lang.String)],
> locale=it_IT]]: Problems with the transaction. (The current transaction is
> marked for rollback, not beginning a new transaction and aborting current
> operation; the rollbackOnly was caused by: Service Error
> [processRefundReturn]: Unable to refund order #WS10081; there are no
> available payment preferences.)]
> Comment by Si Chen [07/Sep/06 06:50 PM] [ Permlink ]
> Can you create an order which was ordered with a credit card? This error is a
> different one.
> Comment by Marco Risaliti [09/Sep/06 05:28 PM] [ Permlink ]
> Hi Si,
> I have tried to do a replacement of a new order paid with the credit card and
> it's seems to work without errors.
> I don't know what to do.
> Did you prefer to leave open this issue ?
> Thanks
> Marco
> It's a copy of the old-jira issue OFBIZ-678.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
