Issue with Negative Item Reservation Balance - Can't Place orders

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Pierre Smits-3]

Hi James,

Which release/branch are you using?

If you feel this is a flaw in the code base, feel free to check whether
such an issue exists in our JIRA system and if not create a new ticket
there.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Thu, Apr 18, 2019 at 5:11 PM <[hidden email]> wrote:

> We are having an issue with being able to place order and getting the
> following error:
>
>
> The Following Errors Occurred:
> ERROR: Could not create order (problem invoking the service: Could not
> commit transaction for service
> [balanceOrderItemsWithNegativeReservations] call: Roll back error (with
> no rollbackOnly cause found), could not commit transaction, was rolled
> back instead: javax.transaction.RollbackException: Transaction timeout
> (Transaction timeout))
>
> Does this happen because of negative QOH? What is the best way to fix
> it?
>
>
> Thanks,
>
>
> James
>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Pierre Smits-3]

HI James,

If you're using OpenTaps you should contact their support organisation.
While OpenTabs is based on a past branch/version of the OFBiz product
(10.05 as you indicated), the project has moved forward since then with
several superseding releases.

Unless you can show that the issue still exists in any of the branches
currently in play (see below), I doubt there will be a contributor feeling
the need to spend time on this (but I don't mind being proven wrong on
this).

Current branches in play are:

   1. demo-stable (r16 branch based):
   https://demo-stable.ofbiz.apache.org/accounting
   2. demo-trunk (against the master branch):
   https://demo-trunk.ofbiz.apache.org/accounting


Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Thu, Apr 18, 2019 at 6:13 PM <[hidden email]> wrote:

> Pierre - We are running Opentaps with Ofbiz 10.5 I believe.
>
> I am not sure it is a bug...it can possibly be because we forced QOH to
> negative for some items.  Based on the error can someone point us in the
> right direction to look?
>
> -------- Original Message --------
> Subject: Re: Issue with Negative Item Reservation Balance - Can't Place
> orders
> From: Pierre Smits <[hidden email]>
> Date: Thu, April 18, 2019 8:36 am
> To: [hidden email]
>
> Hi James,
>
> Which release/branch are you using?
>
> If you feel this is a flaw in the code base, feel free to check whether
> such an issue exists in our JIRA system and if not create a new ticket
> there.
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Thu, Apr 18, 2019 at 5:11 PM <[hidden email]> wrote:
>
> > We are having an issue with being able to place order and getting the
> > following error:
> >
> >
> > The Following Errors Occurred:
> > ERROR: Could not create order (problem invoking the service: Could not
> > commit transaction for service
> > [balanceOrderItemsWithNegativeReservations] call: Roll back error (with
> > no rollbackOnly cause found), could not commit transaction, was rolled
> > back instead: javax.transaction.RollbackException: Transaction timeout
> > (Transaction timeout))
> >
> > Does this happen because of negative QOH? What is the best way to fix
> > it?
> >
> >
> > Thanks,
> >
> >
> > James
> >
>

[Jacques Le Roux]

Could it not be simply that the service is too long to operate?

Jacques

Le 18/04/2019 à 18:12, [hidden email] a écrit :

> Pierre - We are running Opentaps with Ofbiz 10.5 I believe.
>
> I am not sure it is a bug...it can possibly be because we forced QOH to
> negative for some items.  Based on the error can someone point us in the
> right direction to look?
>
> -------- Original Message --------
> Subject: Re: Issue with Negative Item Reservation Balance - Can't Place
> orders
> From: Pierre Smits <[hidden email]>
> Date: Thu, April 18, 2019 8:36 am
> To: [hidden email]
>
> Hi James,
>
> Which release/branch are you using?
>
> If you feel this is a flaw in the code base, feel free to check whether
> such an issue exists in our JIRA system and if not create a new ticket
> there.
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Thu, Apr 18, 2019 at 5:11 PM <[hidden email]> wrote:
>
>> We are having an issue with being able to place order and getting the
>> following error:
>>
>>
>> The Following Errors Occurred:
>> ERROR: Could not create order (problem invoking the service: Could not
>> commit transaction for service
>> [balanceOrderItemsWithNegativeReservations] call: Roll back error (with
>> no rollbackOnly cause found), could not commit transaction, was rolled
>> back instead: javax.transaction.RollbackException: Transaction timeout
>> (Transaction timeout))
>>
>> Does this happen because of negative QOH? What is the best way to fix
>> it?
>>
>>
>> Thanks,
>>
>>
>> James
>>

[james-2]

CONTENTS DELETED

The author has deleted this message.

[Ankush Upadhyay-2]

Hello James,
We had similar requirement in one of our project and we had implemented
custom service to fix these negative ATP/QOH. This would help to fix bulk
of inventories but if you have very few Inventory Item Ids then you need to
create inventory item variance for the inventory Item Id with positive
QOH/ATP to set them to zero.
if you are familiar with Catalog and Facility components then please check
Catalog>Product>Inventory, choose Inventory Item you want to fix and create
variance for it.
Thanks
--
Ankush Upadhyay


On Mon, Apr 22, 2019 at 7:43 PM <[hidden email]> wrote:

> So we have several inventory item IDs with negative Quantity on Hand.
> What is the best way to fix this?  If I receive the inventory will it
> clear out the inventory item ID?
>
> Thanks,
>
> James
>
> -------- Original Message --------
> Subject: Re: Issue with Negative Item Reservation Balance - Can't Place
> orders
> From: Jacques Le Roux <[hidden email]>
> Date: Thu, April 18, 2019 9:49 am
> To: [hidden email]
>
> Could it not be simply that the service is too long to operate?
>
> Jacques
>
> Le 18/04/2019 à 18:12, [hidden email] a écrit :
> > Pierre - We are running Opentaps with Ofbiz 10.5 I believe.
> >
> > I am not sure it is a bug...it can possibly be because we forced QOH to
> > negative for some items. Based on the error can someone point us in the
> > right direction to look?
> >
> > -------- Original Message --------
> > Subject: Re: Issue with Negative Item Reservation Balance - Can't Place
> > orders
> > From: Pierre Smits <[hidden email]>
> > Date: Thu, April 18, 2019 8:36 am
> > To: [hidden email]
> >
> > Hi James,
> >
> > Which release/branch are you using?
> >
> > If you feel this is a flaw in the code base, feel free to check whether
> > such an issue exists in our JIRA system and if not create a new ticket
> > there.
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> > privileges)
> > since 2008*
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Thu, Apr 18, 2019 at 5:11 PM <[hidden email]> wrote:
> >
> >> We are having an issue with being able to place order and getting the
> >> following error:
> >>
> >>
> >> The Following Errors Occurred:
> >> ERROR: Could not create order (problem invoking the service: Could not
> >> commit transaction for service
> >> [balanceOrderItemsWithNegativeReservations] call: Roll back error (with
> >> no rollbackOnly cause found), could not commit transaction, was rolled
> >> back instead: javax.transaction.RollbackException: Transaction timeout
> >> (Transaction timeout))
> >>
> >> Does this happen because of negative QOH? What is the best way to fix
> >> it?
> >>
> >>
> >> Thanks,
> >>
> >>
> >> James
> >>
>