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.
