Error On Changing Order Status

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Error On Changing Order Status

Pal Infocom Technologies-2

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
Reply | Threaded
Open this post in threaded view
|

Re: Error On Changing Order Status

Harsha Chadhar-3
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
>  

Reply | Threaded
Open this post in threaded view
|

Re: Error On Changing Order Status

David E Jones-3
In reply to this post by Pal Infocom Technologies-2

Some standard info that might be helpful (that should be included with  
ALL questions like this):

1. which version or revision of OFBiz are you using

2. which page, form, etc did you use that resulted in this error

3. can you reproduce it on demo.hotwaxmedia.com? if so, please include  
steps

This is the 2nd time I've seen this error reported in the last couple  
of days, but with no details it is hard to comment on it or reproduce  
it.

-David


On Jan 13, 2009, at 5:19 AM, 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
> --
> 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.
>