OFBiz › OFBiz - User

Trouble with the orderview screen

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Dimitri Unruh

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)

David E Jones-2

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)
>

Dimitri Unruh

AW: Trouble with the orderview screen

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