Error: Could not create order (problem invoking the service: Could not commit transaction for service [storeOrder] call

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Error: Could not create order (problem invoking the service: Could not commit transaction for service [storeOrder] call

edward wang
Hi Folks,

Sometimes in our product, we got this error when I submitted an order:

ERROR: Could not create order (problem invoking the service: Could not
commit transaction for service [storeOrder] call: Roll back error (with no
rollbackOnly cause found), could not commit transaction, was rolled back
instead: javax.transaction.RollbackException: Transaction timout
(Transaction timout))

I have no idea what caused this issue?

I looked at service.xml

<service name="storeOrder" engine="java" validate="true" auth="true"
            location="org.ofbiz.order.order.OrderServices"
invoke="createOrder">

there is any timeout for this service to invoke cretOrder?

Thanks

Chwang
Reply | Threaded
Open this post in threaded view
|

Re: Error: Could not create order (problem invoking the service: Could not commit transaction for service [storeOrder] call

BJ Freeman
number of things come to mind.
all outside ofbiz.
if Mysql could not have enough connection and getting time out for lack
ofconnections
depends of the speed of the server and if it dedicated or shared.


=========================
BJ Freeman
http://bjfreeman.elance.com
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>

Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man
Linkedin
<http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>


edward wang sent the following on 6/4/2010 3:28 PM:

> Hi Folks,
>
> Sometimes in our product, we got this error when I submitted an order:
>
> ERROR: Could not create order (problem invoking the service: Could not
> commit transaction for service [storeOrder] call: Roll back error (with no
> rollbackOnly cause found), could not commit transaction, was rolled back
> instead: javax.transaction.RollbackException: Transaction timout
> (Transaction timout))
>
> I have no idea what caused this issue?
>
> I looked at service.xml
>
> <service name="storeOrder" engine="java" validate="true" auth="true"
>             location="org.ofbiz.order.order.OrderServices"
> invoke="createOrder">
>
> there is any timeout for this service to invoke cretOrder?
>
> Thanks
>
> Chwang
>

Reply | Threaded
Open this post in threaded view
|

Re: Error: Could not create order (problem invoking the service: Could not commit transaction for service [storeOrder] call

edward wang
Thank you very much!

Chwang

On Fri, Jun 4, 2010 at 4:46 PM, BJ Freeman <[hidden email]> wrote:

> number of things come to mind.
> all outside ofbiz.
> if Mysql could not have enough connection and getting time out for lack
> ofconnections
> depends of the speed of the server and if it dedicated or shared.
>
>
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
>
> Systems Integrator-- Glad to Assist
>
> Chat  Y! messenger: bjfr33man
> Linkedin
> <
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> >
>
>
> edward wang sent the following on 6/4/2010 3:28 PM:
> > Hi Folks,
> >
> > Sometimes in our product, we got this error when I submitted an order:
> >
> > ERROR: Could not create order (problem invoking the service: Could not
> > commit transaction for service [storeOrder] call: Roll back error (with
> no
> > rollbackOnly cause found), could not commit transaction, was rolled back
> > instead: javax.transaction.RollbackException: Transaction timout
> > (Transaction timout))
> >
> > I have no idea what caused this issue?
> >
> > I looked at service.xml
> >
> > <service name="storeOrder" engine="java" validate="true" auth="true"
> >             location="org.ofbiz.order.order.OrderServices"
> > invoke="createOrder">
> >
> > there is any timeout for this service to invoke cretOrder?
> >
> > Thanks
> >
> > Chwang
> >
>
>