Re: Trouble with the orderview screen

Fri, 03 Nov 2006 21:13:09 -0800
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)

























					Reply via email to