Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004377
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2008-07-11 11:582008-09-03 22:58
ReporterstefanbaderView Statuspublic 
Assigned Toiperdomo 
PrioritynormalResolutionfixedFixed in Version2.40
StatusclosedFix in branchpiFixed in SCM revision5885
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.5.0_13
OS VersionUbuntu, SUSEDatabase version8.3Ant version1.7.0
Product VersionpiSCM revision5794 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004377: Error when selecting sales order line in the grid view

DescriptionThe behaviour is strange. I cannot reproduce it by a specific rule. Normally this error appears pretty fast, when changing the current selection of the sales order line in the grid view. Sometimes you have to move out of the window and try again to force it. The same error appears also on other windows with 'lines'. It can take some seconds until the message appears after changing the selection. I would be happy to give you a better explanation, but that's all I have.
Steps To Reproduce1. Login with Openbravo,
2. Change to Openbravo Admin, Big Bazaar
3. Sales Management / Sales Order : Select Sales Order 50020
4. Show lines for the sales in order in the grid view
5. Change the current selected line, from 10 to 20 and back, maybe you have to repeat this step, until the following error appears in the log file :

javax.servlet.ServletException: @CODE=0@ERROR: column "c_orderline.line" must appear in the GROUP BY clause or be used in an aggregate function
    at org.openbravo.erpCommon.utility.ExecuteQuery.select(ExecuteQuery.java:190)
    at org.openbravo.erpCommon.utility.DataGrid.getColumnTotals(DataGrid.java:345)
    at org.openbravo.erpCommon.utility.DataGrid.doPost(DataGrid.java:87)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:102)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:259)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:27)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
    at java.lang.Thread.run(Thread.java:619)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0008284)
cromero (viewer)
2008-07-11 18:15

 The problem is in this SQL:
2008-07-11 16:16:01 CEST ERROR: la columna "c_orderline.line" debe aparecer en la cláusula GROUP BY o ser usada en una función de agregación
2008-07-11 16:16:01 CEST SENTENCIA: SELECT SUM(Line) AS TOTAL
        FROM C_OrderLine
        left join (SELECT M_Product_ID, Name FROM M_Product) td0 on C_OrderLine.M_Product_ID = td0.M_Product_ID

        left join (SELECT C_UOM_ID, Name FROM C_UOM) td1 on C_OrderLine.C_UOM_ID = td1.C_UOM_ID

        left join (SELECT AD_Language, C_UOM_ID, Name FROM C_UOM_Trl) td_trl2 on td1.C_UOM_ID = td_trl2.C_UOM_ID AND td_trl2.AD_Language = $1
        left join (SELECT C_Tax_ID, Name FROM C_Tax) td3 on C_OrderLine.C_Tax_ID = td3.C_Tax_ID
        left join (SELECT AD_Language, C_Tax_ID, Name FROM C_Tax_Trl) td_trl4 on td3.C_Tax_ID = td_trl4.C_Tax_ID AND td_trl4.AD_Language = $2
        WHERE (C_OrderLine.C_OrderLine_ID) IN (SELECT C_OrderLine.C_OrderLine_ID
         FROM C_OrderLine
         WHERE C_OrderLine.AD_Client_ID IN (0,1000000)
         AND C_OrderLine.AD_Org_ID IN (0,1000000,1000002,1000003,1000004,1000005,1000006,1000008,1000009,1000007)
         AND C_OrderLine.C_Order_ID = $3
         AND C_OrderLine.C_OrderLine_ID IN ('1000043')
        )
        ORDER BY C_OrderLine.Line ASC, C_OrderLine.C_OrderLine_ID
(0008310)
svnbot (viewer)
2008-07-17 10:33

 Repository: openbravo
Revision: 5885
Author: iperdomo
Date: 2008-07-17 10:33:31 +0200 (Thu, 17 Jul 2008)

Fixes bug 4377: Removed order by clause when calculating the total of a column

---
U trunk/src/org/openbravo/erpCommon/utility/DataGrid.java
U trunk/src/org/openbravo/erpCommon/utility/ModelSQLGeneration.java
U trunk/src/org/openbravo/erpCommon/utility/TableSQLData.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=5885&sc=1 [^]
(0008311)
iperdomo (viewer)
2008-07-17 10:43

 To reproduce the bug, you select one or more rows from the grid, and then put the mouse pointer over the column header. This action will calculate the sum of the selected rows and place it on the window status bar.

Note: To be able to see the result, you have to configure your browser. By default, changing the status bar message is disabled [1]

[1] http://developer.mozilla.org/en/docs/DOM:window.status [^]

- Issue History
Date Modified Username Field Change
2008-07-11 11:58 stefanbader New Issue
2008-07-11 11:58 stefanbader Assigned To => cromero
2008-07-11 11:58 stefanbader sf_bug_id 0 => 2015870
2008-07-11 18:15 cromero Note Added: 0008284
2008-07-11 18:16 cromero Status new => scheduled
2008-07-11 18:16 cromero Assigned To cromero => iperdomo
2008-07-11 18:16 cromero fix_in_branch => trunk
2008-07-13 13:59 stefanbader Issue Monitored: stefanbader
2008-07-17 10:33 svnbot Checkin
2008-07-17 10:33 svnbot Note Added: 0008310
2008-07-17 10:33 svnbot Status scheduled => resolved
2008-07-17 10:33 svnbot Resolution open => fixed
2008-07-17 10:33 svnbot svn_revision => 5885
2008-07-17 10:43 iperdomo Note Added: 0008311
2008-09-03 22:58 psarobe Regression testing => No
2008-09-03 22:58 psarobe Status resolved => closed
2008-09-03 22:58 psarobe Fixed in Version => 2.40

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker