You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Todd Burdeinei <tb...@gmail.com> on 2009/01/12 17:52:31 UTC
Sql exception when trying to approve order through order manager
Hello Everyone,
I'm getting the following error when I click "Approve Order" in the Order
Manager Application. This happens with any order in the system.
I have searched nabble and not found any mention of this issue earlier.
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-12
10:47:23.428(java.sql.Timestamp)][createdTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][lastUpdatedStamp,2009-01-12
10:47:23.428(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][orderId,WSCO10751(java.lang.String)][orderStatusId,11152(java.lang.String)][statusDatetime,2009-01-12
10:47:21.894(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 '11152' for key 1")). Rolling back
transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:OrderStatus][createdStamp,2009-01-12
10:47:23.428(java.sql.Timestamp)][createdTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][lastUpdatedStamp,2009-01-12
10:47:23.428(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][orderId,WSCO10751(java.lang.String)][orderStatusId,11152(java.lang.String)][statusDatetime,2009-01-12
10:47:21.894(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 '11152' for key 1")) (Error while inserting:
[GenericEntity:OrderStatus][createdStamp,2009-01-12
10:47:23.428(java.sql.Timestamp)][createdTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][lastUpdatedStamp,2009-01-12
10:47:23.428(java.sql.Timestamp)][lastUpdatedTxStamp,2009-01-12
10:47:21.62(java.sql.Timestamp)][orderId,WSCO10751(java.lang.String)][orderStatusId,11152(java.lang.String)][statusDatetime,2009-01-12
10:47:21.894(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 '11152' for key 1")))).
--
Todd Burdeinei
Web Developer
Burdeinei Corp
702-259-3273 office / fax number
702-372-9920 cell
Todd@burdeinei.com