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 |
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 > |
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. > |
Free forum by Nabble | Edit this page |