You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@apache.org> on 2006/12/08 12:17:22 UTC
[jira] Closed: (OFBIZ-290) Replacement of return items order does
not work
[ 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