Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016263Openbravo ERPA. Platformpublic2011-03-14 13:102011-03-15 00:00
Reporterplujan 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0RC5Fixed 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
Summary0016263: 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)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-14 13:10plujanNew Issue
2011-03-14 13:10plujanAssigned To => alostale
2011-03-14 13:10plujanModules => Core
2011-03-14 13:14alostaleStatusnew => scheduled
2011-03-14 13:14alostaleAssigned Toalostale => marvintm
2011-03-14 13:14alostalefix_in_branch => pi
2011-03-14 16:03iperdomoTarget Version => 3.0RC5
2011-03-14 16:03iperdomofix_in_branchpi =>
2011-03-14 17:59hgbotCheckin
2011-03-14 17:59hgbotNote Added: 0034822
2011-03-14 17:59hgbotStatusscheduled => resolved
2011-03-14 17:59hgbotResolutionopen => fixed
2011-03-14 17:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd7e140444d77a460a27b0e6eb7beeaef72cfd20 [^]
2011-03-14 19:12shuehnerNote Added: 0034843
2011-03-14 19:12shuehnerStatusresolved => closed
2011-03-15 00:00anonymoussf_bug_id0 => 3212145

Notes
(0034822)
hgbot   
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   
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.