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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016263
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2011-03-14 13:102011-03-15 00:00
ReporterplujanView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisioncd7e140444d7
ProjectionnoneETAnoneTarget Version3.0RC5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016263: Null pointer exception when generating a CSV for Audit Trail window

DescriptionWhen generating a CSV file for the Audit Trail window I got a wrong CSV and a Null Pointer Exception error in the log. See steps
Steps To Reproduce1. As System Administrator, go to Audit Trail window (Instance should be activated)
2. Click the "Export to Spreadsheet" button to generate a CSV file.
3. Open the generated file. It is something like this:
"Time","Action","User/Contact","Process Description","Table","Record ID","Record Revision","Column","Old Value","New Value"{"response":{"status":-4,"error":{"type":"system"}}}
4. Check the Tomcat's log. It will have an exception.
Proposed Solution12:05:57 [ajp-8009-5] ERROR org.openbravo.client.kernel.KernelUtils -
java.lang.NullPointerException
        at org.openbravo.erpCommon.utility.Utility.getContext(Utility.java:413)
        at org.openbravo.service.json.AdvancedQueryBuilder.substituteContextParameters(AdvancedQueryBuilder.java:652)
        at org.openbravo.service.json.AdvancedQueryBuilder.substituteParameters(AdvancedQueryBuilder.java:251)
        at org.openbravo.service.json.AdvancedQueryBuilder.getWhereClause(AdvancedQueryBuilder.java:162)
        at org.openbravo.service.json.AdvancedQueryBuilder.getJoinClause(AdvancedQueryBuilder.java:695)
        at org.openbravo.service.json.DataEntityQueryService.buildOBQuery(DataEntityQueryService.java:103)
        at org.openbravo.service.json.DataEntityQueryService.scroll(DataEntityQueryService.java:96)
        at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:185)
        at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:65)
        at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:196)
        at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:478)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:225)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:456)
        at org.openbravo.client.kernel.BaseKernelServlet.callServiceInSuper(BaseKernelServlet.java:89)
        at org.openbravo.client.kernel.BaseKernelServlet.service(BaseKernelServlet.java:65)
        at org.openbravo.service.datasource.DataSourceServlet.service(DataSourceServlet.java:110)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.openbravo.dal.core.DalRequestFilter$1.doAction(DalRequestFilter.java:81)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.dal.core.DalRequestFilter.doFilter(DalRequestFilter.java:103)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:427)
        at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:384)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527)
        at java.lang.Thread.run(Thread.java:619)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0034822)
hgbot (developer)
2011-03-14 17:59

Repository: erp/devel/pi
Changeset: cd7e140444d77a460a27b0e6eb7beeaef72cfd20
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Mar 14 17:53:54 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cd7e140444d77a460a27b0e6eb7beeaef72cfd20 [^]

Fixed issue 16263. Export CSV will no longer crash when windowId is null

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java
---
(0034843)
shuehner (administrator)
2011-03-14 19:12

Reviewed & tested on pi/pgsql (rev: 70252cc848b). Now working fine.Audit trail window does export its rows without an throwing a NPE.

- Issue History
Date Modified Username Field Change
2011-03-14 13:10 plujan New Issue
2011-03-14 13:10 plujan Assigned To => alostale
2011-03-14 13:10 plujan Modules => Core
2011-03-14 13:14 alostale Status new => scheduled
2011-03-14 13:14 alostale Assigned To alostale => marvintm
2011-03-14 13:14 alostale fix_in_branch => pi
2011-03-14 16:03 iperdomo Target Version => 3.0RC5
2011-03-14 16:03 iperdomo fix_in_branch pi =>
2011-03-14 17:59 hgbot Checkin
2011-03-14 17:59 hgbot Note Added: 0034822
2011-03-14 17:59 hgbot Status scheduled => resolved
2011-03-14 17:59 hgbot Resolution open => fixed
2011-03-14 17:59 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd7e140444d77a460a27b0e6eb7beeaef72cfd20 [^]
2011-03-14 19:12 shuehner Note Added: 0034843
2011-03-14 19:12 shuehner Status resolved => closed
2011-03-15 00:00 anonymous sf_bug_id 0 => 3212145


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker