Error in Inventory Reports from trunk build + PostgresSQL 8.3

["Enrique Ruibal A." <er...@prodigy.net.mx>]

Hi,

I am getting different errors (and no reports at all) from 
Inventory/Inventroy Item Detail report screen menu, I am using latest 
build from trunk and postgresql database please advice

org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen 
[component://product/widget/facility/FacilityScreens.xml#ViewFacilityInventoryByProduct]: 
org.ofbiz.base.util.GeneralException: Error running BSH script at 
location 
[component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh] 
(Error running BSH script at 
[component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh], 
line [148]: Sourced file: 
component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh 
: TargetError : at Line: 148 : in file: 
component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh 
: throw e ;

Re: Error in Inventory Reports from trunk build + PostgresSQL 8.3

[Enrique Ruibal <er...@prodigy.net.mx>]

Hi David,

I just had to uninstall PostgreSQL 8.3 and put version 8.2.5 back in my
laptop, I also rebuilt ofbiz from scratch, so I didn't keep any error logs
from 8.3

I'd just add too, I had problems with 8.3 windows installer, and also found
some duplicated invoices while running ofbiz POS under latest version 8.3,
so I would think more thorough testing should be done under PostgreSQL 8.3

I guess I'd stick with the more stable PostgreSQL version 8.2.5 for a while,
since I'm just starting to learn ofbiz, and would like to keep things mostly
compatible with what you guys commit to trunk.

-Enrique



-- 
View this message in context: http://www.nabble.com/Error-in-Inventory-Reports-from-trunk-build-%2B-PostgresSQL-8.3-tp15646237p15659294.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Error in Inventory Reports from trunk build + PostgresSQL 8.3

[David E Jones <jo...@hotwaxmedia.com>]

Do you have a more complete stack trace of where this went wrong? The  
one you included originally was just the top level of the trace,  
showing the bsh script where whatever caused the problem was called.

This happens quite a bit actually with new databases where they have  
small changes that are either not backward compatible, or that just  
conflict with how the Entity Engine uses JDBC (which is a somewhat  
loose but often loosely implemented specification).

Anyway, these are usually really easy to fix.

-David


On Feb 23, 2008, at 1:04 PM, Enrique Ruibal wrote:

>
> Problem solved, had to uninstall PostgreSQL 8.3 and reinstall 8.2.5,
> everything works fine now..I think there is an issue with the latest
> version, I regret it though since it was a little faster than 8.2.5
>
> Thanks for the advice
> -Enrique
>
> -- 
> View this message in context: http://www.nabble.com/Error-in-Inventory-Reports-from-trunk-build-%2B-PostgresSQL-8.3-tp15646237p15656503.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Re: Error in Inventory Reports from trunk build + PostgresSQL 8.3

[Enrique Ruibal <er...@prodigy.net.mx>]

Problem solved, had to uninstall PostgreSQL 8.3 and reinstall 8.2.5,
everything works fine now..I think there is an issue with the latest
version, I regret it though since it was a little faster than 8.2.5

Thanks for the advice
-Enrique

-- 
View this message in context: http://www.nabble.com/Error-in-Inventory-Reports-from-trunk-build-%2B-PostgresSQL-8.3-tp15646237p15656503.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Error in Inventory Reports from trunk build + PostgresSQL 8.3

[Jacques Le Roux <ja...@les7arts.com>]

Works well on my local copy running OFBiz OOTB on PostgresSQL 8.2
Same on demo server https://demo.hotwaxmedia.com/facility/control/ViewFacilityInventoryItemsDetails

Jacques

From: "Enrique Ruibal A." <er...@prodigy.net.mx>
> Hi,
> 
> I am getting different errors (and no reports at all) from 
> Inventory/Inventroy Item Detail report screen menu, I am using latest 
> build from trunk and postgresql database please advice
> 
> org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen 
> [component://product/widget/facility/FacilityScreens.xml#ViewFacilityInventoryByProduct]: 
> org.ofbiz.base.util.GeneralException: Error running BSH script at 
> location 
> [component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh] 
> (Error running BSH script at 
> [component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh], 
> line [148]: Sourced file: 
> component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh 
> : TargetError : at Line: 148 : in file: 
> component://product/webapp/facility/WEB-INF/actions/facility/ViewFacilityInventoryByProduct.bsh 
> : throw e ;
> 
> 
>