You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Anne <an...@cohsoft.com.au> on 2011/03/03 04:47:20 UTC

getInventoryAvailableByFacility error b/c no transaction

Hi

When calling getInventoryAvailableByFacility service, I see messages
in the logs telling me

ERROR: Cannot do a find that returns an EntityListIterator with no
transaction in place. Wrap this call in a transaction.

Is the correct solution to simply change use-transaction from false to
true for the simple method getProductInventoryAvailable in
InventoryStockServices.xml ?

Cheers,
Anne.

-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Phone: (03) 9585 6788
Fax: (03) 9585 1086
Web: http://www.cohsoft.com.au/
Email: sales@cohsoft.com.au

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

Re: getInventoryAvailableByFacility error b/c no transaction

Posted by Anne <an...@cohsoft.com.au>.
I've created a button which calls the standard webapp target of
getProductInventoryAvailable in ordermgr's controller.xml, which in
turn calls getInventoryAvailableByFacility as a service.

The button is created in ftl, modelled after the Atp/Qoh button in
ordermgr's showcart.ftl when creating a purchase order, except that it
targets getProductInventoryAvailable instead of
productAvailabalityByFacility.

I've got some custom code in there as well, but don't think any of the
custom code is being called in this execution path. If you think the
symptoms don't make sense, I'll dig deeper and make sure it's not
something I've changed that's causing the message.

I'm using trunk rev 1074371.

Cheers,
Anne.


On 3 March 2011 16:36, David E Jones <de...@me.com> wrote:
>
> How are you calling the service? Usually the service engine will handle the begin/rollback/commit of transactions.
>
> -David
>
>
> On Mar 2, 2011, at 7:47 PM, Anne wrote:
>
>> Hi
>>
>> When calling getInventoryAvailableByFacility service, I see messages
>> in the logs telling me
>>
>> ERROR: Cannot do a find that returns an EntityListIterator with no
>> transaction in place. Wrap this call in a transaction.
>>
>> Is the correct solution to simply change use-transaction from false to
>> true for the simple method getProductInventoryAvailable in
>> InventoryStockServices.xml ?
>>
>> Cheers,
>> Anne.
>>
>> --
>> Coherent Software Australia Pty Ltd
>> PO Box 2773
>> Cheltenham Vic 3192
>> Phone: (03) 9585 6788
>> Fax: (03) 9585 1086
>> Web: http://www.cohsoft.com.au/
>> Email: sales@cohsoft.com.au
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>
>



-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Phone: (03) 9585 6788
Fax: (03) 9585 1086
Web: http://www.cohsoft.com.au/
Email: sales@cohsoft.com.au

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

Re: getInventoryAvailableByFacility error b/c no transaction

Posted by David E Jones <de...@me.com>.
How are you calling the service? Usually the service engine will handle the begin/rollback/commit of transactions.

-David


On Mar 2, 2011, at 7:47 PM, Anne wrote:

> Hi
> 
> When calling getInventoryAvailableByFacility service, I see messages
> in the logs telling me
> 
> ERROR: Cannot do a find that returns an EntityListIterator with no
> transaction in place. Wrap this call in a transaction.
> 
> Is the correct solution to simply change use-transaction from false to
> true for the simple method getProductInventoryAvailable in
> InventoryStockServices.xml ?
> 
> Cheers,
> Anne.
> 
> -- 
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Phone: (03) 9585 6788
> Fax: (03) 9585 1086
> Web: http://www.cohsoft.com.au/
> Email: sales@cohsoft.com.au
> 
> Bonsai ERP, the all-inclusive ERP system
> http://www.bonsaierp.com.au/