ofbiz table Work_effort problem in derby database
Locked
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
|
|
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))) |
Re: ofbiz table Work_effort problem in derby database
|
|
In reply to this post by Developer Olagos
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))) |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |