Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0037294Openbravo ERPA. Platformpublic2017-11-14 13:452017-11-17 15:34
malsasua 
inigosanchez 
normalminoralways
closedfixed 
5
 
3.0PR17Q3.23.0PR17Q3.2 
caristu
Core
Production - QA Approved
2017-04-06
3.0PR17Q3
https://code.openbravo.com/erp/devel/pi/rev/c4a5973bba10 [^]
No
0037294: It is not possible to do login using a role if the role has got a deactivated organization
when a role has got one deactivate organization, in Role > Org Access, it is not possible to do login. Error is returned:
Error occured: org.openbravo.base.exception.OBException: java.lang.IllegalArgumentException: Error when saving default values
in F&B:
. do login with user Openbravo
. go to Role:
  . record: F&B España, S.A - Employee
  . go to org access tab:
     . record: F&B España - Región Norte
       active='N'
. change the role to F&B España, S.A - Employee
Error is returned
Take into account the "is active" flag in the queries launched by RoleInfo class. Since the changeset[1] it is using a Query instead of an OBQuery to retrieve the role's organization and warehouses data.

[1] https://code.openbravo.com/erp/devel/pi/rev/c4a5973bba10 [^]
No tags attached.
blocks defect 0037289 closed inigosanchez It is not possible to do login using a role if the role has got a deactivated organization 
Issue History
2017-11-14 18:22caristuTypedefect => backport
2017-11-14 18:22caristuTarget Version => 3.0PR17Q3.2
2017-11-16 10:12inigosanchezAssigned Toplatform => inigosanchez
2017-11-16 12:36hgbotCheckin
2017-11-16 12:36hgbotNote Added: 0100549
2017-11-16 12:36hgbotStatusscheduled => resolved
2017-11-16 12:36hgbotResolutionopen => fixed
2017-11-16 12:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c [^]
2017-11-16 16:45caristuSeveritymajor => minor
2017-11-17 15:34caristuNote Added: 0100596
2017-11-17 15:34caristuStatusresolved => closed
2017-11-17 15:34caristuFixed in Version => 3.0PR17Q3.2

Notes
(0100549)
hgbot   
2017-11-16 12:36   
Repository: erp/backports/3.0PR17Q3.2
Changeset: 97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Thu Nov 16 12:36:03 2017 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR17Q3.2/rev/97ccc65883ae6d6fcf9c0f3fe01d14655ca71d3c [^]

Fixed issue 37294: Deactivated orgs are displayed in the user profile widget

The problem was caused by the "Improve scalability of the login process" project. When improving the performance
of the query that return the complete organizations list for the current user, the OBQuery instance used to generate it was
replaced with a Query instance. The first includes by default the filter by is active.

To fix the problem this filter must be added manually in the query. Now the problem has been resolved by take into
account this filter. Besides the same problem is detected in other query related with deactivated warehouses so it is fixed too.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/navigationbarcomponents/RoleInfo.java
---
(0100596)
caristu   
2017-11-17 15:34   
Code reviewed + tested OK.