Error in Inventory Reports from trunk build + PostgresSQL 8.3

[Enrique Ruibal]

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 ;

[Jacques Le Roux]

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." <[hidden email]>

> 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 ;
>
>
>

[Enrique Ruibal]

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

[David E Jones]

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.
>

[Enrique Ruibal]

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