You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Dimitri Unruh <u....@gmx.de> on 2006/11/04 04:48:29 UTC
Trouble with the orderview screen
Hi everybody,
I get a strange message when I'm try to vie one order in der ordermgr.
Coud someone please help me?!
I'm using the latest SVN version.
Thanks
Dimitri
2006-11-04 04:44:42,125 (http-0.0.0.0-8443-Processor3) [
UtilXml.java:252:DEBUG] XML Read 0.032s:
file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/OrderViewScreen
s.xml
2006-11-04 04:44:42,140 (http-0.0.0.0-8443-Processor3) [
ScreenFactory.java:115:INFO ] Got 18 screens in 0.047s from:
file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/OrderViewScreen
s.xml
2006-11-04 04:44:42,468 (http-0.0.0.0-8443-Processor3) [
ServiceDispatcher.java:446:DEBUG] [[Sync service finished- total:0.031,since
last(Begin):0.031]] - 'order / getProductManufacturingSummaryByFacility'
2006-11-04 04:44:42,500 (http-0.0.0.0-8443-Processor3) [
GenericDelegator.java:1699:ERROR]
---- exception report
----------------------------------------------------------
Failure in findByCondition operation for entity
[OrderItemQuantityReportGroupByProduct]:
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER JOIN
ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN ITEM_ISSUANCE
II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID <> ? AND
OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?) GROUP BY
OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function name).
Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT OI.PRODUCT_ID AS
PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER JOIN
ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN ITEM_ISSUANCE
II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID <> ? AND
OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?) GROUP BY
OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function name)
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER JOIN
ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN ITEM_ISSUANCE
II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID <> ? AND
OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?) GROUP BY
OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function name)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:381)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(Generic
DAO.java:734)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(Gen
ericHelperDAO.java:140)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegat
or.java:1791)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1691
)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1670
)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantities(
InventoryWorker.java:123)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantitiesF
orSalesOrders(InventoryWorker.java:136)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
bsh.Reflect.invokeOnMethod(Reflect.java:117)
bsh.Reflect.invokeStaticMethod(Reflect.java:109)
bsh.Name.invokeMethod(Name.java:702)
bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
bsh.BSHAssignment.eval(BSHAssignment.java:58)
bsh.BSHBlock.eval(BSHBlock.java:79)
bsh.BSHBlock.eval(BSHBlock.java:44)
bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction
.java:383)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.ja
va:113)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:235)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandl
er.java:75)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:602)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:387)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
java.lang.Thread.run(Thread.java:534)
com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4023] (at 42): Unknown
function name
com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69)
com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:768)
com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434)
com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD
B.java:1501)
com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725)
com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja
va:227)
com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD
B.java:178)
com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav
a:97)
com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:67
7)
org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(X
AClientConnection.java:409)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:369)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(Generic
DAO.java:734)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(Gen
ericHelperDAO.java:140)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegat
or.java:1791)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1691
)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1670
)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantities(
InventoryWorker.java:123)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantitiesF
orSalesOrders(InventoryWorker.java:136)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
bsh.Reflect.invokeOnMethod(Reflect.java:117)
bsh.Reflect.invokeStaticMethod(Reflect.java:109)
bsh.Name.invokeMethod(Name.java:702)
bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
bsh.BSHAssignment.eval(BSHAssignment.java:58)
bsh.BSHBlock.eval(BSHBlock.java:79)
bsh.BSHBlock.eval(BSHBlock.java:44)
bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction
.java:383)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.ja
va:113)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:235)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandl
er.java:75)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:602)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:387)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
java.lang.Thread.run(Thread.java:534)
----------------------------------------------------------------------------
----
2006-11-04 04:44:42,562 (http-0.0.0.0-8443-Processor3) [
TransactionUtil.java:271:WARN ]
---- exception report
----------------------------------------------------------
[TransactionUtil.setRollbackOnly] Calling transaction setRollbackOnly; this
stack trace shows where this is happening:
Exception: java.lang.Exception
Message: null
---- stack trace
---------------------------------------------------------------
java.lang.Exception
org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil
.java:271)
org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:2
21)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1702
)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1670
)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantities(
InventoryWorker.java:123)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantitiesF
orSalesOrders(InventoryWorker.java:136)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
bsh.Reflect.invokeOnMethod(Reflect.java:117)
bsh.Reflect.invokeStaticMethod(Reflect.java:109)
bsh.Name.invokeMethod(Name.java:702)
bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
bsh.BSHAssignment.eval(BSHAssignment.java:58)
bsh.BSHBlock.eval(BSHBlock.java:79)
bsh.BSHBlock.eval(BSHBlock.java:44)
bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
org.ofbiz.widget.screen.ModelScreenAction$Script.runAction(ModelScreenAction
.java:383)
org.ofbiz.widget.screen.ModelScreenAction.runSubActions(ModelScreenAction.ja
va:113)
org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString(ModelSc
reenWidget.java:235)
org.ofbiz.widget.screen.ModelScreen.renderScreenString(ModelScreen.java:131)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
org.ofbiz.widget.screen.ScreenWidgetViewHandler.render(ScreenWidgetViewHandl
er.java:75)
org.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:602)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:387)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:245)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126
)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105
)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
java.lang.Thread.run(Thread.java:534)
----------------------------------------------------------------------------
----
2006-11-04 04:44:42,578 (http-0.0.0.0-8443-Processor3) [
InventoryWorker.java:129:ERROR]
---- exception report
----------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception while executing the following:SELECT OI.PRODUCT_ID AS
PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER JOIN
ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN ITEM_ISSUANCE
II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID <> ? AND
OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?) GROUP BY
OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function name)
---- stack trace
---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER JOIN
ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN ITEM_ISSUANCE
II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID <> ? AND
OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?) GROUP BY
OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function name)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:381)
org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(Generic
DAO.java:734)
org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(Gen
ericHelperDAO.java:140)
org.ofbiz.entity.GenericDelegator.findListIteratorByCondition(GenericDelegat
or.java:1791)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1691
)
org.ofbiz.entity.GenericDelegator.findByCondition(GenericDelegator.java:1670
)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantities(
InventoryWorker.java:123)
org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuantitiesF
orSalesOrders(InventoryWorker.java:136)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
AW: Trouble with the orderview screen
Posted by Dimitri Unruh <u....@gmx.de>.
Thank you David,
you are right, I'm using SAPDB and they don't work with COALESCE.
So I changed COALESCE with VALUE and now it works fine...
Thanks again
Dimitri Unruh
-----Ursprüngliche Nachricht-----
Von: David E Jones [mailto:jonesde@undersunconsulting.com]
Gesendet: Samstag, 4. November 2006 06:13
An: ofbiz-user@incubator.apache.org
Betreff: Re: Trouble with the orderview screen
Which database are you using? It looks like SAPDB.... Perhaps that
doesn't support the COALESCE function. You might want to try a
different database, or you could find and implement an alternative to
COALESCE for SAPDB.
-David
On Nov 3, 2006, at 8:48 PM, Dimitri Unruh wrote:
> Hi everybody,
>
>
>
> I get a strange message when I'm try to vie one order in der ordermgr.
>
> Coud someone please help me?!
>
> I'm using the latest SVN version.
>
>
>
> Thanks
>
>
>
> Dimitri
>
>
>
>
>
>
>
> 2006-11-04 04:44:42,125 (http-0.0.0.0-8443-Processor3) [
> UtilXml.java:252:DEBUG] XML Read 0.032s:
> file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/
> OrderViewScreen
> s.xml
>
> 2006-11-04 04:44:42,140 (http-0.0.0.0-8443-Processor3) [
> ScreenFactory.java:115:INFO ] Got 18 screens in 0.047s from:
> file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/
> OrderViewScreen
> s.xml
>
> 2006-11-04 04:44:42,468 (http-0.0.0.0-8443-Processor3) [
> ServiceDispatcher.java:446:DEBUG] [[Sync service finished- total:
> 0.031,since
> last(Begin):0.031]] - 'order /
> getProductManufacturingSummaryByFacility'
>
> 2006-11-04 04:44:42,500 (http-0.0.0.0-8443-Processor3) [
> GenericDelegator.java:1699:ERROR]
>
> ---- exception report
> ----------------------------------------------------------
>
> Failure in findByCondition operation for entity
> [OrderItemQuantityReportGroupByProduct]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name).
> Rolling back transaction.
>
> Exception: org.ofbiz.entity.GenericDataSourceException
>
> Message: SQL Exception while executing the following:SELECT
> OI.PRODUCT_ID AS
> PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE
> (OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> ---- stack trace
> ---------------------------------------------------------------
>
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:381)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4023] (at 42):
> Unknown
> function name
>
> com.sap.dbtech.jdbc.packet.ReplyPacket.createException
> (ReplyPacket.java:69)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError
> (ConnectionSapDB.java:768)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand
> (CallableStatementSapD
> B.java:1501)
>
> com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.doParse
> (CallableStatementSapDB.ja
> va:227)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.constructor
> (CallableStatementSapD
> B.java:178)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.<init>
> (CallableStatementSapDB.jav
> a:97)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement
> (ConnectionSapDB.java:67
> 7)
>
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareState
> ment(X
> AClientConnection.java:409)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:369)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> ----------------------------------------------------------------------
> ------
> ----
>
>
>
> 2006-11-04 04:44:42,562 (http-0.0.0.0-8443-Processor3) [
> TransactionUtil.java:271:WARN ]
>
> ---- exception report
> ----------------------------------------------------------
>
> [TransactionUtil.setRollbackOnly] Calling transaction
> setRollbackOnly; this
> stack trace shows where this is happening:
>
> Exception: java.lang.Exception
>
> Message: null
>
> ---- stack trace
> ---------------------------------------------------------------
>
> java.lang.Exception
>
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly
> (TransactionUtil
> .java:271)
>
> org.ofbiz.entity.transaction.TransactionUtil.rollback
> (TransactionUtil.java:2
> 21)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1702
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> ----------------------------------------------------------------------
> ------
> ----
>
>
>
> 2006-11-04 04:44:42,578 (http-0.0.0.0-8443-Processor3) [
> InventoryWorker.java:129:ERROR]
>
> ---- exception report
> ----------------------------------------------------------
>
> Exception: org.ofbiz.entity.GenericDataSourceException
>
> Message: SQL Exception while executing the following:SELECT
> OI.PRODUCT_ID AS
> PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE
> (OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> ---- stack trace
> ---------------------------------------------------------------
>
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:381)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
Re: Trouble with the orderview screen
Posted by David E Jones <jo...@undersunconsulting.com>.
Which database are you using? It looks like SAPDB.... Perhaps that
doesn't support the COALESCE function. You might want to try a
different database, or you could find and implement an alternative to
COALESCE for SAPDB.
-David
On Nov 3, 2006, at 8:48 PM, Dimitri Unruh wrote:
> Hi everybody,
>
>
>
> I get a strange message when I'm try to vie one order in der ordermgr.
>
> Coud someone please help me?!
>
> I'm using the latest SVN version.
>
>
>
> Thanks
>
>
>
> Dimitri
>
>
>
>
>
>
>
> 2006-11-04 04:44:42,125 (http-0.0.0.0-8443-Processor3) [
> UtilXml.java:252:DEBUG] XML Read 0.032s:
> file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/
> OrderViewScreen
> s.xml
>
> 2006-11-04 04:44:42,140 (http-0.0.0.0-8443-Processor3) [
> ScreenFactory.java:115:INFO ] Got 18 screens in 0.047s from:
> file:/D:/projekte/SEI_NEW/applications/order/widget/ordermgr/
> OrderViewScreen
> s.xml
>
> 2006-11-04 04:44:42,468 (http-0.0.0.0-8443-Processor3) [
> ServiceDispatcher.java:446:DEBUG] [[Sync service finished- total:
> 0.031,since
> last(Begin):0.031]] - 'order /
> getProductManufacturingSummaryByFacility'
>
> 2006-11-04 04:44:42,500 (http-0.0.0.0-8443-Processor3) [
> GenericDelegator.java:1699:ERROR]
>
> ---- exception report
> ----------------------------------------------------------
>
> Failure in findByCondition operation for entity
> [OrderItemQuantityReportGroupByProduct]:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name).
> Rolling back transaction.
>
> Exception: org.ofbiz.entity.GenericDataSourceException
>
> Message: SQL Exception while executing the following:SELECT
> OI.PRODUCT_ID AS
> PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE
> (OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> ---- stack trace
> ---------------------------------------------------------------
>
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:381)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4023] (at 42):
> Unknown
> function name
>
> com.sap.dbtech.jdbc.packet.ReplyPacket.createException
> (ReplyPacket.java:69)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError
> (ConnectionSapDB.java:768)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand
> (CallableStatementSapD
> B.java:1501)
>
> com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.doParse
> (CallableStatementSapDB.ja
> va:227)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.constructor
> (CallableStatementSapD
> B.java:178)
>
> com.sap.dbtech.jdbc.CallableStatementSapDB.<init>
> (CallableStatementSapDB.jav
> a:97)
>
> com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement
> (ConnectionSapDB.java:67
> 7)
>
> org.ofbiz.minerva.pool.jdbc.xa.wrapper.XAClientConnection.prepareState
> ment(X
> AClientConnection.java:409)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:369)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> ----------------------------------------------------------------------
> ------
> ----
>
>
>
> 2006-11-04 04:44:42,562 (http-0.0.0.0-8443-Processor3) [
> TransactionUtil.java:271:WARN ]
>
> ---- exception report
> ----------------------------------------------------------
>
> [TransactionUtil.setRollbackOnly] Calling transaction
> setRollbackOnly; this
> stack trace shows where this is happening:
>
> Exception: java.lang.Exception
>
> Message: null
>
> ---- stack trace
> ---------------------------------------------------------------
>
> java.lang.Exception
>
> org.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly
> (TransactionUtil
> .java:271)
>
> org.ofbiz.entity.transaction.TransactionUtil.rollback
> (TransactionUtil.java:2
> 21)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1702
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
> sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39
> )
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl
> .java:25)
>
> java.lang.reflect.Method.invoke(Method.java:324)
>
> bsh.Reflect.invokeOnMethod(Reflect.java:117)
>
> bsh.Reflect.invokeStaticMethod(Reflect.java:109)
>
> bsh.Name.invokeMethod(Name.java:702)
>
> bsh.BSHMethodInvocation.eval(BSHMethodInvocation.java:55)
>
> bsh.BSHPrimaryExpression.eval(BSHPrimaryExpression.java:69)
>
> bsh.BSHAssignment.eval(BSHAssignment.java:58)
>
> bsh.BSHBlock.eval(BSHBlock.java:79)
>
> bsh.BSHBlock.eval(BSHBlock.java:44)
>
> bsh.BSHIfStatement.eval(BSHIfStatement.java:48)
>
> bsh.Interpreter.evalParsedScript(Interpreter.java:1104)
>
> org.ofbiz.base.util.BshUtil.runBshAtLocation(BshUtil.java:155)
>
> org.ofbiz.widget.screen.ModelScreenAction$Script.runAction
> (ModelScreenAction
> .java:383)
>
> org.ofbiz.widget.screen.ModelScreenAction.runSubActions
> (ModelScreenAction.ja
> va:113)
>
> org.ofbiz.widget.screen.ModelScreenWidget$Section.renderWidgetString
> (ModelSc
> reenWidget.java:235)
>
> org.ofbiz.widget.screen.ModelScreen.renderScreenString
> (ModelScreen.java:131)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:102)
>
> org.ofbiz.widget.screen.ScreenRenderer.render(ScreenRenderer.java:87)
>
> org.ofbiz.widget.screen.ScreenWidgetViewHandler.render
> (ScreenWidgetViewHandl
> er.java:75)
>
> org.ofbiz.webapp.control.RequestHandler.renderView
> (RequestHandler.java:602)
>
> org.ofbiz.webapp.control.RequestHandler.doRequest
> (RequestHandler.java:387)
>
> org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:178)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:252)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:
> 245)
>
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (Application
> FilterChain.java:202)
>
> org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterCh
> ain.java:173)
>
> org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.ja
> va:213)
>
> org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.ja
> va:178)
>
> org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:126
> )
>
> org.apache.catalina.valves.ErrorReportValve.invoke
> (ErrorReportValve.java:105
> )
>
> org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java
> :107)
>
> org.apache.catalina.valves.AccessLogValve.invoke
> (AccessLogValve.java:541)
>
> org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:148)
>
> org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:869)
>
> org.apache.coyote.http11.Http11BaseProtocol
> $Http11ConnectionHandler.processC
> onnection(Http11BaseProtocol.java:664)
>
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.jav
> a:527)
>
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWo
> rkerThread.java:80)
>
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.jav
> a:684)
>
> java.lang.Thread.run(Thread.java:534)
>
> ----------------------------------------------------------------------
> ------
> ----
>
>
>
> 2006-11-04 04:44:42,578 (http-0.0.0.0-8443-Processor3) [
> InventoryWorker.java:129:ERROR]
>
> ---- exception report
> ----------------------------------------------------------
>
> Exception: org.ofbiz.entity.GenericDataSourceException
>
> Message: SQL Exception while executing the following:SELECT
> OI.PRODUCT_ID AS
> PRODUCT_ID, SUM((COALESCE(OI.QUANTITY,0) - COALESCE
> (OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> ---- stack trace
> ---------------------------------------------------------------
>
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while
> executing
> the following:SELECT OI.PRODUCT_ID AS PRODUCT_ID,
> SUM((COALESCE(OI.QUANTITY,0) - COALESCE(OI.CANCEL_QUANTITY,0) -
> COALESCE(II.QUANTITY,0))) AS QUANTITY_OPEN FROM ORDER_ITEM OI INNER
> JOIN
> ORDER_HEADER OH ON OI.ORDER_ID = OH.ORDER_ID LEFT OUTER JOIN
> ITEM_ISSUANCE
> II ON OI.ORDER_ID = II.ORDER_ID AND OI.ORDER_ITEM_SEQ_ID =
> II.ORDER_ITEM_SEQ_ID WHERE (OH.ORDER_TYPE_ID = ? AND OH.STATUS_ID
> <> ? AND
> OH.STATUS_ID <> ? AND OH.STATUS_ID <> ? AND OI.PRODUCT_ID IN (?) AND
> OI.STATUS_ID <> ? AND OI.STATUS_ID <> ? AND OI.STATUS_ID <> ?)
> GROUP BY
> OH.ORDER_TYPE_ID, OI.PRODUCT_ID ([-4023] (at 42): Unknown function
> name)
>
> org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement
> (SQLProcessor.java:381)
>
> org.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition
> (Generic
> DAO.java:734)
>
> org.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByConditi
> on(Gen
> ericHelperDAO.java:140)
>
> org.ofbiz.entity.GenericDelegator.findListIteratorByCondition
> (GenericDelegat
> or.java:1791)
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1691
> )
>
> org.ofbiz.entity.GenericDelegator.findByCondition
> (GenericDelegator.java:1670
> )
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> ities(
> InventoryWorker.java:123)
>
> org.ofbiz.product.inventory.InventoryWorker.getOutstandingProductQuant
> itiesF
> orSalesOrders(InventoryWorker.java:136)
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>