Re: Problem creating order

[Scott Gray]

The only time I usually see that is when there was a problem during order processing and the order gets created but it still bounces you back to the submit order page and then you attempt to submit the order again which results in the duplicate primary key problem. I think it is a bug but it couldn't be fixed without knowing what the original problem was.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 8/10/2009, at 4:19 AM, Alexander wrote:

Hi all,

I get the following when submitting an order:

er.java:785)




sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

a:25)
java.lang.reflect.Method.invoke(Method.java:597)

org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

erChain.java:290)

java:206)

erChain.java:235)

java:206)

33)

75)

)

otocol.java:583)

java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------



R]


Cannot create OrderHeader entity; problems with insert
Exception: org.ofbiz.entity.GenericEntityException

DER_HEADER'.))


Exception: org.ofbiz.entity.GenericDataSourceException

defined on 'ORDER_HEADER'.)


Exception: java.sql.SQLIntegrityConstraintViolationException

0925040555730' defined on 'ORDER_HEADER'.


Exception: org.apache.derby.impl.jdbc.EmbedSQLException

0925040555730' defined on 'ORDER_HEADER'.


Exception: org.apache.derby.iapi.error.StandardException

0925040555730' defined on 'ORDER_HEADER'.



QL090925040555730' defined on 'ORDER_HEADER'.

)

org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)

e)
org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)

e)

aredStatement.java:102)

aredStatement.java:102)

org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111)

org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:821)
org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:690)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

a:25)
java.lang.reflect.Method.invoke(Method.java:597)

va:98)

er.java:785)




sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

a:25)
java.lang.reflect.Method.invoke(Method.java:597)

org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

erChain.java:290)

java:206)

erChain.java:235)

java:206)

33)

75)

)

otocol.java:583)

java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------



service.

R]


[TransactionUtil.rollback]
Exception: java.lang.Exception
Message: Stack Trace


java.lang.Exception: Stack Trace




sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

a:25)
java.lang.reflect.Method.invoke(Method.java:597)

org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

erChain.java:290)

java:206)

erChain.java:235)

java:206)

33)

75)

)

otocol.java:583)

java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------



] [TransactionUtil.rollback] transaction rolled back

] Sync service [ecommerce/storeOrder] finished in [578] milliseconds

[request], result is [error]

y customer service.

vm1

pecialpurpose/ecommerce/widget/OrderScreens.xml

pecialpurpose/ecommerce/widget/CommonScreens.xml

s

.187]]

er [org.ofbiz.service.job.jobpol...@1e58a3e]

: Wed Oct 07 21:02:16 CEST 2009

nds


can anyone help?

Greetz
Alexander

