Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0038600Openbravo ERP09. Financial managementpublic2018-05-22 18:482018-06-06 18:46
ReporterALopetegui 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0038600: Error trying to post a remittance without access to the table REM_RemittanceType
DescriptionError trying to post a remittance without access to the table REM_RemittanceType

Error log:

cdb72c84 2018-05-08 15:18:35,651 [ajp-nio-127.0.0.1-8009-exec-115] ERROR org.openbravo.erpCommon.ad_forms.AcctServer - An error ocurred posting RecordId: 7608FBDD852E4E3995EFD0F2955F59B2 - tableId: FF8080812E6C2859012E6D0271E1009D
org.openbravo.base.exception.OBSecurityException: Entity REM_RemittanceType is not directly readable, only id and identifier properties are readable, property REM_RemittanceType.postingAllowed is neither of these.
        at org.openbravo.base.structure.BaseOBObject.checkDerivedReadable(BaseOBObject.java:295)
        at org.openbravo.base.structure.BaseOBObject.get(BaseOBObject.java:255)
        at org.openbravo.base.structure.BaseOBObject.get(BaseOBObject.java:232)
        at org.openbravo.base.structure.BaseOBObject.get(BaseOBObject.java:213)
        at org.openbravo.module.remittance.RemittanceType.isPostingAllowed(RemittanceType.java:191)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:197)
        at org.openbravo.module.remittance.RemittanceType_$$_javassist_258.isPostingAllowed(RemittanceType_$$_javassist_258.java)
        at org.openbravo.module.remittance.ad_forms.DocREMRemittance.getDocumentConfirmation(DocREMRemittance.java:439)
        at org.openbravo.erpCommon.ad_forms.AcctServer.post(AcctServer.java:722)
        at org.openbravo.erpCommon.ad_actionButton.Posted.processButton(Posted.java:273)
        at org.openbravo.erpCommon.ad_actionButton.Posted.doPost(Posted.java:104)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:461)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        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:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
        at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1524)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1480)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
cdb72c84 2018-05-08 15:18:35,652 [ajp-nio-127.0.0.1-8009-exec-115] ERROR org.openbravo.erpCommon.ad_actionButton.Posted - Error captured:
java.lang.NullPointerException
        at org.openbravo.erpCommon.ad_actionButton.Posted.doPost(Posted.java:105)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(HttpBaseServlet.java:228)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(HttpSecureAppServlet.java:461)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(SessionExpirationFilter.java:66)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.utils.CharsetFilter.doFilter(CharsetFilter.java:35)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.openbravo.client.kernel.KernelFilter$1.doAction(KernelFilter.java:62)
        at org.openbravo.dal.core.ThreadHandler.run(ThreadHandler.java:46)
        at org.openbravo.client.kernel.KernelFilter.doFilter(KernelFilter.java:71)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        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:240)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
        at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1524)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1480)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Steps To ReproduceTry to post a remittance without access to the table REM_RemittanceType
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-05-22 18:48ALopeteguiNew Issue
2018-05-22 18:48ALopeteguiAssigned To => Triage Finance
2018-05-22 18:48ALopeteguiModules => Core
2018-05-22 18:48ALopeteguiTriggers an Emergency Pack => No
2018-05-23 20:21AtulOpenbravoStatusnew => scheduled
2018-05-23 20:21AtulOpenbravoNote Added: 0104665
2018-05-23 20:21AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2018-05-31 13:47ALopeteguiSummaryFound in BUT production - Error trying to post a remittance without access to the table REM_RemittanceType => Error trying to post a remittance without access to the table REM_RemittanceType
2018-05-31 13:47ALopeteguiDescription Updatedbug_revision_view_page.php?rev_id=17228#r17228
2018-06-06 18:45hgbotCheckin
2018-06-06 18:45hgbotNote Added: 0104986
2018-06-06 18:45hgbotStatusscheduled => resolved
2018-06-06 18:45hgbotResolutionopen => fixed
2018-06-06 18:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/46b4763e9bad11b484c9d4336cc0185f8ec71b78 [^]
2018-06-06 18:45hgbotCheckin
2018-06-06 18:45hgbotNote Added: 0104987
2018-06-06 18:46dmiguelezReview Assigned To => dmiguelez
2018-06-06 18:46dmiguelezNote Added: 0104988
2018-06-06 18:46dmiguelezStatusresolved => closed

Notes
(0104665)
AtulOpenbravo   
2018-05-23 20:21   
Test Plan

- Install Remittance module and apply dataset in F&B US Inc Organization.
- Navigate to Remittance Type and set Accounting tab information for "Printable Remittance" type.
- For F&B International Group Admin Role, from Window Access tab, delete record with window name "Remittance Type".
- Logout and Login.
- Navigate to Financial Account window, for "Bank Account 1" add record in payment method tab
- Create a Sales Invoice for any business partner, payment method = Printable Remittance". Add product and complete it.
- Add payment to the above invoice and note its documentno.
- Navigate to Payment In and select record with documentno noted in above step.
- Execute the Payment and go the Remittance window.
- Select record in Remittance with the payment created for previous sales invoice.
- Post the invoice and realize that it is posted successfully.
(0104986)
hgbot   
2018-06-06 18:45   
Repository: erp/mods/org.openbravo.module.remittance
Changeset: 46b4763e9bad11b484c9d4336cc0185f8ec71b78
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed May 23 23:38:27 2018 +0530
URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/46b4763e9bad11b484c9d4336cc0185f8ec71b78 [^]

Fixes Issue 38600: Found in BUT production - Error trying to post a
remittance without access to the table REM_RemittanceType

Use setAdminMode while accessing isPostingAllowed property of
Remittance Type of Remittance being posted

---
M src/org/openbravo/module/remittance/ad_forms/DocREMRemittance.java
---
(0104987)
hgbot   
2018-06-06 18:45   
Repository: erp/mods/org.openbravo.module.remittance
Changeset: fda9ff567206a3130fe5c882d6298ba7af11ebf0
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Jun 06 18:45:28 2018 +0200
URL: http://code.openbravo.com/erp/mods/org.openbravo.module.remittance/rev/fda9ff567206a3130fe5c882d6298ba7af11ebf0 [^]

Related to Issue 38600. Updated Module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0104988)
dmiguelez   
2018-06-06 18:46   
Code Review + Testing Ok