Re: Error On Changing Order Status

[Harsha Chadhar]

It seems like you are violating unique key constraints.The orderStatusId 
is the primary key in OrderStatus entity i.e there has to be a unique 
entry corresponding to an orderStatusId, which is being violated here

Thanks and Regards
Harsha
Pal InfoCom Technologies wrote:
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