_ $ gen .file_58 $.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.orde r.servicedef.services_46$xml_35$storeOrder.runSync(file:/E:/projekte/ clone-it/of biz/ofbiz-trunk/applications/order/servicedef/ services.xml#storeOrder:91) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 392) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 221) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java: 159) org .ofbiz .order.shoppingcart.CheckOutHelper.createOrder(CheckOutHelper.java: 604) org .ofbiz .order.shoppingcart.CheckOutEvents.createOrder(CheckOutEvents.java: 441) sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 92) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 78) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java: 611) org .ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java: 374) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: 264) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org .apache .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 org .apache .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 org .apache .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org .apache .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org .apache .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 568) org .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 286) org .apache.coyote.http11.Http11Processor.process(Http11Processor.java: 844) org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Pr org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 447) 2009-10-07 20:38:00,593 (http-0.0.0.0-8443-1) [ OrderServices.java:541:ERRO ---- exception report ---------------------------------------------------------- Message: Error while inserting: [GenericEntity:OrderHeader] [billingAccountId,nul l()][createdBy,alex(java.lang.String)][createdStamp,2009-10-07 20:38:00.171(java .sql.Timestamp)][createdTxStamp,2009-10-07 20:38:00.031(java.sql.Timestamp)][cur rencyUom,EUR(java.lang.String)][entryDate,2009-10-07 20:38:00.046(java.sql.Times tamp)][firstAttemptOrderId,WSCO10020(java.lang.String)][grandTotal, 9.000000000(j ava.math.BigDecimal)][lastUpdatedStamp,2009-10-07 20:38:00.171(java.sql.Timestam p)][lastUpdatedTxStamp,2009-10-07 20:38:00.031(java.sql.Timestamp)] [needsInvento ryIssuance,Y(java.lang.String)][orderDate,2009-10-07 20:38:00.046(java.sql.Times tamp)][orderId,WSCO10020(java.lang.String)][orderName,null()] [orderTypeId,SALES_ ORDER(java.lang.String)][productStoreId,9000(java.lang.String)] [salesChannelEnum Id,WEB_SALES_CHANNEL(java.lang.String)] [statusId,ORDER_CREATED(java.lang.String) ][visitId,10500(java.lang.String)] [webSiteId,WebStore(java.lang.String)] (SQL Ex ception while executing the following:INSERT INTO OFBIZ.ORDER_HEADER (ORDER_ID, ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, ORDER_DATE, PRIOR ITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CREATED_BY, FIRST _ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ID, ORIGIN_FACI LITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ID, AUTO_ORDER_ SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERNAL_CODE, REMAIN ING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP , CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The statement was ab orted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090925040555730' defined on 'OR ---- cause --------------------------------------------------------------------- Message: SQL Exception while executing the following:INSERT INTO OFBIZ.ORDER_HEA DER (ORDER_ID, ORDER_TYPE_ID, ORDER_NAME, EXTERNAL_ID, SALES_CHANNEL_ENUM_ID, OR DER_DATE, PRIORITY, ENTRY_DATE, PICK_SHEET_PRINTED_DATE, VISIT_ID, STATUS_ID, CR EATED_BY, FIRST_ATTEMPT_ORDER_ID, CURRENCY_UOM, SYNC_STATUS_ID, BILLING_ACCOUNT_ ID, ORIGIN_FACILITY_ID, WEB_SITE_ID, PRODUCT_STORE_ID, TERMINAL_ID, TRANSACTION_ ID, AUTO_ORDER_SHOPPING_LIST_ID, NEEDS_INVENTORY_ISSUANCE, IS_RUSH_ORDER, INTERN AL_CODE, REMAINING_SUB_TOTAL, GRAND_TOTAL, IS_VIEWED, LAST_UPDATED_STAMP, LAST_U PDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The s tatement was aborted because it would have caused a duplicate key value in a uni que or primary key constraint or unique index identified by 'SQL090925040555730' ---- cause --------------------------------------------------------------------- Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL09 ---- cause --------------------------------------------------------------------- Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL09 ---- cause --------------------------------------------------------------------- Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL09 ---- stack trace --------------------------------------------------------------- ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'S org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org .apache .derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) org .apache .derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Sourc org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) org .apache .derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Sourc org .apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) org .apache .commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPrep org .apache .commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPrep org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java: 410) org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java: 165) org .ofbiz .entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) org.ofbiz.order.order.OrderServices.createOrder(OrderServices.java: 539) sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav org .ofbiz .service .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.ja org .ofbiz .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56) org.ofbiz.service.ModelServiceReader $GenericInvokerImpl.runSync(ModelServiceRead _ $ gen .file_58 $.E_58$.projekte.clone_45$it.ofbiz.ofbiz_45$trunk.applications.orde r.servicedef.services_46$xml_35$storeOrder.runSync(file:/E:/projekte/ clone-it/of biz/ofbiz-trunk/applications/order/servicedef/ services.xml#storeOrder:91) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 392) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 221) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java: 159) org .ofbiz .order.shoppingcart.CheckOutHelper.createOrder(CheckOutHelper.java: 604) org .ofbiz .order.shoppingcart.CheckOutEvents.createOrder(CheckOutEvents.java: 441) sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 92) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 78) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java: 611) org .ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java: 374) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: 264) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org .apache .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 org .apache .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 org .apache .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org .apache .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org .apache .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 568) org .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 286) org .apache.coyote.http11.Http11Processor.process(Http11Processor.java: 844) org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Pr org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 447) 2009-10-07 20:38:00,593 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:530:ERRO R] Error in Service [storeOrder]: Order creation failed; please notify customer 2009-10-07 20:38:00,593 (http-0.0.0.0-8443-1) [ TransactionUtil.java:335:ERRO ---- exception report ---------------------------------------------------------- ---- stack trace --------------------------------------------------------------- org .ofbiz .entity.transaction.TransactionUtil.rollback(TransactionUtil.java:334) org .ofbiz .entity.transaction.TransactionUtil.rollback(TransactionUtil.java:316) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 534) org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java: 221) org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java: 159) org .ofbiz .order.shoppingcart.CheckOutHelper.createOrder(CheckOutHelper.java: 604) org .ofbiz .order.shoppingcart.CheckOutEvents.createOrder(CheckOutEvents.java: 441) sun .reflect .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 92) org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java: 78) org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java: 611) org .ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java: 374) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: 264) org .apache .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt org .apache .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. org .apache .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 org .apache .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 org .apache .catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org .apache .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org .apache .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109 org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java: 568) org .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 286) org .apache.coyote.http11.Http11Processor.process(Http11Processor.java: 844) org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process(Http11Pr org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 447) 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) [ TransactionUtil.java:345:INFO 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:586:INFO 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) [ RequestHandler.java:612:INFO ] Ran Event [java:org.ofbiz.order.shoppingcart.CheckOutEvents#createOrder] from 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) [ RequestHandler.java:412:ERRO R] Request processorder caused an error with the following message: Auftrag nich t vervollstõndigt, folgender Fehler trat auf:Order creation failed; please notif 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) [ RequestHandler.java:716:INFO ] Rendering View [checkoutreview], sessionId=F0ABCCEBA605BB50365EAD4AAF14917B.j 2009-10-07 20:38:00,640 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 35 screens in 0.015s from: file:/E:/projekte/clone-it/ofbiz/ ofbiz-trunk/s 2009-10-07 20:38:00,718 (http-0.0.0.0-8443-1) [ ScreenFactory.java:129:INFO ] Got 16 screens in 0.015s from: file:/E:/projekte/clone-it/ofbiz/ ofbiz-trunk/s 2009-10-07 20:38:00,796 (http-0.0.0.0-8443-1) [ ServiceDispatcher.java:586:INFO ] Sync service [ecommerce/getVisualThemeResources] finished in [62] millisecond 2009-10-07 20:38:01,093 (http-0.0.0.0-8443-1) [ ControlServlet.java:312:INFO ] [[[processorder] Request Done- total:1.187,since last([processorder] Re...):1 2009-10-07 20:47:16,218 (default-invoker-Thread-10) [ JobInvoker.java:23 2:INFO ] Invoker [default-invoker-Thread-10] received job [Send Email] from poll 2009-10-07 20:47:16,281 (default-invoker-Thread-10) [PersistedServiceJob.java:17 8:INFO ] org.ofbiz.service.job.persistedservice...@1ee1f0[10318] -- Next runtime 2009-10-07 20:47:16,687 (default-invoker-Thread-10) [ ServiceDispatcher.java:58 6:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in [406] milliseco

smime.p7s
Description: S/MIME cryptographic signature