You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Pal InfoCom Technologies <of...@palinfocom.net> on 2009/01/13 14:19:02 UTC
Error On Changing Order Status
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.
Re: Error On Changing Order Status
Posted by Harsha Chadhar <ha...@hotwaxmedia.com>.
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
>
Re: Error On Changing Order Status
Posted by David E Jones <da...@hotwaxmedia.com>.
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.
>