Hello,
I am working with Ofbiz, i have created some orders from ecommerce site, but when i try to change status of these orders i get following error:- The Following Errors Occurred: ERROR : Could not change order status (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Failure in create operation for entity [OrderStatus]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OrderStatus][createdStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][createdTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][lastUpdatedStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][orderId,WSCO10508(java.lang.String)][orderStatusId,11240(java.lang.String)][statusDatetime,2009-01-13 07:13:11.114(java.sql.Timestamp)][statusId,ORDER_APPROVED(java.lang.String)][statusUserLogin,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ORDER_STATUS (ORDER_STATUS_ID, STATUS_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, ORDER_PAYMENT_PREFERENCE_ID, STATUS_DATETIME, STATUS_USER_LOGIN, CHANGE_REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (null, message from server: "Duplicate entry '11240' for key 1")). Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:OrderStatus][createdStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][createdTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][lastUpdatedStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][orderId,WSCO10508(java.lang.String)][orderStatusId,11240(java.lang.String)][statusDatetime,2009-01-13 07:13:11.114(java.sql.Timestamp)][statusId,ORDER_APPROVED(java.lang.String)][statusUserLogin,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ORDER_STATUS (ORDER_STATUS_ID, STATUS_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, ORDER_PAYMENT_PREFERENCE_ID, STATUS_DATETIME, STATUS_USER_LOGIN, CHANGE_REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (null, message from server: "Duplicate entry '11240' for key 1")) (Error while inserting: [GenericEntity:OrderStatus][createdStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][createdTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][lastUpdatedStamp,2009-01-13 07:13:11.133(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-13 07:13:10.77(java.sql.Timestamp)][orderId,WSCO10508(java.lang.String)][orderStatusId,11240(java.lang.String)][statusDatetime,2009-01-13 07:13:11.114(java.sql.Timestamp)][statusId,ORDER_APPROVED(java.lang.String)][statusUserLogin,admin(java.lang.String)] (SQL Exception while executing the following:INSERT INTO ORDER_STATUS (ORDER_STATUS_ID, STATUS_ID, ORDER_ID, ORDER_ITEM_SEQ_ID, ORDER_PAYMENT_PREFERENCE_ID, STATUS_DATETIME, STATUS_USER_LOGIN, CHANGE_REASON, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (null, message from server: "Duplicate entry '11240' for key 1")))). Please advise me how to solve this problem. Thanks Harkomal -- View this message in context: http://www.nabble.com/Error-On-Changing-Order-Status-tp21435636p21435636.html Sent from the OFBiz - User mailing list archive at Nabble.com.
