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)
