Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005805Openbravo ERPA. Platformpublic2008-11-03 17:082008-12-02 13:08
Reporterrafaroda 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target Version2.50Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005805: Can not show audit in grid view
DescriptionAudit fields can not be shown in grid view with error message:

javax.servlet.ServletException: @CODE=0@ERROR: syntax error at or near "Create"
    at org.openbravo.erpCommon.utility.ExecuteQuery.select(ExecuteQuery.java:283)
    at org.openbravo.erpCommon.utility.DataGrid.getTotalRows(DataGrid.java:123)
    at org.openbravo.erpCommon.utility.DataGrid.printPageData(DataGrid.java:227)
    at org.openbravo.erpCommon.utility.DataGrid.doPost(DataGrid.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:221)
    at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:257)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
    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.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:62)
    at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:35)
    at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:68)
    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:151)
    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:595)
Steps To Reproduce1) Go to 'Application Dictionary || Reference'
2) Select grid (relation) view.
3) Click on Audit icon.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-03 17:08rafarodaNew Issue
2008-11-03 17:08rafarodaAssigned To => rafaroda
2008-11-03 17:08rafarodasf_bug_id0 => 2219207
2008-11-03 17:08rafarodaRegression testing => No
2008-11-05 17:18rafarodaStatusnew => scheduled
2008-11-05 17:18rafarodaAssigned Torafaroda => alostale
2008-11-05 17:18rafarodafix_in_branch => trunk
2008-11-05 17:30svnbotCheckin
2008-11-05 17:30svnbotNote Added: 0010014
2008-11-05 17:30svnbotStatusscheduled => resolved
2008-11-05 17:30svnbotResolutionopen => fixed
2008-11-05 17:30svnbotsvn_revision => 9709
2008-12-02 13:08krishnaStatusresolved => closed

Notes
(0010014)
svnbot   
2008-11-05 17:30   
Repository: openbravo
Revision: 9709
Author: alostale
Date: 2008-11-05 17:30:44 +0100 (Wed, 05 Nov 2008)

fixed bug 0005805: Can not show audit in grid view

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

https://dev.openbravo.com/websvn/openbravo/?rev=9709&sc=1 [^]