You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Heidi Dehaes <de...@gmail.com> on 2008/02/10 11:11:36 UTC
ofbiz table Work_effort problem in derby database
hello,
I have a problem with the work_effort table in the ofbiz database (derby).
Especially when i like to see the order list in the orders tab and i click
on an order to edit the order, i receive an error.
org.ofbiz.base.util.GeneralException: Error rendering screen
[component://order/widget/ordermgr/OrderViewScreens.xml#OrderHeaderView]:
org.ofbiz.base.util.GeneralException: Error running BSH script at location
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh],
line [297]: Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null : at Line: 297 : in file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
manufacturingInQuantitySummaryByFacility .get ( "estimatedQuantityTotal" )
Target exception: java.lang.NullPointerException: Null Pointer in Method
Invocation
(Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null) (Error running BSH script at
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh],
line [297]: Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null : at Line: 297 : in file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
manufacturingInQuantitySummaryByFacility .get ( "estimatedQuantityTotal" )
Target exception: java.lang.NullPointerException: Null Pointer in Method
Invocation
(Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null)) (Error running BSH script at location
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh],
line [297]: Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null : at Line: 297 : in file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
manufacturingInQuantitySummaryByFacility .get ( "estimatedQuantityTotal" )
Target exception: java.lang.NullPointerException: Null Pointer in Method
Invocation
(Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null) (Error running BSH script at
[component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh],
line [297]: Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null : at Line: 297 : in file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
manufacturingInQuantitySummaryByFacility .get ( "estimatedQuantityTotal" )
Target exception: java.lang.NullPointerException: Null Pointer in Method
Invocation
(Sourced file:
component://order/webapp/ordermgr/WEB-INF/actions/order/orderview.bsh :
Typed variable declaration : null)))
When i want to see the table work_effort in the webtools , entity data
maintenance, i receive this error.
Can someone help how i can repair such a single table in a derby database.
PS.: i use Squirrel to edit the database.
thanks,
Delopper at Olagos.eu
org.ofbiz.base.util.GeneralException: Error rendering screen
[component://webtools/widget/EntityScreens.xml#FindGeneric]:
org.ofbiz.base.util.GeneralException: Error running BSH script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)) (Error running BSH
script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)))
Re: ofbiz table Work_effort problem in derby database
Posted by Developer Olagos <de...@gmail.com>.
Hi again,
When i want to see the table work_effort in the webtools , entity data
maintenance, i receive this error.
Can someone help me how i can repair such a single table in a derby
database.
PS.: i use Squirrel to edit the database.
This is very important for me because due to this, i can not see my order
details in the order tab anymore.
thanks,
Delopper at Olagos.eu
org.ofbiz.base.util.GeneralException: Error rendering screen
[component://webtools/widget/EntityScreens.xml#FindGeneric]:
org.ofbiz.base.util.GeneralException: Error running BSH script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)) (Error running BSH
script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)))
--
View this message in context: http://www.nabble.com/ofbiz-table-Work_effort-problem-in-derby-database-tp15394945p15411138.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: ofbiz table Work_effort problem in derby database
Posted by Developer Olagos <de...@gmail.com>.
Hi again,
When i want to see the table work_effort in the webtools , entity data
maintenance, i receive this error.
Can someone help me how i can repair such a single table in a derby
database.
PS.: i use Squirrel to edit the database.
This is very important for me because due to this, i can not see my order
details in the order tab anymore.
thanks,
Delopper at Olagos.eu
org.ofbiz.base.util.GeneralException: Error rendering screen
[component://webtools/widget/EntityScreens.xml#FindGeneric]:
org.ofbiz.base.util.GeneralException: Error running BSH script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)) (Error running BSH
script at location
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh]:
org.ofbiz.base.util.GeneralException: Error running BSH script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition) (Error running BSH
script at
[component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh],
line [121]: Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition : at Line: 121 : in file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: delegator .findCountByCondition ( findByEntity .getEntityName ( ) ,
condition , null )
Target exception: org.ofbiz.entity.GenericDataSourceException: SQL Exception
while executing the following:SELECT COUNT(*) FROM
OFBIZ.WORK_EFFORT(Unknown container format at container null :
543,451,493)
(Sourced file:
component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh
: Method Invocation delegator.findCountByCondition)))
--
View this message in context: http://www.nabble.com/ofbiz-table-Work_effort-problem-in-derby-database-tp15394945p15411137.html
Sent from the OFBiz - User mailing list archive at Nabble.com.