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:[EMAIL PROTECTED] Gesendet: Samstag, 4. November 2006 06:13 An: [email protected] 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) >
