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.jobpol...@1e58a3e]
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
: 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
