You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Alexander <al...@familie-schweizer.net> on 2009/10/07 17:19:44 UTC
Problem creating order
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
Re: Problem creating order
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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