Problem creating order
Locked
Problem creating order
 
|
Re: Problem creating order
|
|
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) > _ > $ > 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.invoke0(Native Method) > sun > .reflect > .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun > .reflect > .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav > a:25) > java.lang.reflect.Method.invoke(Method.java:597) > 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.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214) > javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:290) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: > 264) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:235) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org > .apache > .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 > 33) > org > .apache > .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 > 75) > 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 > otocol.java:583) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > 447) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > > 2009-10-07 20:38:00,593 (http-0.0.0.0-8443-1) > [ OrderServices.java:541:ERRO > R] > ---- exception report > ---------------------------------------------------------- > > Cannot create OrderHeader entity; problems with insert > Exception: org.ofbiz.entity.GenericEntityException > 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 > DER_HEADER'.)) > ---- cause > --------------------------------------------------------------------- > > Exception: org.ofbiz.entity.GenericDataSourceException > 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' > defined on 'ORDER_HEADER'.) > ---- cause > --------------------------------------------------------------------- > > Exception: java.sql.SQLIntegrityConstraintViolationException > 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 > 0925040555730' defined on 'ORDER_HEADER'. > ---- cause > --------------------------------------------------------------------- > > Exception: org.apache.derby.impl.jdbc.EmbedSQLException > 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 > 0925040555730' defined on 'ORDER_HEADER'. > ---- cause > --------------------------------------------------------------------- > > Exception: org.apache.derby.iapi.error.StandardException > 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 > 0925040555730' defined on 'ORDER_HEADER'. > ---- 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 > QL090925040555730' defined on 'ORDER_HEADER'. > 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.IndexChanger.insert(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 > e) > org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > 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 > e) > org > .apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown > Source) > org > .apache > .commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPrep > aredStatement.java:102) > org > .apache > .commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPrep > aredStatement.java:102) > org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java: > 410) > org.ofbiz.entity.datasource.GenericDAO.singleInsert(GenericDAO.java: > 165) > org.ofbiz.entity.datasource.GenericDAO.insert(GenericDAO.java:111) > org > .ofbiz > .entity.datasource.GenericHelperDAO.create(GenericHelperDAO.java:65) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:821) > org.ofbiz.entity.GenericDelegator.create(GenericDelegator.java:690) > org.ofbiz.order.order.OrderServices.createOrder(OrderServices.java: > 539) > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > sun > .reflect > .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun > .reflect > .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav > a:25) > java.lang.reflect.Method.invoke(Method.java:597) > org > .ofbiz > .service > .engine.StandardJavaEngine.serviceInvoker(StandardJavaEngine.ja > va:98) > org > .ofbiz > .service.engine.StandardJavaEngine.runSync(StandardJavaEngine.java:56) > org.ofbiz.service.ModelServiceReader > $GenericInvokerImpl.runSync(ModelServiceRead > er.java:785) > _ > $ > 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.invoke0(Native Method) > sun > .reflect > .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun > .reflect > .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav > a:25) > java.lang.reflect.Method.invoke(Method.java:597) > 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.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214) > javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:290) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: > 264) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:235) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org > .apache > .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 > 33) > org > .apache > .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 > 75) > 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 > otocol.java:583) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > 447) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > > 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 > service. > 2009-10-07 20:38:00,593 (http-0.0.0.0-8443-1) > [ TransactionUtil.java:335:ERRO > R] > ---- exception report > ---------------------------------------------------------- > > [TransactionUtil.rollback] > Exception: java.lang.Exception > Message: Stack Trace > ---- stack trace > --------------------------------------------------------------- > > java.lang.Exception: 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.invoke0(Native Method) > sun > .reflect > .NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > sun > .reflect > .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav > a:25) > java.lang.reflect.Method.invoke(Method.java:597) > 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.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:214) > javax.servlet.http.HttpServlet.service(HttpServlet.java:690) > javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:290) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java: > 264) > org > .apache > .catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt > erChain.java:235) > org > .apache > .catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain. > java:206) > org > .apache > .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2 > 33) > org > .apache > .catalina.core.StandardContextValve.invoke(StandardContextValve.java:1 > 75) > 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 > otocol.java:583) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: > 447) > java.lang.Thread.run(Thread.java:619) > -------------------------------------------------------------------------------- > > > 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) > [ TransactionUtil.java:345:INFO > ] [TransactionUtil.rollback] transaction rolled back > 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) > [ ServiceDispatcher.java:586:INFO > ] Sync service [ecommerce/storeOrder] finished in [578] milliseconds > 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 > [request], result is [error] > 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 > y customer service. > 2009-10-07 20:38:00,609 (http-0.0.0.0-8443-1) > [ RequestHandler.java:716:INFO > ] Rendering View [checkoutreview], > sessionId=F0ABCCEBA605BB50365EAD4AAF14917B.j > vm1 > 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 > pecialpurpose/ecommerce/widget/OrderScreens.xml > 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 > pecialpurpose/ecommerce/widget/CommonScreens.xml > 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 > s > 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 > .187]] > 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 > er [org.ofbiz.service.job.JobPoller@1e58a3e] > 2009-10-07 20:47:16,281 (default-invoker-Thread-10) > [PersistedServiceJob.java:17 > 8:INFO ] org.ofbiz.service.job.PersistedServiceJob@1ee1f0[10318] -- > Next runtime > : Wed Oct 07 21:02:16 CEST 2009 > 2009-10-07 20:47:16,687 (default-invoker-Thread-10) > [ ServiceDispatcher.java:58 > 6:INFO ] Sync service [JobDispatcher/sendEmailDated] finished in > [406] milliseco > nds > > > can anyone help? > > Greetz > Alexander |
smime.p7s (3K) | Free forum by Nabble | Edit this page |