Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
Trunk
-
None
-
None
Description
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] :
: (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.